Error symbol is undefined or unable to be referenced

[jipsi]

Hello

I have this message SQL Centura Windows/32:
"Error symbol is undefined or unable to be referenced from current location :col LPI_NUM"

but not systematik

somebody have an idea of the signification of this enigma?

thank's

jipsi

 

[ManuelPallas]

At First: don´t use spaces in variable- or object-names:
wrong: col LPI_NUM
correct: colLPI_NUM

then try to use the SqlVarSetup( SqlHandle ) function of SQLWindows before you execute the Sql-Statement in SQLWindows.

If you still have the same problem define a global variable for this column and set the column-value during the fetch-next-process:
f.e.:

Set sSQL = "Select name from info into :gv_sName"
If SqlPrepare( hSqlConnect, sSQL )
If SqlVarSetup( hSqlConnect )
If SqlExecute( hSqlConnect )
While SqlFetchNext( hSqlConnect, nFetch )
Set colName = gv_sName