>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