Recent

Author Topic: I installed IBX now I have "orphaned" files. What do I need to do?  (Read 4375 times)

RedOctober

  • Sr. Member
  • ****
  • Posts: 452
Here is a list of orphaned and duplicate files from the Lazaraus 1.8, Fpc 3.0.4 error message window.
What do I need to do to clean this up properly?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Messages, Warnings: 2, Hints: 40
Note: Duplicate unit "ibxscript" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu"
Note: Duplicate unit "ibxscript" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu", source="C:\ProgramFilesCP\ibx201\runtime\ibxscript.pas"
Note: Duplicate unit "IBVersion" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu"
Note: Duplicate unit "IBVersion" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBVersion.pas"
Note: Duplicate unit "IBUpdateSQL" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu"
Note: Duplicate unit "IBUpdateSQL" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBUpdateSQL.pas"
Note: Duplicate unit "IBTypes" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu"
Note: Duplicate unit "IBTypes" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBTypes.pas"
Note: Duplicate unit "IBTable" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTable.ppu"
Note: Duplicate unit "IBTable" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTable.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBTable.pas"
Note: Duplicate unit "IBStoredProc" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBStoredProc.ppu"
Note: Duplicate unit "IBStoredProc" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBStoredProc.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBStoredProc.pas"
Note: Duplicate unit "IBSQLParser" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLParser.ppu"
Note: Duplicate unit "IBSQLParser" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLParser.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQLParser.pas"
Note: Duplicate unit "IBSQLMonitor" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLMonitor.ppu"
Note: Duplicate unit "IBSQLMonitor" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLMonitor.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQLMonitor.pas"
Note: Duplicate unit "IBSQL" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQL.ppu"
Note: Duplicate unit "IBSQL" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQL.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQL.pas"
Note: Duplicate unit "IBServices" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBServices.ppu"
Note: Duplicate unit "IBServices" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBServices.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBServices.pas"
Note: Duplicate unit "IBQuery" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBQuery.ppu"
Note: Duplicate unit "IBQuery" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBQuery.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBQuery.pas"
Note: Duplicate unit "IBExtract" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBExtract.ppu"
Note: Duplicate unit "IBExtract" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBExtract.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBExtract.pas"
Note: Duplicate unit "IBEvents" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBEvents.ppu"
Note: Duplicate unit "IBEvents" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBEvents.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBEvents.pas"
Note: Duplicate unit "" in "fbintf 1.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.ppu", source="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.lfm"
Note: Duplicate unit "IBDialogs" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDialogs.pas"
Note: Duplicate unit "IBDataOutput" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDataOutput.ppu"
Note: Duplicate unit "IBDataOutput" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDataOutput.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDataOutput.pas"
Note: Duplicate unit "IBDatabaseInfo" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabaseInfo.ppu"
Note: Duplicate unit "IBDatabaseInfo" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabaseInfo.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDatabaseInfo.pas"
Note: Duplicate unit "IBDatabase" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabase.ppu"
Note: Duplicate unit "IBDatabase" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabase.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDatabase.pas"
Note: Duplicate unit "IBCustomDataSet" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBCustomDataSet.ppu"
Note: Duplicate unit "IBCustomDataSet" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBCustomDataSet.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBCustomDataSet.pas"
Note: Duplicate unit "IBBlob" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBlob.ppu"
Note: Duplicate unit "IBBlob" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBlob.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBBlob.pas"
Note: Duplicate unit "IBBatchMove" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBatchMove.ppu"
Note: Duplicate unit "IBBatchMove" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBatchMove.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBBatchMove.pas"
Warning: Duplicate file "IBDialogs.lfm" in "fbintf 1.0.1", path="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.lfm"
Warning: Duplicate file "IBDialogs.lfm" in "ibexpress 2.0.1", path="C:\ProgramFilesCP\ibx201\runtime\IBDialogs.lfm"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

RedOctober

  • Sr. Member
  • ****
  • Posts: 452
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #1 on: January 23, 2018, 06:00:17 pm »
Upon compile,  I now get this error message:

[Debugger Exception Notification]

Project MyProject raised exception class 'EIBClientError' with message:
DPB Constant (isc_dpb_page_size) is unsupported

 In file 'fbintf\IB.pas' at line 1149:
raise EIBClientError.Create(Ord(ErrMess),


[Ignore this exception type]

[Break] [Continue]

How do I fix this?  I need PageSize

dsiders

  • Hero Member
  • *****
  • Posts: 1084
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #2 on: January 23, 2018, 07:22:39 pm »
Here is a list of orphaned and duplicate files from the Lazaraus 1.8, Fpc 3.0.4 error message window.
What do I need to do to clean this up properly?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Messages, Warnings: 2, Hints: 40
Note: Duplicate unit "ibxscript" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu"
Note: Duplicate unit "ibxscript" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu", source="C:\ProgramFilesCP\ibx201\runtime\ibxscript.pas"
Note: Duplicate unit "IBVersion" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu"
Note: Duplicate unit "IBVersion" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBVersion.pas"
Note: Duplicate unit "IBUpdateSQL" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu"
Note: Duplicate unit "IBUpdateSQL" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBUpdateSQL.pas"
Note: Duplicate unit "IBTypes" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu"
Note: Duplicate unit "IBTypes" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBTypes.pas"
Note: Duplicate unit "IBTable" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTable.ppu"
Note: Duplicate unit "IBTable" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTable.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBTable.pas"
Note: Duplicate unit "IBStoredProc" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBStoredProc.ppu"
Note: Duplicate unit "IBStoredProc" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBStoredProc.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBStoredProc.pas"
Note: Duplicate unit "IBSQLParser" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLParser.ppu"
Note: Duplicate unit "IBSQLParser" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLParser.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQLParser.pas"
Note: Duplicate unit "IBSQLMonitor" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLMonitor.ppu"
Note: Duplicate unit "IBSQLMonitor" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLMonitor.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQLMonitor.pas"
Note: Duplicate unit "IBSQL" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQL.ppu"
Note: Duplicate unit "IBSQL" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQL.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQL.pas"
Note: Duplicate unit "IBServices" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBServices.ppu"
Note: Duplicate unit "IBServices" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBServices.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBServices.pas"
Note: Duplicate unit "IBQuery" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBQuery.ppu"
Note: Duplicate unit "IBQuery" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBQuery.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBQuery.pas"
Note: Duplicate unit "IBExtract" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBExtract.ppu"
Note: Duplicate unit "IBExtract" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBExtract.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBExtract.pas"
Note: Duplicate unit "IBEvents" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBEvents.ppu"
Note: Duplicate unit "IBEvents" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBEvents.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBEvents.pas"
Note: Duplicate unit "" in "fbintf 1.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.ppu", source="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.lfm"
Note: Duplicate unit "IBDialogs" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDialogs.pas"
Note: Duplicate unit "IBDataOutput" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDataOutput.ppu"
Note: Duplicate unit "IBDataOutput" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDataOutput.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDataOutput.pas"
Note: Duplicate unit "IBDatabaseInfo" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabaseInfo.ppu"
Note: Duplicate unit "IBDatabaseInfo" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabaseInfo.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDatabaseInfo.pas"
Note: Duplicate unit "IBDatabase" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabase.ppu"
Note: Duplicate unit "IBDatabase" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabase.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDatabase.pas"
Note: Duplicate unit "IBCustomDataSet" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBCustomDataSet.ppu"
Note: Duplicate unit "IBCustomDataSet" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBCustomDataSet.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBCustomDataSet.pas"
Note: Duplicate unit "IBBlob" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBlob.ppu"
Note: Duplicate unit "IBBlob" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBlob.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBBlob.pas"
Note: Duplicate unit "IBBatchMove" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBatchMove.ppu"
Note: Duplicate unit "IBBatchMove" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBatchMove.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBBatchMove.pas"
Warning: Duplicate file "IBDialogs.lfm" in "fbintf 1.0.1", path="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.lfm"
Warning: Duplicate file "IBDialogs.lfm" in "ibexpress 2.0.1", path="C:\ProgramFilesCP\ibx201\runtime\IBDialogs.lfm"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Those are caused my the path specified in the package files. I believe this post will offer a little more insight.
http://forum.lazarus.freepascal.org/index.php/topic,34542.msg226618.html#msg226618

Notes and Hints are not a show stopper... but they need to be fixed.
Preview Lazarus 3.99 documentation at: https://dsiders.gitlab.io/lazdocsnext

dsiders

  • Hero Member
  • *****
  • Posts: 1084
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #3 on: January 23, 2018, 07:24:10 pm »
Upon compile,  I now get this error message:

[Debugger Exception Notification]

Project MyProject raised exception class 'EIBClientError' with message:
DPB Constant (isc_dpb_page_size) is unsupported

 In file 'fbintf\IB.pas' at line 1149:
raise EIBClientError.Create(Ord(ErrMess),


[Ignore this exception type]

[Break] [Continue]

How do I fix this?  I need PageSize

Do you have a snippet of code that generated this exception. I don't see this, but a code example would help narrow it down.
Preview Lazarus 3.99 documentation at: https://dsiders.gitlab.io/lazdocsnext

RedOctober

  • Sr. Member
  • ****
  • Posts: 452
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #4 on: January 23, 2018, 07:44:34 pm »
This will create the "duplicate file" error messages:
(Ensure you have the latest IBX components installed in your Lazarus IDE (v2.0.1)
1) Start a new Lazarus project
2) On the main form place one of each IBX object from both the Firebird tab and Firebird Admin tab
3) Compile

Warning messages:

Messages, Warnings: 10, Hints: 54
Note: Duplicate unit "" in "fbintf 1.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXViewLogDig.ppu", source="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXViewLogDig.lfm"
Note: Duplicate unit "IBXViewLogDig" in "iblocaldb 1.0", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXViewLogDig.ppu", source="C:\ProgramFilesCP\ibx201\iblocaldb\IBXViewLogDig.pas"
Note: Duplicate unit "" in "fbintf 1.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXUpgradeDatabaseDlg.ppu", source="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXUpgradeDatabaseDlg.lfm"
Note: Duplicate unit "IBXUpgradeDatabaseDlg" in "iblocaldb 1.0", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXUpgradeDatabaseDlg.ppu", source="C:\ProgramFilesCP\ibx201\iblocaldb\IBXUpgradeDatabaseDlg.pas"
Note: Duplicate unit "IBXUpgradeConfFile" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXUpgradeConfFile.ppu"
Note: Duplicate unit "IBXUpgradeConfFile" in "iblocaldb 1.0", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXUpgradeConfFile.ppu", source="C:\ProgramFilesCP\ibx201\iblocaldb\IBXUpgradeConfFile.pas"
Note: Duplicate unit "ibxscript" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu"
Note: Duplicate unit "ibxscript" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu", source="C:\ProgramFilesCP\ibx201\runtime\ibxscript.pas"
Note: Duplicate unit "" in "fbintf 1.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXSaveDatabaseDlg.ppu", source="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXSaveDatabaseDlg.lfm"
Note: Duplicate unit "IBXSaveDatabaseDlg" in "iblocaldb 1.0", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXSaveDatabaseDlg.ppu", source="C:\ProgramFilesCP\ibx201\iblocaldb\IBXSaveDatabaseDlg.pas"
Note: Duplicate unit "IBXCustomIBLocalDBSupport" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXCustomIBLocalDBSupport.ppu"
Note: Duplicate unit "IBXCustomIBLocalDBSupport" in "iblocaldb 1.0", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXCustomIBLocalDBSupport.ppu", source="C:\ProgramFilesCP\ibx201\iblocaldb\IBXCustomIBLocalDBSupport.pas"
Note: Duplicate unit "" in "fbintf 1.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXCreateDatabaseDlg.ppu", source="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXCreateDatabaseDlg.lfm"
Note: Duplicate unit "IBXCreateDatabaseDlg" in "iblocaldb 1.0", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXCreateDatabaseDlg.ppu", source="C:\ProgramFilesCP\ibx201\iblocaldb\IBXCreateDatabaseDlg.pas"
Note: Duplicate unit "IBVersion" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu"
Note: Duplicate unit "IBVersion" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBVersion.pas"
Note: Duplicate unit "IBUpdateSQL" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu"
Note: Duplicate unit "IBUpdateSQL" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBUpdateSQL.pas"
Note: Duplicate unit "IBTypes" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu"
Note: Duplicate unit "IBTypes" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBTypes.pas"
Note: Duplicate unit "IBTable" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTable.ppu"
Note: Duplicate unit "IBTable" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTable.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBTable.pas"
Note: Duplicate unit "IBStoredProc" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBStoredProc.ppu"
Note: Duplicate unit "IBStoredProc" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBStoredProc.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBStoredProc.pas"
Note: Duplicate unit "IBSQLParser" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLParser.ppu"
Note: Duplicate unit "IBSQLParser" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLParser.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQLParser.pas"
Note: Duplicate unit "IBSQLMonitor" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLMonitor.ppu"
Note: Duplicate unit "IBSQLMonitor" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQLMonitor.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQLMonitor.pas"
Note: Duplicate unit "IBSQL" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQL.ppu"
Note: Duplicate unit "IBSQL" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBSQL.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBSQL.pas"
Note: Duplicate unit "IBServices" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBServices.ppu"
Note: Duplicate unit "IBServices" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBServices.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBServices.pas"
Note: Duplicate unit "IBQuery" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBQuery.ppu"
Note: Duplicate unit "IBQuery" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBQuery.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBQuery.pas"
Note: Duplicate unit "IBLocalDBSupport" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBLocalDBSupport.ppu"
Note: Duplicate unit "IBLocalDBSupport" in "iblocaldb 1.0", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBLocalDBSupport.ppu", source="C:\ProgramFilesCP\ibx201\iblocaldb\IBLocalDBSupport.pas"
Note: Duplicate unit "IBExtract" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBExtract.ppu"
Note: Duplicate unit "IBExtract" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBExtract.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBExtract.pas"
Note: Duplicate unit "IBEvents" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBEvents.ppu"
Note: Duplicate unit "IBEvents" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBEvents.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBEvents.pas"
Note: Duplicate unit "" in "fbintf 1.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.ppu", source="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.lfm"
Note: Duplicate unit "IBDialogs" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDialogs.pas"
Note: Duplicate unit "IBDataOutput" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDataOutput.ppu"
Note: Duplicate unit "IBDataOutput" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDataOutput.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDataOutput.pas"
Note: Duplicate unit "IBDatabaseInfo" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabaseInfo.ppu"
Note: Duplicate unit "IBDatabaseInfo" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabaseInfo.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDatabaseInfo.pas"
Note: Duplicate unit "IBDatabase" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabase.ppu"
Note: Duplicate unit "IBDatabase" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDatabase.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBDatabase.pas"
Note: Duplicate unit "IBCustomDataSet" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBCustomDataSet.ppu"
Note: Duplicate unit "IBCustomDataSet" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBCustomDataSet.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBCustomDataSet.pas"
Note: Duplicate unit "IBBlob" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBlob.ppu"
Note: Duplicate unit "IBBlob" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBlob.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBBlob.pas"
Note: Duplicate unit "IBBatchMove" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBatchMove.ppu"
Note: Duplicate unit "IBBatchMove" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBBatchMove.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBBatchMove.pas"
Warning: Duplicate file "IBDialogs.lfm" in "fbintf 1.0.1", path="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBDialogs.lfm"
Warning: Duplicate file "IBDialogs.lfm" in "ibexpress 2.0.1", path="C:\ProgramFilesCP\ibx201\runtime\IBDialogs.lfm"
Warning: Duplicate file "IBXCreateDatabaseDlg.lfm" in "fbintf 1.0.1", path="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXCreateDatabaseDlg.lfm"
Warning: Duplicate file "IBXCreateDatabaseDlg.lfm" in "iblocaldb 1.0", path="C:\ProgramFilesCP\ibx201\iblocaldb\IBXCreateDatabaseDlg.lfm"
Warning: Duplicate file "IBXSaveDatabaseDlg.lfm" in "fbintf 1.0.1", path="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXSaveDatabaseDlg.lfm"
Warning: Duplicate file "IBXSaveDatabaseDlg.lfm" in "iblocaldb 1.0", path="C:\ProgramFilesCP\ibx201\iblocaldb\IBXSaveDatabaseDlg.lfm"
Warning: Duplicate file "IBXUpgradeDatabaseDlg.lfm" in "fbintf 1.0.1", path="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXUpgradeDatabaseDlg.lfm"
Warning: Duplicate file "IBXUpgradeDatabaseDlg.lfm" in "iblocaldb 1.0", path="C:\ProgramFilesCP\ibx201\iblocaldb\IBXUpgradeDatabaseDlg.lfm"
Warning: Duplicate file "IBXViewLogDig.lfm" in "fbintf 1.0.1", path="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBXViewLogDig.lfm"
Warning: Duplicate file "IBXViewLogDig.lfm" in "iblocaldb 1.0", path="C:\ProgramFilesCP\ibx201\iblocaldb\IBXViewLogDig.lfm"
Compile Project, Target: project1.exe: Success

Solving these messages may help solve the "orphaned" errors in my original post.
Thanks in advance for any help you can provide.



dsiders

  • Hero Member
  • *****
  • Posts: 1084
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #5 on: January 23, 2018, 08:15:21 pm »
This will create the "duplicate file" error messages:
(Ensure you have the latest IBX components installed in your Lazarus IDE (v2.0.1)
1) Start a new Lazarus project
2) On the main form place one of each IBX object from both the Firebird tab and Firebird Admin tab
3) Compile

Compiles and produces an executable for me.

Warning messages:
...

These are just a distraction at this point. Yes, they need to be corrected... but note and hint message are not causing the  exception you mentioned. And I'm not seeing the exception.
Preview Lazarus 3.99 documentation at: https://dsiders.gitlab.io/lazdocsnext

dsiders

  • Hero Member
  • *****
  • Posts: 1084
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #6 on: January 23, 2018, 10:39:16 pm »
Upon compile,  I now get this error message:

[Debugger Exception Notification]

Project MyProject raised exception class 'EIBClientError' with message:
DPB Constant (isc_dpb_page_size) is unsupported

 In file 'fbintf\IB.pas' at line 1149:
raise EIBClientError.Create(Ord(ErrMess),


[Ignore this exception type]

[Break] [Continue]

How do I fix this?  I need PageSize

I just ran the demo in example/services and it functions as expected. TIBStaticalService is the one that'll return the existing page size for a specific database.
Preview Lazarus 3.99 documentation at: https://dsiders.gitlab.io/lazdocsnext

RedOctober

  • Sr. Member
  • ****
  • Posts: 452
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #7 on: January 24, 2018, 05:27:23 pm »
Hi dsiders.  Here is the difference..

The example project is merely listing the page size as a statistic of a database. 

 with IBValidationService1 do
    begin
      Active := true;
      ServiceStart;
      while not Eof do
      begin
        Memo1.Lines.Add(GetNextLine);
        Application.ProcessMessages;
      end;                               


However, I need to create a database with a specific page size.  The way I was trying to do this was like this:

      with fb_db do
        begin

          if Connected then
            Connected := False;

          CreateIfNotExists := True;
          DatabaseName := DatabaseNm;
          LoginPrompt := False;
          SQLDialect := sql_dia;

          Params.Clear;

          Params.Add('user_name=' + UserNm);
          Params.Add('password=' + Pwd);

          Params.Add('page_size=' + IntToStr(pg_sz));
          Params.Add('lc_ctype=' + char_set);
          Params.Add('sql_role_name=' + RoleNm);

          CreateDatabase;
          Connected := True;

        end;

The CreateDatabase is what throws the error message. 

[Debugger Exception Notification]

Project MyProject raised exception class 'EIBClientError' with message:
DPB Constant (isc_dpb_page_size) is unsupported

 In file 'fbintf\IB.pas' at line 1149:
raise EIBClientError.Create(Ord(ErrMess),


[Ignore this exception type]

[Break] [Continue]


What is the proper way to specify a page size when creating a database using IBX?
I am using Lazarus 1.8, Fpc 2.0.4, and Firebird 3x.


dsiders

  • Hero Member
  • *****
  • Posts: 1084
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #8 on: January 24, 2018, 06:12:51 pm »
Hi dsiders.  Here is the difference..

The example project is merely listing the page size as a statistic of a database.
 

Yep. That's what the services actually do.

However, I need to create a database with a specific page size.  The way I was trying to do this was like this:

...

What is the proper way to specify a page size when creating a database using IBX?

As I mentioned before, the only way I've found is using the CREATE DATABASE statement (or restoring from a backup file).

There is an overloaded CreateDatabase procedure in TIBDatabase that accepts a SQL statement:

Code: [Select]
  IBDatabase1.CreateDatabase(AStatement: string);

That should work using the standard CREATE DATABASE SQL statement you would use in a script. You just have to format and quote the arguments you want to pass.

Don
Preview Lazarus 3.99 documentation at: https://dsiders.gitlab.io/lazdocsnext

tonyw

  • Sr. Member
  • ****
  • Posts: 321
    • MWA Software
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #9 on: January 31, 2018, 12:30:53 am »
Here is a list of orphaned and duplicate files from the Lazaraus 1.8, Fpc 3.0.4 error message window.
What do I need to do to clean this up properly?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Messages, Warnings: 2, Hints: 40
Note: Duplicate unit "ibxscript" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu"
Note: Duplicate unit "ibxscript" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\ibxscript.ppu", source="C:\ProgramFilesCP\ibx201\runtime\ibxscript.pas"
Note: Duplicate unit "IBVersion" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu"
Note: Duplicate unit "IBVersion" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBVersion.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBVersion.pas"
Note: Duplicate unit "IBUpdateSQL" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu"
Note: Duplicate unit "IBUpdateSQL" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBUpdateSQL.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBUpdateSQL.pas"
Note: Duplicate unit "IBTypes" in "fbintf 1.0.1", orphaned ppu "C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu"
Note: Duplicate unit "IBTypes" in "ibexpress 2.0.1", ppu="C:\ProgramFilesCP\ibx201\lib\x86_64-win64\IBTypes.ppu", source="C:\ProgramFilesCP\ibx201\runtime\IBTypes.pas"
<snip>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

This is an irritation rather than a problem in that it does not seem to cause a problem - but it is annoying to see those messages. I have tried different strategies for getting rid of it over several versions of IBX, but it still seems to come back. A solution would be much appreciated.

tonyw

  • Sr. Member
  • ****
  • Posts: 321
    • MWA Software
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #10 on: January 31, 2018, 12:41:14 am »
Upon compile,  I now get this error message:

[Debugger Exception Notification]

Project MyProject raised exception class 'EIBClientError' with message:
DPB Constant (isc_dpb_page_size) is unsupported

 In file 'fbintf\IB.pas' at line 1149:
raise EIBClientError.Create(Ord(ErrMess),


[Ignore this exception type]

[Break] [Continue]

How do I fix this?  I need PageSize

As it says, IBX does not currently support the Page Size DPB parameter - which is perhaps an oversight as it is supported by the underlying Firebird Pascal API. Nevertheless. It is anyway used only for create database statements and is not used when connecting to a database.

You can specify the PAGE SIZE as part of a CreateDatabase SQL statement and then pass this to TIBDatabase.CreateDatabase. This is the way I would recommend that you use IBX to create a database. If you call TIBDatabase.CreateDatabase without providing an SQL statement, all IBX will do is to create one for you based on the DPB parameters.

You cannot change the page size when you connect to a database. If you want to change the database page size then use the Firebird gfix utility or - to change it from a program - use the Services API. See the TIBConfigService component.

tonyw

  • Sr. Member
  • ****
  • Posts: 321
    • MWA Software
Re: I installed IBX now I have "orphaned" files. What do I need to do?
« Reply #11 on: January 31, 2018, 12:48:05 am »

<snip>

          Params.Add('user_name=' + UserNm);
          Params.Add('password=' + Pwd);

          Params.Add('page_size=' + IntToStr(pg_sz));
          Params.Add('lc_ctype=' + char_set);
          Params.Add('sql_role_name=' + RoleNm);

          CreateDatabase;
          Connected := True;

        end;

<snip>

What is the proper way to specify a page size when creating a database using IBX?
I am using Lazarus 1.8, Fpc 2.0.4, and Firebird 3x.

The correct way to create a database and to specify the page size is to use a CREATE DATABASE SQL statement e.g.

CREATE DATABASE '<database name>' USER SYSDBA PASSWORD '<sysdbapassword>'  PAGE_SIZE=nnn DEFAULT CHARACTER SET UTF8;

and pass this as a parameter to TIBDatabase.CreateDatabase. The CREATE DATABASE statement is described in the Firebird Language Reference. Note that you cannot specify a role name when you create a database. Until you have executed a  CREATE ROLE DDL statement, there are no roles defined for the database.

Note that the current version of IBX is 2.1.0

 

TinyPortal © 2005-2018