Board index » delphi » I get a "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" exception...

I get a "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" exception...


2003-09-03 05:54:56 PM
delphi201
Does anybody know what's this about? Let me explain the situation.
The application is a server listening for connections from about 60 clients
(so, 60 threads waiting for data).
This clients send through a socket commands that produce inserts to the
database located at the server. These inserts are always the same, the only
variation is the parameters, so I have a DataModule with 3 parametrized
queries (there are three kinds of inserts).
When a thread receives a command, it locks the query using a
TCriticalSection, sets the parameters and sends this query to another
thread, which has a queue of pending queries to execute. This thread makes a
clone of the query and encues it. After that, the first thread releases the
CriticalSection.
This usually goes fine, but, after a while (depending on the frequency that
the clients send commands) it produces an exception with the text:
"Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another". It only does it once, after this exception the
application runs fine... strangely, I put all the sentences in a try except
block and the except sentences aren't executed... I have tried with a
breakpoint and also a showmessage, but it seems that it doesn't execute
them...
After receiving the exception, I have introduced the insert sentence by myself
at the SqlServer query analizer, and it worked ok, so I don't have any idea
of what's this all about...
Any idea??
Thanks!
Arnau.
 
 

Re:I get a "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another" exception...

<snip></snip>
I have no idea how to fix this but a simple search on www.tamaracka.com
using the below results in lots of matches, might be worth you reading
through and seeing if any of these previous posts help.
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another