Fritzfrederix
Chemical
- May 28, 2003
- 63
Hello,
I'm strugling for a few days with a syntax error in some scripting code I wrote for Intouch.
I'm trying to connect to an SQLServer. I can connect and disconnect but when I'm trying the function SQLSelect I always get an faultmessage.
SQLConnect(ConnectionId_Connect,"Provider=MSDASQL;DSN=CLaSS_Production;UID=CLaSS;PWD=CLaSS;" );
Show "SQL";
SQLSelect( ConnectionId_Select, "BHI_Measering_Station,SQLConnect, WhereBale_Height=100" );
SQLDisconnect( ConnectionId_Disconnect );
What am I doing wrong?
BHI_Measering_Station is the tablename
SQLConnect is the name of the bindinglist
Bale_Height is the columnname
Rudi
I'm strugling for a few days with a syntax error in some scripting code I wrote for Intouch.
I'm trying to connect to an SQLServer. I can connect and disconnect but when I'm trying the function SQLSelect I always get an faultmessage.
SQLConnect(ConnectionId_Connect,"Provider=MSDASQL;DSN=CLaSS_Production;UID=CLaSS;PWD=CLaSS;" );
Show "SQL";
SQLSelect( ConnectionId_Select, "BHI_Measering_Station,SQLConnect, WhereBale_Height=100" );
SQLDisconnect( ConnectionId_Disconnect );
What am I doing wrong?
BHI_Measering_Station is the tablename
SQLConnect is the name of the bindinglist
Bale_Height is the columnname
Rudi
