>sorted
>
>>SQLEXEC(gnhandle,select * from vizkeys where realkey='whatever',real)
>
>should be
>
>SQLEXEC(gnhandle,"select * from vizkeys where realkey='whatever'","real")
>
>works a treat.
>
>Thanks
Harry,
To make your life easier in the future :)
m.Search = 'whatever'
SQLEXEC(gnhandle,"select * from vizkeys where realkey=?m.Search","real")
-Using like this (parametric) you don't need to change/hardcode for different search values, hence could make this a prepared statement with SQLPrepare to gain speed. ie:
SQLPrepare(lnHandle,"select * from vizkeys where realkey=?m.Search","real")
m.Search = 'whatever'
SQLExec(lnHandle)
browse
m.Search = 'another'
SQLExec(lnHandle)
browse
SQLDisconnect(lnHandle)
-Pass large data. ie:
create cursor myTemp (myMemo m)
insert into myTemp FileToStr('myBigFile.txt')
*Or: lcMyText = FileToStr('myBigFile.txt')
SQLExec(lnHandle,'insert into SomeTable (textField) values (?myTemp.myMemo)')
-Manage multiple items easily and w/o a need to do type conversion that SQL server understand :
ldStart = date()-90
ldEnd = date()
lcCustomerID = 'ANATR'
* Other vars if any ...
SQLExec(lnHandle,'select * from Northwind.dbo.orders'+;
' where customerID = ?m.lcCustomerID and '+;
' orderDate between ?m.ldStart and ?m.ldEnd','myOrders')
PS:Notice that SQL datatype is one of datetime types, implicit conversion is done for you.
Cetin