Guys, looking at ecpg from CVS HEAD's 7.4. The following code fragement: EXEC SQL INCLUDE sqlca; EXEC SQL WHENEVER SQLERROR call sqlprint;
void lofsdb_GetMinMaxRxStations(int *from, int *to) { EXEC SQL BEGIN DECLARE SECTION; int l_from = 0; int l_to = 0; EXEC SQL END DECLARE SECTION; *from = 0; *to = 0; EXEC SQL BEGIN; EXEC SQL SELECT MIN(from_station), MAX(to_station) INTO :l_from, :l_to FROM attr_tables WHERE basetab LIKE 'attr_rx_%'; if( sqlca.sqlcode == 0 ) { *from = l_from; *to = l_to; } EXEC SQL COMMIT; } when processed using: /var/lib/pgsql/74b/bin/ecpg -t -I/var/lib/pgsql/74b/include -o x.c x.pc results in the following error: x.pc:4: ERROR: syntax error at or near "to" However this works ok on 7.3.x and when the "to" variable is renamed (e.g. to "to_rx"). Obviously TO is an SQL keyword, but it's not being used within an EXEC SQL definition, so shouldn't break things. Regards, Lee. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly