Frequently Asked Questions (FAQ)

Home :: FIBPlus :: Articles :: Frequently Asked Questions (FAQ)

06/27/2007 :: Where and how to use FIBPlusTools?

05/14/2007 :: I want to display a field NUMERIC(18,6) in a pFIBDataSet (with persistent fields) in the currency format. I set the Currency property to True,

05/11/2007 :: Why in FIBPlus 6.5 do I get an error "COLUMN The column ... was specified multiple times for derived table unnamed." in some queries?

05/08/2007 :: When compiling FIBPlus I see the message "File not found" FIBDatabase.dcu. I did download FIBDatabase.pas and put it into the directory c:\fibplus\sources. Can you help me?

03/21/2007 :: Why are some records lost when I use the Locate method in the cmkLimitedBufferSize mode?

03/16/2007 :: What differs the TpFIBDataSet.ApplyUpdToBase method from TpFIBDataSet.ApplyUpdates?

03/16/2007 :: I purchased FIBPlus. Why do my applications compiled with FIBPlus still require registering the library?

03/12/2007 :: Is there a tool that automates BDE to FIBPlus conversion?

02/10/2006 :: When I define a filter for TpFIBDataSet, where is it executed, at the client or at the server? Is Filter equal to Where?

12/16/2006 :: Can you help me with a coding example showing how to program the handle of the database errors.

02/09/2006 :: How to install FIBPlus with Rubicon driver?

02/10/2006 :: What does the option PoForceIsNull mean?

02/10/2006 :: How to copy one table from one database to an identical table from the other database?

03/12/2007 :: When compiling my FIBPlus applications for Turbo Delphi (BDS 2006) I get an error. What should I do to avoid it?

03/07/2007 :: What's an optimal scenario of using separate transactions in TpFIBDataSet in a multi-user Application? I mean what are best transaction settings for the two separate transaction?

03/07/2007 :: What happens with a record that is being edited if all its fields are empty and I do CommitRetaining of a transaction? Can I continue editing this record or will I have problems ?

12/16/2006 :: I'd like to know how to clone a dataset. Would you have an example (Step By Step) of how this is done?

03/07/2007 :: Why do I have very slow inserts of numerous records using Firebird (I have several hundred thousands of records)?

03/07/2007 :: Why is the parameter for MASTER_ID field in InsertSQL has a name different from the that of the column?

03/07/2007 :: I'm using FIBPlus to gain WWW database access using kbmwab. So every user needs to have a different but usable session. How to realize this?

03/07/2007 :: I have problems with paths to the database when I use Firebird Embedded

03/07/2007 :: Is there a component in FIBPlus that I can use to run SQL Scripts in?

03/07/2007 :: How to connect to a remote Firebird server using FIBPlus?

06/06/2004 :: Problems with FIBPlusEditors installation because Delphi cannot find the files FIBPlus.inc

06/06/2004 :: I am considering switching from IBX to FIBplus. What would it take to do that?

01/22/2006 :: I get an exception:"Variant or safe arrays out of bounds" on selecting any records sorted by "ORDER BY [NAME]" (in Kylix 3)

02/10/2006 :: How to use both servers Firebird and InterBase without recompiling FIBPlus?

03/01/2007 :: Why don’t FindFirst and FindNext methods work?

09/06/2003 :: Why is it better to work with InterBase/Firebird via FIBPlus than via BDE?

02/20/2006 :: Which transaction starts: Transaction or UpdateTransaction when poStartTransaction is True?

01/31/2007 :: How to obtain a correct number of records in TpFIBDataSet?

01/29/2007 :: What’s the difference between FIBPlus free trial version and its commercial analogue?

02/10/2006 :: How to check whether a table exists or not?

12/16/2006 :: There is an ExecSQL procedure in IBDataSet within an IBX-program. What's its analogue in FIBPlus (I need to use it in Insert/Update operations).

12/16/2006 :: Is it possible to use a prefixed database in TFIBQuery like: DELETE FROM DB1.TABLE1 WHERE DB1.TABLE1.FIELD1 = DB2.TABLE1.FIELD1

12/16/2006 :: In the BDE I have to appoint a session when I need more instances of a form on which tables are stored. But how can I accomplish this with FIBPlus?

12/16/2006 :: How to check whether a table exists or not?

12/16/2006 :: Does TFIBStringField support Unicode fields?

12/16/2006 :: I am planning to store images in a BLOB field. What is the best way to work with BLOBs?

12/16/2006 :: I'd like to clear params after running a query but can not find the correct property method. There's no Clear method or something like that. How can I clear the params?

12/16/2006 :: Can I get an example of LockRecord coding?

12/16/2006 :: Is it possible to use FIBPlus in a Linux console application without x-server libraries?

12/16/2006 :: Is there an easy way to clone database connections?

12/16/2006 :: I cannot work out the difference between HasUncommittedChanges and Modified for the Dataset

12/16/2006 :: How to create a "persistent" calculated field?

12/10/2006 :: When using the TpFIBDataSet, I do not seem to find a way to handle INT64 types. Help please

12/10/2006 :: I want to write arrays into an InterBase table. Why doesn't the following code work?

02/10/2006 :: What's FIBPlus equivalent of IBX ExecSQL procedure in IBDataSet?

02/10/2006 :: What happens first, BeforePost or OnNewRecord in AutoUpdateOptions.WhenGetGenID options?

02/10/2006 :: Problem with data not being visible between workstations

02/09/2006 :: After installation I have no SQL Generator in the right click options menu of the components