Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Intouch syntax problem

Status
Not open for further replies.

Fritzfrederix

Chemical
Joined
May 28, 2003
Messages
63
Location
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top