Stack Overflow
Stack Overflow

Questions tagged [fibplus]

29 questions
4
votes
1 answer

Determine a parameters data type in a parameterized query using Zeoslib

Is it possible to determine a parameters data type in a parameterized query using Zeoslib and Firebird? I'm migrating from FibPlus to Zeoslib. with a stament like 'select name, surname, age from members where registration > :since and nationality =…
maz
  • 41
  • 3
3
votes
2 answers

How to read a BLOB(Text) field using TpFIBQuery components from FibPlus

I am using Delphi 7 with the FibPlus components . One of them being TpFIBQuery. I am loading data from a table with the generic select * from TableName where Key = 1 One of the fields returned is of type BLOB(Text). I can't seem to get the value…
Edelcom
  • 5,038
  • 8
  • 44
  • 61
2
votes
1 answer

How to extract stored procedure DDL using FireDAC

I am in the process of changing from FIBPlus to FireDAC, and most functionality I need is in FireDAC, I'm just battling to find the FIBPlus equivalent of TpFIBDBSchemaExtract and TpFIBScripter for extracting the stored procedures as DDL. Does…
Maya
  • 421
  • 6
  • 12
2
votes
1 answer

Delphi - dynamically add all fields at runtime generate duplicates in dataset

Based on How to add a field programatically to a TAdoTable in Delphi I am trying to add all the fields dynamically to a FibPlus dataset (could be any TDataSet descendant). Each field is declared as a variable. Declarations part TForm4 =…
RBA
  • 12,337
  • 16
  • 79
  • 126
2
votes
2 answers

TpFIBTransaction giving error: Transaction is not active in Delphi XE4 with FIBPlus 7.5

I am migrating from Delphi 7 to Delphi XE4. With Delphi XE4, I am using FIBPLUS 7.5. Delphi 7 application is running fine but I am getting a runtime error in Delphi XE4: "Project abc.exe raised exception class EFIBClientError with message…
user1556433
2
votes
1 answer

Delphi - Firebird data migration - different character sets

I need to migrate the data from different old databases to the new ones (created with IBExpert on Firebird 2.5). I'm using the FIBPlus components. Now I know that the old varchars and blob texts are in different character sets and collations(most of…
RBA
  • 12,337
  • 16
  • 79
  • 126
2
votes
1 answer

Proven/recommended way to migrate application from FIB+ to Fire-DAC components

I'm migrating a large family of applications having hardwired FIB+ connectivity inside to Fire-Dac components and I'm looking for some least painfull way, how to do it. First, I've decoupled and migrated the backend to get connectivity neutral and…
pf1957
  • 997
  • 1
  • 5
  • 20
1
vote
1 answer

How to use MasterSource and MasterFields capability using FibPlus datasets or FibQuery

I am rewriting an existing BDE database program to use Firebird using the FibPlus components. Since I almost every where used TQuery components, the change is fairly straightforward. Apart from one thing I dont't seem to find : In one of my forms I…
Edelcom
  • 5,038
  • 8
  • 44
  • 61
1
vote
4 answers

How to save jpg image to database and then load it in Delphi using FIBplus and TImage?

How do I save a jpg image to database and then load it in Delphi using FIBplus and TImage?
Grrey
  • 671
  • 1
  • 6
  • 4
1
vote
1 answer

How to use parameters in TpFIBDataSet SQL query?

I am using FIBPlus library and Delphi 10.3 Rio. Inside my project I have TpFIBDataSet component. Under SQL Generator I defined SQL Select with 'where clause' and inside 'where clause' I have one parameter. My SQL Select and parameter called…
Tripta
  • 35
  • 7
1
vote
1 answer

How to catch an exception of Interbase on Connect when gdb file doesn't exist on a given path

I have fib+ comps installed on my machine and trying to catch Interbase exception on connecting but one exception I cannot catch try { DM->dBase->Connected=false; DM->dBase->DBName=DBPATH; DM->dBase->Connected=true; }…
Suhrob Samiev
  • 1,528
  • 1
  • 25
  • 57
1
vote
1 answer

Call to isc_dsql_sql_info() causes temporary directory overflow

There's a SQL query joining a temporary table with a view (joining two tables): select main.* from tmp_table_srt sub -- temporary table inner join vw_s_ad_conjunct main -- joining tables M_S_AD_CONJUNCTION and M_S_AD on sub.I_SRTREF = 94646…
René Hoffmann
  • 2,766
  • 2
  • 20
  • 43
1
vote
1 answer

Rolling back Transaction Doesn't Work with TpFIB Components

I am using Delphi 2010 with FIB Components like TpFIBDataset, TpFIBTransaction and TpFIBDataset with Firebird database. I have already set TpFIBDataset's 'AutoCommit' property to 'False', then also when I execute below statement in the try..finally…
Vishal Tiwari
  • 739
  • 2
  • 12
  • 28
1
vote
1 answer

What Does ".closeopen" method of TFIBDataset Component Do?

I am using FIB Plus components with Delphi 2010, just would like to know what closeopen(true) does. I tried googling but didn't get info on it. FIBDataSet.closeopen(true);
Vishal Tiwari
  • 739
  • 2
  • 12
  • 28
1
vote
1 answer

OpenAsClone function causing error in Delphi XE4

I have 2 datasets like following in my Delphi XE4 application: object dsDestination: TpFIBDataSet object Field1: TFIBStringField FieldName = 'MYSTRING' Size = 1 Transliterate = False ene object Field2:…
user1556433
1
2