>cConnString = "DRIVER={SQL Server};SERVER=xxx.xxx.xx.xx;database=testdb;uid=sa;pwd=password" > >nSqlHandle = SQLSTRINGCONNECT(cConnString,.t.) >>
>? SQLEXEC(nSqlHandle,"select b2b from clients where retailerid='100' and password='password'") >? b2b >>
>CREATE PROCEDURE dbo.SEL_AllowB2B AS >select b2b from clients where retailerid = '100' and password = 'password' >GO >>
>? SQLEXEC(nSqlHandle,'SEL_AllowB2B') >>
? SQLEXEC(nSqlHandle,'EXEC dbo.SEL_AllowB2B')