Record will not delete

[Ruslan Zasukhin]

on 11/25/03 11:02 PM, Michael Krugman at admin at ktinet.net wrote:

> 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)

May be it must be as

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


It seems you have loose quotes.

> 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.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------