Actually, you need to make two calls.

One call with an invalid value and one call with a valid value.

This is what I added to your sample app in order to work around this issue:

procedure TFormMain.cnMainAfterConnect(Sender: TIB_Connection);

begin

  cnMain.SchemaCache.GetDomainName( 'z', 'z' );

  cnMain.SchemaCache.GetDomainName( 'SPORDERCUSSUM', 'CUS_ID' );

end;

Please let me know if this doesn’t make sense and you need more help.

Thanks,

Jason Wharton

www.ibobjects.com

I’m working with the sample app and seeing the problem.

I have an idea what is causing it and a work-around is to do as follows:

Put a call in the connection’s AfterConnect event that calls this method:

  cnMain.SchemaCache.GetDomainName( 'z', 'z' );

What needs to happen is the cursor for handling domain names needs to be prepared before you attempt to prepare your statement.

It doesn’t matter what values you pass into that procedure as the important thing is that the internal query is prepared.

I’ll have a permanent fix for this in the next sub-release.

Thanks!

Jason Wharton

How do I get CheckParams in a TIB_Query?

select   CUS_ID, CUS_STATE

from spordercussum(CAST(:a AS INTEGER), CAST(:b AS INTEGER), CAST(:c AS CHAR(15)))

What is wrong with this query??????????

I upgraded to the new version 5.7.11 2388 still the same problem.

For a Sample program download and run

test4.zip

Contains Source and an Executable,

extract it and run Invview.exe check the

user, password and then Push "Connect DB"

Then push "btPrepare" to generate the error.