AddNew/Update command & field searches 
Author Message
 AddNew/Update command & field searches

Please help me I have two VB 3.0 problems

PROBLEM 1.) While using the AddNew / Update combination on a dynaset I
recieve a compile error on the line dsDynaSet.Update. Here is the error
msg

        "Reserved error (-18261);there is no message for this error"

Can anyone tell me what this means I believe my syntax is correct...here
is the actual src:

    'Add service record portion
    dsCurrServices.AddNew

    dsCurrServices.Fields("ServiceID") = GetNextServiceID()
    dsCurrServices.Fields("CarID") = CURR_CAR_ID
    dsCurrServices.Fields("Miles") = txtMiles.Text
    dsCurrServices.Fields("Part") = cboPart.Text
    dsCurrServices.Fields("Action") = cboAction.Text
    dsCurrServices.Fields("Notes") = txtNotes.Text
    dsCurrServices.Fields("ServiceCenterID")=3

    dsCurrServices.Update   'GET THE ERROR On THIS LINE

PROBLEM 2.) I need a very efficient way to do a partial search on a
table/dynaset. For ex. search a table for the first record that begins
with "bro" after the search the current record could be brooks,
brookstein, depending on what was the first rec encountered. Any ideas
on this using the standard VB tools. I want to create a searchable text
box that after every char typed in it does a search for a match in a
table/dynaset... kinda of like the quicken 3.0 quick search fields

please leave me e mail ...Thanks so much




Fri, 29 Aug 1997 08:12:19 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How do I gett the value of autoincrement field after an .AddNew/.Update

2. Counter Fields - value assigned on Addnew not Update?

3. How to get a field value after and AddNew command SQL 7.0 and VB 6

4. Using Variables for Field Names using .AddNew and .Update

5. locking issues with .AddNew & .Update

6. Searching and automatically updating fields

7. AddNew field assignments take long time for text fields

8. ADO Commands & Oracle FOR UPDATE

9. How in the &^#$&%#^%@# do you kill or stop or undo a started .AddNew event

10. Report Field Data Insertion & Update

11. unable to get data from Identity field after "AddNew" and "Update" command

12. Tab to search field on search engines

 

 
Powered by phpBB® Forum Software