Results 1 to 3 of 3

Thread: Update error

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 1999
    Location
    Ilirska Bistrica, Slovenia
    Posts
    242

    Unhappy

    Hello!

    I use DataEnvironment in my project and I encountered one quite strange error while updating records through my command which has about 10 parameters (values to update).
    When I first tried to update my record it was successful, but when I tried to update it again, it returned an error. Why dit VB return error if the first update was successful? Is this a bug or what?

    Error : -2147217913 - Data type mismatch in criteria expression
    Zvonko Bostjancic
    Ilirska Bistrica, Slovenia
    [email protected]
    Using VS6 Professional with SP3
    Programming mostly in VB and I've started to learn VC++ & MFC

  2. #2
    Hi send the code. we can check it out.
    Madhusudana Gorthi [email protected]
    Senior Software Engineer
    www.stgil.com

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Aug 1999
    Location
    Ilirska Bistrica, Slovenia
    Posts
    242
    I'd love to send it, but it's too complicated (about 40000 lines) and if I take out just that what's causing problems, it would take a lot of time.
    This command is just normal sql update statement with about 10 parameters (UPDATE Table SET Field1=?, Field2=?...)
    When I first execute it, it works fine, but when I try to execute it (with all necessary parameters) for the second time, it returns an error ("Data type mismatch in criteria expression"), but it makes no sense to me, cause if it worked fine before, it should work fine now too.
    Any idea?
    Zvonko Bostjancic
    Ilirska Bistrica, Slovenia
    [email protected]
    Using VS6 Professional with SP3
    Programming mostly in VB and I've started to learn VC++ & MFC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width