Search the web
Sign In
New User? Sign Up
IBObjects · IB Objects support list
  • Members Only
  • Post
  • Files
  • Photos
  • Links
  • Members
  • Groups Labs (Beta)
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

   Messages Help
Message #
Search:
Advanced
Messages 44315 - 44344 of 44358   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#44344 From: "Ed Dressel" <eddressel@...>
Date: Wed Nov 25, 2009 4:11 pm
Subject: Re: Inserting to a detail record 		eddressel
Offline Offline
Send Email Send Email
  
> 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;

Reply | Forward | Messages in this Topic (4)
#44343 From: Peter Lee <ptle@...>
Date: Wed Nov 25, 2009 6:53 am
Subject: TIB_Query.locate issue - ibo 4.9.7 / fb 2.1.3 		ptle1975
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (1)
#44342 From: "Hans" <hhoogstraat@...>
Date: Wed Nov 25, 2009 6:48 am
Subject: Re: [IBO] SDN Conference presentations (December 14, 2009) 		ittybittypro...
Offline Offline
Send Email Send Email
  
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
>
>
>

Reply | Forward | Messages in this Topic (7)
#44341 From: Thomas Steinmaurer <ts@...>
Date: Wed Nov 25, 2009 6:26 am
Subject: Re: [IBO] SDN Conference presentations (December 14, 2009) 		iblogmanager
Offline Offline
Send Email Send Email
  
> 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

Reply | Forward | Messages in this Topic (7)
#44340 From: "Adrian Wreyford" <wreymed@...>
Date: Wed Nov 25, 2009 5:02 am
Subject: Re: [IBO] SDN Conference presentations (December 14, 2009) 		ajwreyford
Offline Offline
Send Email Send Email
  
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]

Reply | Forward | Messages in this Topic (7)
#44339 From: Helen Borrie <helebor@...>
Date: Wed Nov 25, 2009 3:11 am
Subject: Re: [IBO] Inserting to a detail record 		helebor
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (4)
#44338 From: "Ed Dressel" <eddressel@...>
Date: Wed Nov 25, 2009 1:19 am
Subject: Inserting to a detail record 		eddressel
Offline Offline
Send Email Send Email
  
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
----*/

Reply | Forward | Messages in this Topic (4)
#44337 From: "Jason Wharton" <supportlist@...>
Date: Tue Nov 24, 2009 11:50 pm
Subject: Re: [IBO] SDN Conference presentations (December 14, 2009) 		ibobjects
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (7)
#44336 From: "Jerry Sands" <jsands@...>
Date: Tue Nov 24, 2009 11:45 pm
Subject: RE: [IBO] SDN Conference presentations (December 14, 2009) 		jerry_a_sands
Offline Offline
Send Email Send Email
  
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]

Reply | Forward | Messages in this Topic (7)
#44335 From: Roger Vellacott <rvellacott@...>
Date: Tue Nov 24, 2009 11:19 pm
Subject: RE: [IBO] SDN Conference presentations (December 14, 2009) 		rogervellacott
Offline Offline
Send Email Send Email
  
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]

Reply | Forward | Messages in this Topic (7)
#44334 From: "Jason Wharton" <supportlist@...>
Date: Tue Nov 24, 2009 11:08 pm
Subject: SDN Conference presentations (December 14, 2009) 		ibobjects
Offline Offline
Send Email Send Email
  
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]

Reply | Forward | Messages in this Topic (7)
#44333 From: "luis.kerschbaumer" <luis.kerschbaumer@...>
Date: Sat Nov 21, 2009 12:35 pm
Subject: Re: [IBO] IBOQuery and boolean fields make access violation 		luis.kerschb...
Offline Offline
Send Email Send Email
  
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
> >
>

Reply | Forward | Messages in this Topic (4)
#44332 From: "luis.kerschbaumer" <luis.kerschbaumer@...>
Date: Sat Nov 21, 2009 12:23 pm
Subject: Re: [IBO] IBOQuery and boolean fields make access violation 		luis.kerschb...
Offline Offline
Send Email Send Email
  
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
>

Reply | Forward | Messages in this Topic (4)
#44331 From: "Jason Wharton" <supportlist@...>
Date: Fri Nov 20, 2009 4:31 pm
Subject: Re: [IBO] IBOQuery and boolean fields make access violation 		ibobjects
Offline Offline
Send Email Send Email
  
> 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

Reply | Forward | Messages in this Topic (4)
#44330 From: "Jason Wharton" <supportlist@...>
Date: Fri Nov 20, 2009 4:29 pm
Subject: Re: [IBO] upgrading 		ibobjects
Offline Offline
Send Email Send Email
  
> 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

Reply | Forward | Messages in this Topic (2)
#44329 From: "luis.kerschbaumer" <luis.kerschbaumer@...>
Date: Fri Nov 20, 2009 8:18 am
Subject: IBOQuery and boolean fields make access violation 		luis.kerschb...
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (4)
#44328 From: "mivi71dk" <Michael.Vilhelmsen@...>
Date: Fri Nov 20, 2009 8:19 am
Subject: upgrading 		mivi71dk
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (2)
#44327 From: "hiram90808" <hiram@...>
Date: Tue Nov 17, 2009 6:35 pm
Subject: Can't Download - Account Expired 		hiram90808
Offline Offline
Send Email Send Email
  
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.

Reply | Forward | Messages in this Topic (1)
#44326 From: "carlosdaniel_am" <carlosdaniel_am@...>
Date: Tue Nov 17, 2009 7:05 pm
Subject: How can i change the bitmap of indicate row that is present in IB_GRID 		carlosdaniel_am
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (1)
#44325 From: "Jason Wharton" <supportlist@...>
Date: Mon Nov 16, 2009 8:11 pm
Subject: Re: [IBO] Any idea when IBO 4.9.7 will be available? 		ibobjects
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (2)
#44324 From: "Steve" <stevefields24@...>
Date: Mon Nov 16, 2009 4:35 pm
Subject: Any idea when IBO 4.9.7 will be available? 		stevefields24
Offline Offline
Send Email Send Email
  
My account still shows expired.

Is Jason still having problems with his server?

Thanks
Steve Fields

Reply | Forward | Messages in this Topic (2)
#44323 From: Aage Johansen <aagjohan@...>
Date: Sat Nov 14, 2009 10:33 pm
Subject: IBO site 		aafj1945
Offline Offline
Send Email Send Email
  
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.

Reply | Forward | Messages in this Topic (1)
#44322 From: "Jason Wharton" <supportlist@...>
Date: Thu Nov 12, 2009 11:26 pm
Subject: Re: [IBO] Can't install IBO4.9 in D2010 Trial 		ibobjects
Offline Offline
Send Email Send Email
  
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
>
>

Reply | Forward | Messages in this Topic (2)
#44321 From: "bausufm" <bausufm@...>
Date: Thu Nov 12, 2009 9:18 am
Subject: Can't install IBO4.9 in D2010 Trial 		bausufm
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (2)
#44320 From: "jackmason7" <jackmason@...>
Date: Wed Nov 11, 2009 8:23 pm
Subject: Got new copy of IB04.7, Installed to RadStudio2010 		jackmason7
Offline Offline
Send Email Send Email
  
Installer indicated it was installing to D2010, but after it finished, there
were no palette entries.

This is on 64 bit Windows 7 Professional

Reply | Forward | Messages in this Topic (1)
#44319 From: "Jason Wharton" <supportlist@...>
Date: Tue Nov 10, 2009 8:58 pm
Subject: Re: [IBO] Background for a TIB_Grid 		ibobjects
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (2)
#44318 From: "mmusetti70" <mmusetti70@...>
Date: Tue Nov 10, 2009 4:11 pm
Subject: Background for a TIB_Grid 		mmusetti70
Offline Offline
Send Email Send Email
  
Is it possible to have a image .BMP as a background for a TIB_Grid control ?

Thanks,

Marcos

Reply | Forward | Messages in this Topic (2)
#44317 From: Andreas Hesse <ah@...>
Date: Tue Nov 10, 2009 8:36 am
Subject: Re: [IBO] IBOAdmin 		fisch50de
Offline Offline
Send Email Send Email
  
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

Reply | Forward | Messages in this Topic (30)
#44316 From: "Jerry Sands" <jsands@...>
Date: Tue Nov 10, 2009 2:18 am
Subject: IBOAdmin 		jerry_a_sands
Offline Offline
Send Email Send Email
  
Where can I get a copy of the latest IBOAdmin for Delphi 2009 / Delphi 2010
in a single ZIP file?



Thanks



Jerry Sands





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

Reply | Forward | Messages in this Topic (30)
#44315 From: Karl <mail-from-ibobjects@...>
Date: Sat Nov 7, 2009 12:29 am
Subject: Re: [IBO] Problem with CreateDatabase 		kpentzlin
Offline Offline
Send Email Send Email
  
Friday, November 6, 2009, 12:07:39 AM, Helen Borrie wrote:

>> ...
>>[5888] ISC ERROR CODE:335544375
>>[5888] ISC ERROR MESSAGE:
>>[5888] unavailable database

> It looks as though you are running Classic. You can check that by
> inspecting the properties of the service to find out the executable
> name. "fbserver.exe" is Superserver, "fb_inet_server.exe" is Classic.

> If it is Classic, then your problem is that you can't use cpLocal
> protocol. Use cpTcpip and make it:
> #define DATABASEDIR "localhost:C:\\_E\\AADBTest\\DatabaseDir"

Thank you.
In fact, changing to cpTCP_IP worked, even without prefixing the
DATABASEDIR with "localhost:".
However, fbserver.exe was running, not fb_inet_server.exe .

Best wishes
Karl

Reply | Forward | Messages in this Topic (3)
Messages 44315 - 44344 of 44358   Newest  |  < Newer  |  Older >  |  Oldest
Message #
Search:
Advanced
Add to My Yahoo!      XML What's This?
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help