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