Printable View
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
Hi send the code. we can check it out.
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?