TDataRow and ADO questions

[nageswaragunupudi]

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.

[Enrico Maria Giordano]

NageswaraRao,

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

[lucasdebeltran]

Hello,

This topic is very useful.

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

Code: Select all  Expand view

COUNT FOR FIELD->OTRO=.T. TO nOtro.
 

Thank you very much. Best regards

[Marc Vanzegbroeck]

Try this:

Code: Select all  Expand view

oSQL:Query( "select count(*) AS NumberOfRecords from yourtable WHERE OTRO = '1'") )