I'm trying to do a prepared select but i got a compiler error message
** External Compiler Module message
** ES0100 Incorrect SQL statement syntax near: into
what i've done is:
move "select pays from medecins where toubib = :fdbiljour-i8-toubib" to Stmtbuf
exec sql prepare stm_pays_medecin from :Stmtbuf end-exec
exec sql execute stm_pays_medecin into :wss-x2-pays using :wss-i8-toubib end-exec
I see in the documentation that there's no "into" in the "execute" syntax
So, how should i write this ?
This request only returns 1 line.
I'm using PostgreSQL
Thanks for asnwering