[marquezs]

static query_ins[512];
		formatex(query, sizeof(query_ins) - 1,"INSERT INTO `%s` (`%s`, `%s`, `%s`, `%s`, `%s`, CURRENT_TIMESTAMP, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`)\
		VALUES ('%i', '%s', '%i', '%i' ,'%i' ,'%s', '%s', '%i', '%i', '%i', '%i', '%i')",\
		BALELOS1, BALELOS3, BALELOS4, BALELOS2, BALELOS5, BALELOS6, BALELOS7, BALELOS8, BALELOS9, BALELOS10, BALELOS11,\
		BALELOS12, BALELOS13, BALELOS14,value1, value12, value13, value14, value15, value16, value17, value18, value19,\
		value111, value122, value133)

BALELOS1,2,3,4... are defines with the name of the column. all columns have at least 4 characters.

Then we have the value1,2,3... most of them are integers and some are strings with at least 10 characters.

I've tried increasing the size of the array but I have always this error when I try to compile:

Error: Input line too long (after substitutions) on line 197


Thanks.

[Sylwester]

You should add it to string in parts like this:

PHP Code:

static query_ins[1024];
new pos
pos += formatex(query_ins[pos], sizeof(query_ins) - 1 - pos, "INSERT INTO `%s` (`%s`, `%s`, `%s`, `%s`, `%s`, ",BALELOS1, BALELOS3, BALELOS4, BALELOS2, BALELOS5, BALELOS6)
pos += formatex(query_ins[pos], sizeof(query_ins) - 1 - pos, "CURRENT_TIMESTAMP, `%s`, `%s`, `%s`, `%s`, `%s`, ", BALELOS7, BALELOS8, BALELOS9, BALELOS10, BALELOS11)
pos += formatex(query_ins[pos], sizeof(query_ins) - 1 - pos, "`%s`, `%s`, `%s`)VALUES ('%i', '%s', '%i', ",BALELOS12, BALELOS13, BALELOS14,value1, value12, value13)
pos += formatex(query_ins[pos], sizeof(query_ins) - 1 - pos, "'%i' ,'%i' ,'%s', '%s', '%i', '%i', '%i', '%i', '%i')", value14, value15, value16, value17, value18, value19, value111, value122, value133) 


[marquezs]

Thanks! It works now