[DUG] Param Check and XSQLDA error

[Paul McKenzie]

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
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi