[DUG] Param Check and XSQLDA error

[Phil Middlemiss]

OK, thanks - I will have a closer look.

Paul McKenzie wrote:
> 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
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>
-------------- 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/bd0fd16d/phil.vcf