Jerry Sands schrieb:
> Where can I get a copy of the latest IBOAdmin for Delphi 2009 / Delphi 2010
> in a single ZIP file?
>
>
>
> Thanks
>
>
>
> Jerry Sands
>
>

1. Check out the subversion repository (for example with TortoiseSVN):
https://ibobjects.svn.sourceforge.net/svnroot/ibobjects/trunk/iboadmin

OR

2. The Repository dir /trunk/iboadmin can be downloaded from sourceforge:
http://ibobjects.svn.sourceforge.net/viewvc/ibobjects/trunk/iboadmin.tar.gz?view\
=tar

If someone has problems with iboadmin please give a bugreport here or
in sourceforge.

--
Andreas

Is it possible to have a image .BMP as a background for a TIB_Grid control ?

Thanks,

Marcos

Marcos,

> Is it possible to have a image .BMP as a background for a TIB_Grid control
> ?

I don't have a handy property to make it easy.
You can get in the code and see if you can make it work.
I doubt it will be terribly difficult to accomplish.

Let me know if you get into the code and cannot make sense of something.

Jason Wharton

Installer indicated it was installing to D2010, but after it finished, there
were no palette entries.

This is on 64 bit Windows 7 Professional

Hi,
i tried to install IBO4.9 in D2010 TRIAL.
During install i get message, that the IBO packages can't be compiled (Log says:
'Command line tools are not supported in the trial version').
Ok, accepted.

I then tried to compile the IBO-packages in D2010 myself.
There i get error message 'ib_components.dcu not found'.

In IBO directory there is only a ib_components.int! No ib_components.pas or
.dcu.

What can i do?

Regards
Falko

Apparently I need to make a version for evaluation that has the DCU's
already in it.

GIve me a couple days and I'll have this worked out.

Thanks for bringing this to my attention.

Jason

----- Original Message -----
From: "bausufm" <bausufm@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, November 12, 2009 2:18 AM
Subject: [IBO] Can't install IBO4.9 in D2010 Trial


> Hi,
> i tried to install IBO4.9 in D2010 TRIAL.
> During install i get message, that the IBO packages can't be compiled (Log
> says: 'Command line tools are not supported in the trial version').
> Ok, accepted.
>
> I then tried to compile the IBO-packages in D2010 myself.
> There i get error message 'ib_components.dcu not found'.
>
> In IBO directory there is only a ib_components.int! No ib_components.pas
> or .dcu.
>
> What can i do?
>
> Regards
> Falko
>
>

It's great to see IBO supporting Firebird/2 and Delphi/2010!

I see there is a lot of updating waiting to be done on the IBO site,
here are a few comments:

*  It says IBO/4.9 supports Firebird/2.0.
What about Firebird/2.x (at least 2.1) ?

*  The link at "LATEST RELEASE" (v.4.9.7)
I only see release notes for IBO/4.8

* Some benefits of IB Objects.
Support for D2009 is announced for Q4 2008 (!)


*  IB_SQL
Is this utility upgraded?  I use it a lot, but there seems to be some
problems with Fb/2.1 databases.
One thing that I find _very_ annoying is the links provided
(underlined, blue font) in the BROWSE panel.  I hardly ever want to
bring up a table by clicking on a field.  Moreover, the table that is
displayed is most often not relevant.  It would be nice if this
feature could be disabled (without me recompiling the project).


--
Aage J.

My account still shows expired.

Is Jason still having problems with his server?

Thanks
Steve Fields

Yes, I have not received my hard disk back from the recovery people.
Contact me privately and I'll get you taken care of.
Jason

----- Original Message -----
From: "Steve" <stevefields24@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, November 16, 2009 9:35 AM
Subject: [IBO] Any idea when IBO 4.9.7 will be available?


> My account still shows expired.
>
> Is Jason still having problems with his server?
>
> Thanks
> Steve Fields

Hi friends,

   Does anybody know how can i change the bitmap that is presente in IB_GRID, i
am talking about then bitmap of indicaterow´s (present on left on fixedcol)


Carlos Daniel

Hello Jason:

I renewed my subscription on Sep 02, 2009 invoice no: WEB107641

I can not download the latest release. Thanks for your help.

Regards,

Hiram Falcon
Lady Lynn Development, Inc.

Hi

i have at the moment 4.9.6 installed in Delphi 2010.
I have downloaded the 4.9.7 installer.

Should I just install the new version, or do I have to uninstall precious
version first?

Michael

Hi,
we use IBO 4.9.7 with Delphi 6 on FB 1.03/2.13

With TIBOQuery, TdataSource and the standard DBgrid from Delphi i recieve an
access violation if i display a boolean field (InternalGetFieldData in
GetFieldData from IboDataSet create the access violation).

SQL statement: select BOOLFIELD from XTABLE (the column BOOLFIELD is defined as
CHAR(1))
In the columnattributes from IBOQuery the Column BOOLFIELD are defined as
boolean field (T=True, F=False).

All other columns works correctly with TDataSource.

Who can help me?

thanks a lot
Luis

> i have at the moment 4.9.6 installed in Delphi 2010.
> I have downloaded the 4.9.7 installer.
>
> Should I just install the new version, or do I have to uninstall precious
> version first?


The installation has a clean sweep of previous installations built into it.
I have not yet built an uninstaller because deleting the files and telling
Delphi not to load the packages anymore does it for you.

You definitely should move to 4.9.7 as all previous 4.9.x versions have BLOB
columns broken.

Regards,
Jason Wharton

> we use IBO 4.9.7 with Delphi 6 on FB 1.03/2.13
>
> With TIBOQuery, TdataSource and the standard DBgrid from Delphi i recieve
> an access violation if i display a boolean field (InternalGetFieldData in
> GetFieldData from IboDataSet create the access violation).
>
> SQL statement: select BOOLFIELD from XTABLE (the column BOOLFIELD is
> defined as CHAR(1))
> In the columnattributes from IBOQuery the Column BOOLFIELD are defined as
> boolean field (T=True, F=False).
>
> All other columns works correctly with TDataSource.
>
> Who can help me?

If you have a minute, please send a little sample app to me. I'll likely get
this resolved Monday so I'd like to have something ready and waiting to save
me the time.

Thanks,
Jason Wharton

Hi Jason,
in this support list i cann't send a sample application.
Thanks
Luis

--- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@...> wrote:
>
> > we use IBO 4.9.7 with Delphi 6 on FB 1.03/2.13
> >
> > With TIBOQuery, TdataSource and the standard DBgrid from Delphi i recieve
> > an access violation if i display a boolean field (InternalGetFieldData in
> > GetFieldData from IboDataSet create the access violation).
> >
> > SQL statement: select BOOLFIELD from XTABLE (the column BOOLFIELD is
> > defined as CHAR(1))
> > In the columnattributes from IBOQuery the Column BOOLFIELD are defined as
> > boolean field (T=True, F=False).
> >
> > All other columns works correctly with TDataSource.
> >
> > Who can help me?
>
> If you have a minute, please send a little sample app to me. I'll likely get
> this resolved Monday so I'd like to have something ready and waiting to save
> me the time.
>
> Thanks,
> Jason Wharton
>

Hi Jason,
i have saved the sample app in the folder "files":
testprog.zip
IBO 4.9.7 - IBOQuery and boolean fields make access violation
Thanks
Luis

--- In IBObjects@yahoogroups.com, "luis.kerschbaumer" <luis.kerschbaumer@...>
wrote:
>
> Hi Jason,
> in this support list i cann't send a sample application.
> Thanks
> Luis
>
> --- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@> wrote:
> >
> > > we use IBO 4.9.7 with Delphi 6 on FB 1.03/2.13
> > >
> > > With TIBOQuery, TdataSource and the standard DBgrid from Delphi i recieve
> > > an access violation if i display a boolean field (InternalGetFieldData in
> > > GetFieldData from IboDataSet create the access violation).
> > >
> > > SQL statement: select BOOLFIELD from XTABLE (the column BOOLFIELD is
> > > defined as CHAR(1))
> > > In the columnattributes from IBOQuery the Column BOOLFIELD are defined as
> > > boolean field (T=True, F=False).
> > >
> > > All other columns works correctly with TDataSource.
> > >
> > > Who can help me?
> >
> > If you have a minute, please send a little sample app to me. I'll likely get
> > this resolved Monday so I'd like to have something ready and waiting to save
> > me the time.
> >
> > Thanks,
> > Jason Wharton
> >
>

I am presenting three sessions at the upcomming conference under the direction
of Bob Swart (a.k.a. Dr. Bob) at the Netherlands.

Please see http://www/sdn.nl for more information about the event.

One entire session will be dedicated to IB Objects. Another to Firebird in
general and another to converting file based systems to Firebird client/server
and multi-tier systems.

PS. You can also see a picture of me with a beard and mustache on their site
since they demanded a recent picture. I'm a mountain man now. <g>

Regards,
Jason Wharton






[Non-text portions of this message have been removed]

Jason,

The link should be http://www.sdn.nl

I can't see any pictures of you with a beard.  I guess the organizers thought it
might frighten people.

Roger Vellacott
Passfield Data Systems Ltd
Tel +44 1404 514402
Mob +44 7831 156839

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of
Jason Wharton
Sent: 24 November 2009 23:08
To: IBObjects@yahoogroups.com
Subject: [IBO] SDN Conference presentations (December 14, 2009)



I am presenting three sessions at the upcomming conference under the direction
of Bob Swart (a.k.a. Dr. Bob) at the Netherlands.

Please see http://www/sdn.nl for more information about the event.

One entire session will be dedicated to IB Objects. Another to Firebird in
general and another to converting file based systems to Firebird client/server
and multi-tier systems.

PS. You can also see a picture of me with a beard and mustache on their site
since they demanded a recent picture. I'm a mountain man now. <g>

Regards,
Jason Wharton

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

Click on Jason's Picture (without the beard) and down in the sessions, the
9:00-10:15 session click on Jason's name or on the double down arrow to open
up the Introduction to Interbase/Firebird SQL session description.



Jerry Sands





From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Roger Vellacott
Sent: Tuesday, November 24, 2009 5:20 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] SDN Conference presentations (December 14, 2009)





Jason,

The link should be http://www.sdn.nl

I can't see any pictures of you with a beard. I guess the organizers thought
it might frighten people.

Roger Vellacott
Passfield Data Systems Ltd
Tel +44 1404 514402
Mob +44 7831 156839

From: IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com>
[mailto:IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com> ] On
Behalf Of Jason Wharton
Sent: 24 November 2009 23:08
To: IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com>
Subject: [IBO] SDN Conference presentations (December 14, 2009)

I am presenting three sessions at the upcomming conference under the
direction of Bob Swart (a.k.a. Dr. Bob) at the Netherlands.

Please see http://www/sdn.nl for more information about the event.

One entire session will be dedicated to IB Objects. Another to Firebird in
general and another to converting file based systems to Firebird
client/server and multi-tier systems.

PS. You can also see a picture of me with a beard and mustache on their site
since they demanded a recent picture. I'm a mountain man now. <g>

Regards,
Jason Wharton

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

I don't think I'm that scary...

http://www.sdn.nl/SDN/SDNEvent/Sprekers/tabid/71/SpeakerId/75/Default.aspx

Anyone planning to attend, please let me know. I'd like to visit with you.

Cheers,
Jason

----- Original Message -----
From: "Roger Vellacott" <rvellacott@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, November 24, 2009 4:19 PM
Subject: RE: [IBO] SDN Conference presentations (December 14, 2009)


> Jason,
>
> The link should be http://www.sdn.nl
>
> I can't see any pictures of you with a beard.  I guess the organizers
> thought it might frighten people.
>
> Roger Vellacott
> Passfield Data Systems Ltd
> Tel +44 1404 514402
> Mob +44 7831 156839
>
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf Of Jason Wharton
> Sent: 24 November 2009 23:08
> To: IBObjects@yahoogroups.com
> Subject: [IBO] SDN Conference presentations (December 14, 2009)
>
>
>
> I am presenting three sessions at the upcomming conference under the
> direction of Bob Swart (a.k.a. Dr. Bob) at the Netherlands.
>
> Please see http://www/sdn.nl for more information about the event.
>
> One entire session will be dedicated to IB Objects. Another to Firebird in
> general and another to converting file based systems to Firebird
> client/server and multi-tier systems.
>
> PS. You can also see a picture of me with a beard and mustache on their
> site since they demanded a recent picture. I'm a mountain man now. <g>
>
> Regards,
> Jason Wharton

This should be simple... (FB 1.5 Dialect 3)

I am trying to add a master and detail record in the same transaction, but when
I insert the detail record, I get a FK exception indicating the detail ID is not
legal. But I should be able to do that, right?

The details are below, but what am I doing wrong?

Thank you,

Ed Dressel

The (not quite full) DLL for the tables and the monitor SQL is below:

******************************************
The master table is ClientInfo
******************************************
CREATE TABLE CLIENTINFO (
     CLIENT_ID         DM_KEY /* DM_KEY = INTEGER NOT NULL */,
     CREATED_DATETIME  DM_DATETIME /* DM_DATETIME = TIMESTAMP */,
     UPDATED_DATETIME  DM_DATETIME /* DM_DATETIME = TIMESTAMP */,
     EMAIL             DM_VARCHAR50 /* DM_VARCHAR50 = VARCHAR(50) */,
     EMAIL_UPPER       DM_VARCHAR50 /* DM_VARCHAR50 = VARCHAR(50)
);

ALTER TABLE CLIENTINFO ADD CONSTRAINT PK_CLIENTINFO PRIMARY KEY (CLIENT_ID);


******************************************
The detail table is ClientActionLog
******************************************

CREATE TABLE CLIENTACTIONLOG (
     CLIENTACTIONLOG_ID  DM_KEY /* DM_KEY = INTEGER NOT NULL */,
     EVENT_DATETIME      DM_DATETIME /* DM_DATETIME = TIMESTAMP */,
     CLIENT_ID           DM_KEY /* DM_KEY = INTEGER NOT NULL */,
     CLIENTACTION_ID     DM_KEY /* DM_KEY = INTEGER NOT NULL */,
     SUBACTION_ID        DM_INTEGER /* DM_INTEGER = INTEGER */,
     IP_ADDRESS          DM_VARCHAR20 /* DM_VARCHAR20 = VARCHAR(20) */,
     DETAILS             DM_MEMO /* DM_MEMO = BLOB SUB_TYPE 1 SEGMENT SIZE 80 */
);


ALTER TABLE CLIENTACTIONLOG ADD CONSTRAINT PK_CLIENTACTIONLOG PRIMARY KEY
(CLIENTACTIONLOG_ID);

ALTER TABLE CLIENTACTIONLOG ADD CONSTRAINT FK_CLIENTACTIONLOG_1 FOREIGN KEY
(CLIENT_ID) REFERENCES CLIENTINFO (CLIENT_ID) ON DELETE CASCADE;

ALTER TABLE CLIENTACTIONLOG ADD CONSTRAINT FK_CLIENTACTIONLOG_2 FOREIGN KEY
(CLIENTACTION_ID) REFERENCES CLIENTACTIONLIST (CLIENTACTION_ID) ON DELETE SET
NULL;


THe IB_Monitor results are below:

*************************
ClientInfo insert
*************************

/*---
PREPARE STATEMENT
TR_HANDLE = 3579008
STMT_HANDLE = 3579464
Insert into ClientInfo(Client_ID, Email, UserPassword, Admin_Rights)
values (? /* Client_ID */ , ? /* Email */ , ? /* UserPassword */ , 'F')
FIELDS = [  Version 1 SQLd 0 SQLn 30 ]
----*/

/*---
PREPARE STATEMENT
TR_HANDLE = 3579368
STMT_HANDLE = 3578792
SELECT GEN_ID ( GEN_CLIENT_ID, 1 )
FROM RDB$DATABASE
PLAN (RDB$DATABASE NATURAL)
FIELDS = [  Version 1 SQLd 1 SQLn 1
   GEN_ID = 4294967296 ]
----*/

/*---
EXECUTE2 DSQL
TR_HANDLE = 3579368
STMT_HANDLE = 3578792
PARAMS = [  ]
FIELDS = [  Version 1 SQLd 1 SQLn 1
   GEN_ID = 18 ]
SELECT COUNT: 1
----*/

/*---
EXECUTE STATEMENT
TR_HANDLE = 3579008
STMT_HANDLE = 3579464
PARAMS = [  Version 1 SQLd 3 SQLn 3
   [CLIENT_ID] = 18
   [EMAIL] = 'none@...'
   [USERPASSWORD] = 'test' ]
INSERT COUNT: 1
----*/

*************************
ClientActionLog insert
*************************

/*---
PREPARE STATEMENT
TR_HANDLE = 3579008
STMT_HANDLE = 3578792
Insert into ClientActionLog
(Client_ID, ClientAction_ID, SubAction_ID, IP_Address, Details)
values (? /* Client_ID */ , ? /* ClientActoin_ID */ , ? /* SubAction_ID */ , ?
/* IP_Address */ , ? /* Details */ )
FIELDS = [  Version 1 SQLd 0 SQLn 30 ]
----*/

/*---
EXECUTE STATEMENT
TR_HANDLE = 3579008
STMT_HANDLE = 3578792
PARAMS = [  Version 1 SQLd 5 SQLn 5
   [CLIENT_ID] = 18
   [CLIENTACTOIN_ID] = 5
   [SUBACTION_ID] = <NULL>
   [IP_ADDRESS] = ''
   [DETAILS] = BLOB ID ( 0, 1 ) ]
ERRCODE = 335544466
----*/

/*---
INTERPRET BUFFER =
ERRCODE = 85
----*/

/*---
INTERPRET BUFFER = violation of FOREIGN KEY constraint "FK_CLIENTACTIONLOG_1" on
table "CLIENTACTIONLOG"
ERRCODE = -1
----*/

At 12:19 PM 25/11/2009, you wrote:
>This should be simple... (FB 1.5 Dialect 3)
>
>I am trying to add a master and detail record in the same transaction, but when
I insert the detail record, I get a FK exception indicating the detail ID is not
legal. But I should be able to do that, right?
>
>The details are below, but what am I doing wrong?


One or more of:

1.  Missing or wrong MasterLinks
2.  Missing or wrong GeneratorLinks
3.  Before Insert triggers that don't take into account that
IBO fetches the new generated key value via GeneratorLinks.

Helen

Cool beard .. now you can get yourself a Farm here in Africa!

Adrian

   ----- Original Message -----
   From: Jason Wharton
   To: IBObjects@yahoogroups.com
   Sent: Wednesday, November 25, 2009 1:50 AM
   Subject: Re: [IBO] SDN Conference presentations (December 14, 2009)



   I don't think I'm that scary...

   http://www.sdn.nl/SDN/SDNEvent/Sprekers/tabid/71/SpeakerId/75/Default.aspx

   Anyone planning to attend, please let me know. I'd like to visit with you.

   Cheers,
   Jason

   ----- Original Message -----
   From: "Roger Vellacott" <rvellacott@...>
   To: <IBObjects@yahoogroups.com>
   Sent: Tuesday, November 24, 2009 4:19 PM
   Subject: RE: [IBO] SDN Conference presentations (December 14, 2009)

   > Jason,
   >
   > The link should be http://www.sdn.nl
   >
   > I can't see any pictures of you with a beard. I guess the organizers
   > thought it might frighten people.
   >
   > Roger Vellacott
   > Passfield Data Systems Ltd
   > Tel +44 1404 514402
   > Mob +44 7831 156839
   >
   > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
   > Behalf Of Jason Wharton
   > Sent: 24 November 2009 23:08
   > To: IBObjects@yahoogroups.com
   > Subject: [IBO] SDN Conference presentations (December 14, 2009)
   >
   >
   >
   > I am presenting three sessions at the upcomming conference under the
   > direction of Bob Swart (a.k.a. Dr. Bob) at the Netherlands.
   >
   > Please see http://www/sdn.nl for more information about the event.
   >
   > One entire session will be dedicated to IB Objects. Another to Firebird in
   > general and another to converting file based systems to Firebird
   > client/server and multi-tier systems.
   >
   > PS. You can also see a picture of me with a beard and mustache on their
   > site since they demanded a recent picture. I'm a mountain man now. <g>
   >
   > Regards,
   > Jason Wharton





[Non-text portions of this message have been removed]

> I am presenting three sessions at the upcomming conference under the direction
of Bob Swart (a.k.a. Dr. Bob) at the Netherlands.
>
> Please see http://www/sdn.nl for more information about the event.
>
> One entire session will be dedicated to IB Objects. Another to Firebird in
general and another to converting file based systems to Firebird client/server
and multi-tier systems.

Enjoy, have fun. Won't be there though. ;-)


> PS. You can also see a picture of me with a beard and mustache on their site
since they demanded a recent picture. I'm a mountain man now. <g>

Aha. Great new look. ;-)


Regards,
Thomas

Reminds me of that Insurance Cavemen advertising :)

----- Original Message -----
From: "Adrian Wreyford" <wreymed@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, November 24, 2009 10:02 PM
Subject: Re: [IBO] SDN Conference presentations (December 14, 2009)


> Cool beard .. now you can get yourself a Farm here in Africa!
>
> Adrian
>
>  ----- Original Message -----
>  From: Jason Wharton
>  To: IBObjects@yahoogroups.com
>  Sent: Wednesday, November 25, 2009 1:50 AM
>  Subject: Re: [IBO] SDN Conference presentations (December 14, 2009)
>
>
>
>  I don't think I'm that scary...
>
>
> http://www.sdn.nl/SDN/SDNEvent/Sprekers/tabid/71/SpeakerId/75/Default.aspx
>
>  Anyone planning to attend, please let me know. I'd like to visit with
> you.
>
>  Cheers,
>  Jason
>
>  ----- Original Message -----
>  From: "Roger Vellacott" <rvellacott@...>
>  To: <IBObjects@yahoogroups.com>
>  Sent: Tuesday, November 24, 2009 4:19 PM
>  Subject: RE: [IBO] SDN Conference presentations (December 14, 2009)
>
>  > Jason,
>  >
>  > The link should be http://www.sdn.nl
>  >
>  > I can't see any pictures of you with a beard. I guess the organizers
>  > thought it might frighten people.
>  >
>  > Roger Vellacott
>  > Passfield Data Systems Ltd
>  > Tel +44 1404 514402
>  > Mob +44 7831 156839
>  >
>  > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
>  > Behalf Of Jason Wharton
>  > Sent: 24 November 2009 23:08
>  > To: IBObjects@yahoogroups.com
>  > Subject: [IBO] SDN Conference presentations (December 14, 2009)
>  >
>  >
>  >
>  > I am presenting three sessions at the upcomming conference under the
>  > direction of Bob Swart (a.k.a. Dr. Bob) at the Netherlands.
>  >
>  > Please see http://www/sdn.nl for more information about the event.
>  >
>  > One entire session will be dedicated to IB Objects. Another to Firebird
> in
>  > general and another to converting file based systems to Firebird
>  > client/server and multi-tier systems.
>  >
>  > PS. You can also see a picture of me with a beard and mustache on their
>  > site since they demanded a recent picture. I'm a mountain man now. <g>
>  >
>  > Regards,
>  > Jason Wharton
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
>             without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>

Hello,

I've just upgraded to IBO 4.9.7 and moved a database from FB1.5.5 via
gbak and restore.

With FB1.5 and IBO4.7, when calling Locate, it worked without the rows
having been fetched, and we did not have AutoFetchAll turned on on the
TIB_Query.

With the new version, when calling Locate, if the rows haven't been
fetched, either by scrolling down the visible grid, or by setting
AutoFetchAll to True, then I get the following;

EIB_ISCError; ISC ERROR CODE 335544569
SQL error code = -206
Column unknown
COMPANY.COMPANY_NAME
unknown ISC error 336397208

Thanks,

Peter Lee

--
Peter Lee                                       ptle@...
-----------------------------------------------------------------------
Rising Software Australia Pty. Ltd.      http://www.risingsoftware.com/
Publishers of 'Auralia' - Ear Training and 'Musition' - Theory Training
Ph: +61 3 9481 3320  FAX: +61 3 9481 3380  USA Freecall: 1 888 667 7839

> One or more of:
>
> 1.  Missing or wrong MasterLinks
> 2.  Missing or wrong GeneratorLinks
> 3.  Before Insert triggers that don't take into account that
> IBO fetches the new generated key value via GeneratorLinks.


Maybe I am missing something? I (think) am managing my own generators. Below is
my slightly modified code--and even after a good night sleep, it seems that this
should work?

Ed Dressel


function TdmRetireCalcs.CreateTrans(const aReadOnly: Boolean):
   TIB_Transaction;
begin
   result := TIB_Transaction.CreateForSession(nil, iboSession);
   result.IB_Connection := ibConn;
   result.ReadOnly := aReadOnly;
end;

function TdmRetireCalcs.CreateDSQL(const aTx: TIB_Transaction; const aSQL:
String): TIB_DSQL;
begin
   result := TIB_DSQL.CreateForSession(nil, iboSession);
   result.IB_Connection := ibConn;
   result.IB_Transaction := aTx;
   result.SQL.Text := aSQL;
end;

procedure TdmRetireCalcs.AddClient(const aIPAddress, aEmail,
   aPassword: AnsiString; out aErrorMsg: AnsiString);
var
   lClientID: Integer;
   lTx: TIB_Transaction;
   ldsqlAdd: TIB_DSQL;
begin
   lTx := CreateTrans(false);
   ldsqlAdd := CreateDSQL(lTx, 'Insert into ClientInfo(Client_ID,  ' +
     Email, UserPassword, Admin_Rights) ' +
     values (:Client_ID, :Email, :UserPassword, ''F'')');
   try
     try
       ldsqlAdd.Prepare;
       lClientID := ibConn.Gen_ID(STR_GEN_CLIENT_ID, 1);
       ldsqlAdd.Params[0].AsInteger := lClientID;
       ldsqlAdd.Params[1].AsString := aEmail;
       ldsqlAdd.Params[2].AsString := aPassword;
       ldsqlAdd.ExecSQL;
       LogEvent(lTx, lClientID, ID_ADD_CLIENT, 0, aIPAddress, aEmail);
       lTx.Commit;
     except
       lTx.Rollback;
       raise;
     end;
   finally
     ldsqlAdd.Free;
     lTx.Free;
   end;
end;

procedure TdmRetireCalcs.LogEvent(const aTx: TIB_Transaction;
   const aClientID, aActionID, aSubActionID: Integer; const aIPAddress, aDetails:
string);
var
   ldsql: TIB_DSQL;
begin
   ldsql := CreateDSQL(aTx, 'Insert into ClientActionLog ' +
     '(Client_ID, ClientAction_ID, SubAction_ID, IP_Address, ' +
     'Details) values ' +
     '(:Client_ID, :ClientActoin_ID, :SubAction_ID, ' +
      ':IP_Address, :Details)');
   try
     ldsql.Prepare;
     if aClientID > 0 then
       ldsql.Params[0].AsInteger := aClientID;

     ldsql.Params[1].AsInteger := aActionID;

     if aSubActionID > 0 then
       ldsql.Params[2].AsInteger := aSubActionID;

     ldsql.Params[3].AsString := aIPAddress;

     if Length(aDetails) > 0 then
       ldsql.Params[4].AsString := aDetails;

     ldsql.ExecSQL;
   finally
     ldsql.Free;
   end;
end;

Okay, my bad. I found that in the ClientInfo BI trigger I was assigning a new
CLIENT_ID value from the generator, even if it was assigned. This caused the FK
problem.

Thanks for your time Helen.

Ed Dressel

Hi,
with IBO 4.2Hc the application work correctly. If i use IBO 4.9.7 the ID-Column
(column defined as domain DMID) not recieve the generator value, bud the default
value.

Settings:
ib_connection.fieldEntryTypes.FetDomainName=True
ib_connection.Defaultvalues (DMID=-1)

With IBO 4.2Hc the ID-Column are assigned with the generator value before the
default value. With IBO 4.9.7 the ID-Column are assigned with the default value
before the generator value.

Is this desired?

Thanks
Luis