Record will not delete

[Michael Krugman]

Hi Rusian:

I think I've found the problem...just not the solution: In the 
following line of code,

curs = mDataBase.SQLSelect("SELECT recID, * FROM Customers WHERE 
recID=" + id)

I do not have the permissions set.  "id" represents the first field in 
my listbox.  When this line of code runs, it takes the value of the 
recID, which is 0, then adds the value of "id" to it to point me to the 
right record in the cursor.  This worked using the old RBDB.

In this line of code,

curs = mDataBase.SQLSelect("SELECT recID,* FROM Customers WHERE recID = 
0+id,kServer,kReadWrite)

the permissions are set, BUT recID = 0 + id will not provide me any 
value to point the cursor to, because of the additions of 
kServer,kReadWrite.  No errors are given, but without the value, the 
cursor is not pointed to any record, so I can't delete anything.

Can you suggest a workaround for this, as I'm going to need the value 
and the permissions for this to work.

Mike