|
-
Aug 27th, 2000, 09:12 AM
#1
Thread Starter
Addicted Member
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
-
Aug 27th, 2000, 09:18 AM
#2
Member
Hi send the code. we can check it out.
-
Aug 28th, 2000, 03:54 AM
#3
Thread Starter
Addicted Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|