Subject Re: [IBO] Odd TIB_Cursor problem in 4.8.7
Author Helen Borrie
At 09:16 AM 7/07/2008, you wrote:
>> With all these messages it sounds a bit befuddled. Did you upgrade
>to v.4.8.7 because you upgrade to Fb 2 or 2.1?
>
>No, I'm still using 1.54 currently, but I plan to upgrade to FB v2.x
>shortly.
>
>I've deleted the TIB_Connection and TIB_Transaction and recreated them
>and my code boils down to this:
>
>pCur->SQL->Text = "Select USER_ID from USERS where
>USER_NAME=:USER_NAME and PW=:PW";
>
>pCur->Prepare();
>
>TIB_Column * pColFP = pCur->FindParam( "USER_NAME");
>TIB_Column * pColPBN = pCur->ParamByName("USER_NAME");
>
>FindParam returns a column, but ParamByName returns NULL.
>
>Creating another app and pasting in the code works, I just cannot find
>out why it's failing here.

Something undesirable, such as an obsolete default, is "sticking" in the DFM, I suppose. What is the failure?

That said, I've been using and recompiling legacy IBO projects with Fb 1.5.x, throughout the entire release cycle, up to and including 4.8.7, without seeing any problems. Delphi, though. But nothing newer than Delphi 7.

One thing to ask about 'cause people sometime overlook it - what's your setting for OldParameterOrdering in firebird.conf? It should **not** be set on for Fb 1.5 and latter IBO versions...

Helen