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
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

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



begin:vcard
fn:Phil Middlemiss
n:Middlemiss;Phil
org:Vision Software, MTS Ltd
email;internet:[EMAIL PROTECTED]
title:Project Leader
tel;work:+64 7 3480001
tel;cell:+64 27 4592648
x-mozilla-html:TRUE
url:http://www.tumonz.co.nz
version:2.1
end:vcard

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

Reply via email to