>Is there a way to use the $ operator with a CursorAdapter loading from MS SQL? I want to say:
>
>uniqid+'*' $ thisform.cString
>
>where thisform.cstring='1000*1002*1003*'
>
>UNIQID IN (?c1,?c2,?c3) won't work because the list of uniqid's may be 0 - 100's of uniqid's long.
>
>Thanks
>
>bonnie

Bonnie,
You can create an 'In' query like this:

cString = "1000*1001*1002*"

Create Table tempIDs (myId c(4))
ALines(aString,m.cString,.t.,'*')
Dimension aString[Alen(aString),1]
Insert into tempIds from array aString
use

Text to m.lcSQL textmerge noshow
Select * from myTable as remoteTable
 inner join
 OpenRowSet('VFPOLEDB','<<Sys(5)+Curdir()>>';'';'',
 'select myId from tempIds') as localTable
 On remoteTable.personId = localTable.myId
endtext

lnHandle=SQLStringConnect('DRIVER=SQL Server;SERVER=server;Trusted_connection=Yes')
SQLExec(lnHandle, "use myDatabase")
SQLExec(lnHandle, m.lcSQL,'myCursor')
SQLDisconnect(lnHandle)
Erase ('tempIDs.dbf')
Select myCursor
browse

Cetin




Cetin