ECPG: 7.4 and a "to" Variable
От | Lee Kindness |
---|---|
Тема | ECPG: 7.4 and a "to" Variable |
Дата | |
Msg-id | 16170.18847.811096.853470@kelvin.csl.co.uk обсуждение исходный текст |
Ответы |
Re: ECPG: 7.4 and a "to" Variable
|
Список | pgsql-interfaces |
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; EXECSQL 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 basetabLIKE '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.
В списке pgsql-interfaces по дате отправления: