Diferencia entre oRs:save y oRs:update

[artu01]

Gente utilizo ADO para trabajar con tablas de sql server
Mi duda es algunas veces me funciona el oRs:save pero a veces bota error y no se el motivo, pero si utilizo oRs:Update siempre funciona

Cuando debo de utilizar cada una de ellas?

Estoy con la version fwh 17.12

[nageswaragunupudi]

ADO RecordSet methods are independent of FWH version and they behave the same across all versions of FWH.

Use oRs:Update() method ( not Save() method ) to save any changes in the data.
There are two ways of using.

1)

Code: Select all

oRs:Fields( "city" ):Value := "London"
oRs:Fields( "Age"  ):Value := 34
oRs:Update()  // writes the above changes to the server.
 

2)

Code: Select all

oRs:Update( { "city", "age" }, { "London", 34 } )
// This changes and values and also writes the changes to the server.
 

Method oRs:Save()
This method is used to save contents of RecordSets to Disk in either XML format of ADTG (micorosoft proprietory) format

Code: Select all

oRs:Save( "c:\folder\filename.adtg", 0 )
oRs:Save( "c:\folder\filename.xml",  1 )
 

Here you find all datas and methods of ADO RecordSet object:
https://www.w3schools.com/asp/ado_ref_recordset.asp

Better we completely go though this tutorial, before working with ADO
https://www.w3schools.com/asp/ado_intro.asp

[artu01]

Thank you Master
i had seen posts in this forum using the method save of this way

Code: Select all

 oRS:Fields( 'Descri' ):value:=cDescri
 oRs:Save()
 

i myself have checked that it works but not always (that was the reason for my question)

Using the method update() never fail

Code: Select all

 
oRS:Fields( 'Descri' ):value:=cDescri
oRS:Update()
 

[nageswaragunupudi]

Thank you Master
i had seen posts in this forum using the method save of this way

Code: Select all

 oRS:Fields( 'Descri' ):value:=cDescri
 oRs:Save()
 

i myself have checked that it works but not always (that was the reason for my question)

Using the method update() never fail

Code: Select all

 
oRS:Fields( 'Descri' ):value:=cDescri
oRS:Update()
 

oRs:Save() never writes data to the server.
When record pointer is moved, oRs:Update() is automatically executed without your knowledge.

Note:
FWH MariaDB library uses both Save() and Update() for writing changes to the server. That is not ADO.

[artu01]

It's understood Mr. Rao
Thank you