FiveTech Support Forums

James Bott wrote:I am not clear on this: if you do a oRS:delete() does it just delete the record in the recordset or does it automatically delete the record in the table on the server too? Or, is the record in the table only deleted when the recordset is updated (oRS:update())?

James

oRs:Delete() marks the current record in the recodset for deletion. Server does not yet know anything.

oRs:Update() ( update() is used to save changes to the server) actually deletes the record on the server.

NageswaraRao,

nageswaragunupudi wrote:oRs:Delete() marks the current record in the recodset for deletion. Server does not yet know anything.

oRs:Update() ( update() is used to save changes to the server) actually deletes the record on the server.

Sorry, but this is not true. oRs:Update() is not required. It could cause unpredictable results.

EMG

Hello,

This topic is very useful.

I would like to ask please what is the equivalent to the COUNT FOR in DBF:



Thank you very much. Best regards

Try this: