Ado Recordset saving

Ado Recordset saving

Post by Saurabh Sharm » Fri, 11 Aug 2000 04:00:00



Problem in update using ADO recordset schema.

Consider the following example

<Invoice No="12345" Date="20001212">
 <Supplier Name="Something" Address="Somewhere in the
world"/>
 <Items Code="abcd" Desc="Item 1" Qty="400.50" />
 <Items Code="efgh" Desc="Item 2" Qty="500.50" />
 <Items Code="ijkl" Desc="Item 3" Qty="600.50" />
</Invoice>

I need to update Qty of Item with Code "efgh" to "5000.45".

How would I go about it?

I had tried the following method:

<rs:data>
 <rs:update>
  <rs:orginal>
   <Invoice No="12345" Date="20001212">
    <Supplier Name="Something" Address="Somewhere in the
world"/>
    <Items Code="efgh" Desc="Item 2" Qty="500.50" />
  </rs:orginal>
    <Items Qty="5000.45" />
 </rs:update>
</Invoice>
</rs:data>

Is my syntax correct??  But I am not able to get the correct result?
In case I want to update the Invoice Details, my update is successful.

 
 
 

Ado Recordset saving

Post by dano » Mon, 14 Aug 2000 04:00:00


The format you show for the ADO persist format looks incorrect, i would
perform adds, deleted and edits on your record then save the recordset to a
file double check the format, should be obvious one you look for the
operations performed...

--

Thanks,

Dano d:)
Dan Doris


Quote:

>Problem in update using ADO recordset schema.

>Consider the following example

><Invoice No="12345" Date="20001212">
> <Supplier Name="Something" Address="Somewhere in the
>world"/>
> <Items Code="abcd" Desc="Item 1" Qty="400.50" />
> <Items Code="efgh" Desc="Item 2" Qty="500.50" />
> <Items Code="ijkl" Desc="Item 3" Qty="600.50" />
></Invoice>

>I need to update Qty of Item with Code "efgh" to "5000.45".

>How would I go about it?

>I had tried the following method:

><rs:data>
> <rs:update>
>  <rs:orginal>
>   <Invoice No="12345" Date="20001212">
>    <Supplier Name="Something" Address="Somewhere in the
>world"/>
>    <Items Code="efgh" Desc="Item 2" Qty="500.50" />
>  </rs:orginal>
>    <Items Qty="5000.45" />
> </rs:update>
></Invoice>
></rs:data>

>Is my syntax correct??  But I am not able to get the correct result?
>In case I want to update the Invoice Details, my update is successful.


 
 
 

1. ADO Mickey Mouse: ADO and RDO handling of temp tables

Contary to the article in TechNet
(http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q295743&
), ADO does not allow temporary tables to persist after the
calls to .execute.  Yet the same code works fine in RDO.

...
Set oConnection = New ADODB.Connection
oConnection.Execute "select * into #t from tbl_Whatever"
Set oResultSet = oConnection.Execute("select * from #t", ,
adCmdText)    'This line raises an error as #t cannot be found.
...

2. SQL installation

3. Using ADO 2.1 / ADOX / ADO 2.0 with C++

4. PL/SQL: best way to find and remove duplicate rows ( keep 1 row )

5. For all of you thar execute SP using ADO - Nulls terminate ADO connections

6. PSQL 2000 Requester and Btrieve 6.10 Netware: How to make it work together?

7. xpath ado vs ado.net properties

8. Memory leak with ADO and binding controls

9. Should I use ADO classes or place ADO code in forms

10. Collecting errors from ADO connection to SQL Server

11. Trimming ADO input parameters

12. Question... ADO and Oracle sequence generators...How do you reference them using ADO????

13. problems using ADO recordset