[DUG] Param Check and XSQLDA error

Phil Middlemiss phil at tumonz.co.nz
Mon Sep 11 09:40:32 NZST 2006


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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: phil.vcf
Type: text/x-vcard
Size: 250 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060911/912cc077/phil.vcf


More information about the Delphi mailing list