Re: [firebird-support] Delphi XE2. Migrating from IBX components

2013-03-08 Thread Adrian Wreyford
Hello Sergio, You can also consider IBObjects from Jason Wharton. He has been around since the early 90’s, and I’ve been using his components since Delphi1, initially with Interbase. His components work well in DelphiXE, and recently upgraded to XE3 and work well there too. His support for Fireb

[firebird-support] Re: Delphi XE2. Migrating from IBX components

2013-03-08 Thread chris.waldmann
--- In firebird-support@yahoogroups.com, "Sergio" wrote: > > Hello I have all my apps in Delphi with the IBX components and ClientDataSets > to conect with a FB Database. Since long time ago IBX creator says it doesn't > support FB. So far I can work with very simple queries fine. But now I'd

[firebird-support] Re: Delphi XE2. Migrating from IBX components

2013-03-08 Thread chris.waldmann
--- In firebird-support@yahoogroups.com, "Sergio" wrote: > > Hello I have all my apps in Delphi with the IBX components and ClientDataSets > to conect with a FB Database. Since long time ago IBX creator says it doesn't > support FB. So far I can work with very simple queries fine. But now I'd

Re: [firebird-support] Delphi XE2. Migrating from IBX components

2013-03-08 Thread Jesus Garcia
> Hello I have all my apps in Delphi with the IBX components and ClientDataSets > to conect with a FB Database. Since long time ago IBX creator says it doesn't > support FB. So far I can work with very simple queries fine. But now I'd like > to use a component which supports FB. > > I'd like t

Re: [firebird-support] How can I check to see if a table is corrupted?

2013-03-08 Thread Thomas Steinmaurer
> I have a table that appears to be corrupted because any SQL I run against it > just runs. The table has a little over 976,000 rows. I can't drop or delete > from the table. Is there a way I can either force drop the table or repair > it? You can't drop a table when it's being in use by con

[firebird-support] How can I check to see if a table is corrupted?

2013-03-08 Thread jim.rhema316
I have a table that appears to be corrupted because any SQL I run against it just runs. The table has a little over 976,000 rows. I can't drop or delete from the table. Is there a way I can either force drop the table or repair it? I do have the data to rebuild the table. Thank you very muc

Re: [firebird-support] Catching exception fails under isql

2013-03-08 Thread Thomas Steinmaurer
> Does anyone have any insight in to this? > > Running this statement in isql: > >EXECUTE PROCEDURE P_IMPORT; > > Yields this error: > >Statement failed, SQLCODE = -508 >no current record for fetch operation >-violation of PRIMARY or UNIQUE KEY constraint > > Yet running the same st

[firebird-support] Delphi XE2. Migrating from IBX components

2013-03-08 Thread Sergio
Hello I have all my apps in Delphi with the IBX components and ClientDataSets to conect with a FB Database. Since long time ago IBX creator says it doesn't support FB. So far I can work with very simple queries fine. But now I'd like to use a component which supports FB. I'd like to hear some o

[firebird-support] Catching exception fails under isql

2013-03-08 Thread Rick Debay
Does anyone have any insight in to this? Running this statement in isql: EXECUTE PROCEDURE P_IMPORT; Yields this error: Statement failed, SQLCODE = -508 no current record for fetch operation -violation of PRIMARY or UNIQUE KEY constraint Yet running the same statement in Database Workb