Database works on 4.5.2
Chuck
rwc1717 at shaw.ca
Sat Jan 24 13:39:11 CST 2004
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?
Thanks Chuck
More information about the Valentina
mailing list