Updating data into ADO Fields 
Author Message
 Updating data into ADO Fields

I have a program which i wrote, using VB6 as the development lang. Oracle
7.3.... . I was updating data into a table, using the format

With rsTemp
    .AddNew
        !Field1 = Value1
        !Field2 = Value2
        .
        .
        .
    .Update
End With

This was working fine. Then one day i opened up the project, and didnt even
make any changes yet, just tried running the program, and now it doesnt
work. It updates most of the fields, with one or two exceptions. When it
gets to those fields, i get the wonderful ADO error  <Errors Occured> . Does
anyone have any experience with this error, why it might be happening? The
fields are nothing special, not indexed, not keys, nothing like that.

Any help **greatly** appreciated, TIA
--

Aaron





Fri, 25 May 2001 03:00:00 GMT
 Updating data into ADO Fields

Aaron,
    when the error occurs try moving through the ADO error object
collection.  This should narrow it down a bit more to what the issue is.

Regards, Leigh

Quote:

>I have a program which i wrote, using VB6 as the development lang. Oracle
>7.3.... . I was updating data into a table, using the format

>With rsTemp
>    .AddNew
>        !Field1 = Value1
>        !Field2 = Value2
>        .
>        .
>        .
>    .Update
>End With

>This was working fine. Then one day i opened up the project, and didnt even
>make any changes yet, just tried running the program, and now it doesnt
>work. It updates most of the fields, with one or two exceptions. When it
>gets to those fields, i get the wonderful ADO error  <Errors Occured> .
Does
>anyone have any experience with this error, why it might be happening? The
>fields are nothing special, not indexed, not keys, nothing like that.

>Any help **greatly** appreciated, TIA
>--

>Aaron






Sat, 26 May 2001 03:00:00 GMT
 Updating data into ADO Fields
I've always had much better success with using INSERT SQL statements rather
than using the Update method.

Set rcTemp = New ADODB.Connection
' setup rcTemp

rcTemp.Execute "INSERT INTO myTable (Field1, Field2...) VALUES (Value1,
'Value2'...)"

ADO and RDO are usually much more forthcoming with descriptive errors when
using this method.

--
John Tabor

http://members.bellatlantic.net/~jftabor
___________

Quote:

>This was working fine. Then one day i opened up the project, and didnt even
>make any changes yet, just tried running the program, and now it doesnt
>work. It updates most of the fields, with one or two exceptions. When it
>gets to those fields, i get the wonderful ADO error  <Errors Occured> .
Does
>anyone have any experience with this error, why it might be happening? The
>fields are nothing special, not indexed, not keys, nothing like that.



Mon, 28 May 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Updating data into ADO Fields

2. How to update datetime field with NULL using ADO update

3. Updating data to a memo field using SQL UPDATE

4. Saving TMemo field data to a Blob field (Interbase Table) via SQL Update Query

5. Update field with other fields data minus one day

6. Update a field with time stamp when other field are updated

7. ADO Update of Memo Fields

8. VB5/ADO/SQL 6.5 currency field update fails?

9. Update a date-field with ADO

10. how to update a Numeric field in a table using VB6 ADO

11. Error message when updating TEXT field via VB/ADO


 
Powered by phpBB® Forum Software