Kim,
While the MySQL syntax doesn't work with RealSQLDatabase, you gave me
some other ideas and finally got it to work with the following code
(in case you ever use RB's own DB):
rs=myDB.SQLSelect("select * from DxCode where DxId= '"+DXList.cell
(DXList.ListIndex,0)+"'")
Thanks!
E
On Jul 7, 2006, at 4:41 PM, Kim Kohen wrote:
On 08/07/2006, at 8:00 AM, Elvin S. Rodríguez wrote:
rs=myDB.SQLSelect("select * from DxCode where DxId="+DXList.cell
(DXList.ListIndex,0))
••••
I don't use the real db but if this was MySQL it would need single
quotes around the criteria.
eg. rs=myDB.SQLSelect("select * from DxCode where DxId=
'"+DXList.cell(DXList.ListIndex,0)) + "';"
cheers
k
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
