[firebird-support] Re: Error using a transaction parameter block with the OO API.

> TPB must start with isc_tpb_version1 or isc_tpb_version3 Thank you. I've added tpb.insertTag(status, isc_tpb_version3); as the first inserted tab but unfortunately I get the same error (I've also tried various other arrangements with no luck. > IIRC, by default transaction started as

[firebird-support] FB 3 and FreeeUDFLib

In earlier posts I asked for help as FreeUDFLib.dll was not working in my FB 3 installation. fbvlad gave me the answer "it requires gds32.dll" but I misunderstood his reply. I am using date and time functions in FreeUDFLib. Looking at FreeUDFLib.dll in DependencyWalker shows it calls

[firebird-support] Re: Error using a transaction parameter block with the OO API.

---In firebird-support@yahoogroups.com, wrote : > I'm using the Firebird 3.0 release version. Delphi 10.1 Berlin with the > firebird.pas release file and fbclient3. I can connect to the database > and can run queries, but I can't seem to get a custom transaction parameter

RE: [firebird-support] Why does "IF (NOT(EXISTS(SELECT 1..." not work as expected?

Greetings Thomas, Yes, I first have to get my tables cleaned up and then add cascading delete foreign key constraint on PER_ADDRESS referencing ADDRESS Thanks, Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, May 12, 2016 12:29

RE: [firebird-support] Why does "IF (NOT(EXISTS(SELECT 1..." not work as expected?

Greetings Helen, You're the best. Unbelievable amount of valuable information packed into your reply. I really appreciate the time you took in providing a detailed reply, as I have learned much from you. I threw this SP together quickly and actually had just a SUSPEND statement in this to

RE: [firebird-support] Checking Ods version (2.5 <-> 3.0)

No Server involved. I am directly using the fbembed/fbclient.dll for for connecting to an fdb file. I'm a Firebird embedded user. From: firebird-support@yahoogroups.com [firebird-support@yahoogroups.com] Sent: Thursday, May 12, 2016 20:18 To:

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

On 12-5-2016 20:18, liviusliv...@poczta.onet.pl [firebird-support] wrote: > This detection is useless . > use the latest library (FB3) and you can connect to any older servers But that isn't really useful if you want to find out if you need to upgrade a database. Mark -- Mark Rotteveel

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

Hi, This detection is useless . use the latest library (FB3) and you can connect to any older servers regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Thursday, May 12, 2016 6:50 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Checking

Re: AW: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

On 11-5-2016 16:04, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > I have already tested the new version of firebird, but I think it is not my > part to understand everything how firebird works. MSSQL I can install in > every version, except new functions everything works in a new

Re: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

On 10-5-2016 16:03, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > We had FB 2.5 CS before our migration to fb 3 SS. After this, the > Frontend (MS-ACCESS) calls a stored procedure and sometimes the > odbc-driver does not wait until the procedure finished and writes the > new

[firebird-support] Error using a transaction parameter block with the OO API.

I'm using the Firebird 3.0 release version. Delphi 10.1 Berlin with the firebird.pas release file and fbclient3. I can connect to the database and can run queries, but I can't seem to get a custom transaction parameter block to work. Here's my code: // Transaction :=

RE: [firebird-support] Checking Ods version (2.5 <-> 3.0)

I missed to say that it’s all about embedded usage. So before executing any statement I would need to know what firebird library to use for connecting. My use case is actually detecting pre ODS 12 databases and doing a backup/restore to get them into the current format. From:

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

Hi, i do not know what do you mean “to check” Can you connect to db? or you cannot and need to check? If you can connect, then this is simple: SELECT r.MON$ODS_MAJOR, r.MON$ODS_MINOR FROM MON$DATABASE r regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent:

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

12.05.2016 16:02, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] wrote: > is there an easy/official way to check the ODS versions? No. http://tracker.firebirdsql.org/browse/CORE-4679 -- WBR, SD.

[firebird-support] Checking Ods version (2.5 <-> 3.0)

Hi, is there an easy/official way to check the ODS versions? I was going the gstat route but the 2.5 gstat doesn't know anything about ODS 12 and up and the 3.0 gstat only knows about ODS 12 and up. Both gstats throw errors in case of an unknown ODS Version but it feels wrong relying on that

RE: [firebird-support] Database Unavailable

No. It actually connects in much the same way as Firebird. You do not need to share the database folder. It broadcasts a server name which the client searches for to connect. You don't even need to point to the server by name or IP. The client will find it for you. By the way the reason I'm

Re: [firebird-support] Database Unavailable

12.05.2016 16:34, 'Bill Skelton' b...@landmarkdata.com [firebird-support] wrote: > I was trying to use a mapped drive to a shared folder Just out of curiosity: does Sybase SQL Anywhere allow such database usage? -- WBR, SD.

RE: [firebird-support] Database Unavailable

Thank you Karol. A picture is worth a thousand words! I was trying to use a mapped drive to a shared folder when I needed to reference the database location using the server’s path. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, May 11,

AW: AW: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

Hello Mark, for some firebird-problems – yes, one of them is fixed. About odbc I got no reaction. We are using some stored procedures and tables, I thought, it is possible that fb 3 works every time correct how fb 2.1 and my tests without many clients ends great.. Von:

Re: [firebird-support] database unavailable

Hello Bill, > Used IB 10 years ago. Porting an SQL Anywhere app to FB 2.5. Going well > until I try to connect a client to the database - "database unavailable." I > have shared the DB folder on my Windows 7 machine, can browse to it from a > client machine (Win 10) and see Full Control

Re: [firebird-support] IN OUT PARAMETERS

12.05.2016 9:49, 'Mihalache Bogdan' bogdan.mihala...@soter.ro [firebird-support] wrote: > In firebird is there an option to declare a parameter in a stored procedure > as an IN/OUT. No. Read Language Reference. IN parameters are completely separated from OUT parameters. -- WBR, SD.

Re: [firebird-support] IN OUT PARAMETERS

> In firebird is there an option to declare a parameter in a stored procedure > as an IN/OUT. (like ORACLE server has) > http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/parameter_declaration. > htm > > > > > > I want to send a parameter to a procedure, do some operation with it, and >

[firebird-support] IN OUT PARAMETERS

In firebird is there an option to declare a parameter in a stored procedure as an IN/OUT. (like ORACLE server has) http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/parameter_declaration. htm I want to send a parameter to a procedure, do some operation with it, and return his new value.

Re: AW: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

On 2016-05-12 7:37, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hello again, > > the most funkctionality are very simply, just tables who linked to > msaccess. > I thought that firebird in every version can do this without any > problems - > how I said is this not in every case

AW: [firebird-support] Simply bad, new is not always better. FB3 and ODBC

Hello again, the most funkctionality are very simply, just tables who linked to msaccess. I thought that firebird in every version can do this without any problems - how I said is this not in every case true. Also the stored procedures - simplel sql - can do something and should work in fb 3 too.