Record will not delete

[Michael Krugman]

Hi Rusian:

I've tried it this way also...With the quote after recID= ", the SELECT 
statement thinks that this is all that is included.  +id,kServer and 
kReadWrite are no longer part of the statement, so I get the "there is 
no method or property with this name" error...

Mike
On Nov 25, 2003, at 3:26 PM, Ruslan Zasukhin wrote:

> 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
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>