OPO SQL-string (with into) problem

I have the following problem when using string with EXEC SQL I have following code in the click() method av a button:

dim vsqlstring as string
dim vsqlstring1 as string
dim vsqlstring2 as string
x=1

vSqlstring1=(" select p")
vSqlstring2=(" into :vtro from tblpercentil where deltest = 'GP:A'") vSqlstring=vsqlstring1 &x &vsqlstring2

exec sql AT SESSGPI :vsqlstring
vsqlerrtext=sqlerrtext()
msgbox sqlerrtext

The result in sqlerrtext is: "SQL-00021: Expecting from, got into" (it works without the "into" statement)

If a use EXEC SQL defining the statement without a string everything works perfect, but as soon as I use a string (i.e. :vSQLstring) with the "into" statement the error occur.

I have OPO 1.0.4. I hope I have missed something out .....

Thomas Holjo -> THHO9405_at_student.uu.se Student
Uppsala Universitet
Sweden Received on Sun Mar 17 1996 - 00:00:00 CET