Ok we are using Forms 3-Tier not Web but...

We get this everynow and then when coding - caused by doing something silly 
with the parameters
eg. parameters mismatch expecting Integer and getting String - that sort of 
thing.
Just a case of looking for the very obvious with the parameters.

The extremely obvious if often overlooked :-)

Regards
Paul McKenzie
Wellington
New Zealand


Phil Middlemiss wrote:
Hi all,

Every now and then I get an exception when trying to post an SQL command:

"XSQLDA index out of range"

which, according to Google is related to the ParamCheck property of the TIBSQL. The help says that (for my situation) I should have it set to True - which I do. And yet I still get the exception every once and a while. This is quite a problem because it's part of an online order system that processes the user's credit card first before trying to save the order to the DB.

My first impulse is to manually clear the Params list each time before forming the SQL query but I thought I had better check first to see if anyone knows exactly what the problem here is.

Cheers,
Phil.

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to