citect scada and sql

[salamplc]

citect scada

You need to change the SQLExec to this I think

SQLExec(hSQL, "SELECT * FROM FETISH WHERE SURNAME = 'Jumpy'");
If SQLNext(hSQL) = 0 Then
sName = SQLGetField( hSQL, "CNAME" );

END

hi
thank you for your reply
i tested this command but i could not get data from database and did not show it in textbox

 

[sigmadelta]

Did you check your DSN? Go to Control Panel -> Administrative Tools -> ODBC Data Sources (32-bit then 64-bit) and...

Check that the "impaytere_ss" exists either under User DSN or System DSN, and that all the properties are correct.

 

[parky]

I assume your error handling is working or you would get an error, Can you step through the code by creating a breakpoint, most VB code has a facility where you set a breakpoint (usually highlighted in brown), run code until breakpoint then step through (usually F8). If you step through then see if it actually goes into the GetField and see if anything appears in the Sname, There are a few scenarios, It is not finding the Surname, The variable SName is not tied to the citec field, the code is bypassing the getField etc.
I ran the code in SQLServer Express as a query and it worked.