Database works on 4.5.2

[Ruslan Zasukhin]

on 1/24/04 8:39 PM, Chuck at rwc1717 at shaw.ca wrote:

> Hi Ruslan:
> I tried your examples, I was able to delete & update in your examples,
> however I couldn't find any that mimic what I am doing exactly...
> I search the database using....for a record
> rs = VCursor
> res as Boolean
> rs = Nil
> rs = mDB.SQLSelect("select * from active where id ='"uid"'")
> if rs.recordcount > 0 then
> res = rs.delete
> end if
> mDb.Flush
> 
> or instead of deleting I try to use the following method for updating.....
> 
> rs.Field("dateset").SetString("an edited date")
> rs.Field("descript").SetString("an edited message)
> rs.Field("aptime").SetString("an edited time")
> rs.Filed("id").SetString("old id number")
> res= rs.Update
> mDb.Flush
> 
> Neither does babkiss, rien, nada...moreover in 4.5.2 it works flawlessly.
> 
> Any Ideas?

Yes of course, Chuck.

I think problem NOT in RB 4.5.2 or 5.x

As I see you have forget specify LockParameters in the cursor

> rs = mDB.SQLSelect("select * from active where id ='"uid"'")
                                            ^^^^^^^^^^^^^^^^^^^^^^^^^

Please read docs on this function SQLSelect


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