Re: [lazarus] Interbase library

2006-02-23 Thread SteveG
Adding the line didnt seem to make any diff - this is the ordering of my code if thats any help SqlT := TSqlT.Create(NIL); SqlQ := TSqlQ.Create(NIL); DbConn[DatabaseOffset].SqlD.Transaction := SqlT; SqlT.StartTransaction; SqlQ.Database :=

Re: [lazarus] Interbase library

2006-02-23 Thread SteveG
Sorry - should have stuck Joost's name on top for relevance SteveG wrote: Adding the line didnt seem to make any diff - this is the ordering of my code if thats any help SqlT := TSqlT.Create(NIL); SqlQ := TSqlQ.Create(NIL); DbConn[DatabaseOffset].SqlD.Transaction

Re: [lazarus] Interbase library

2006-02-22 Thread Florian Klaempfl
Joost van der Sluis wrote: SqLite works seperate. There was an connection for sqldb for SqLite, but it got lost in a HD-crash. ;-( That's why you should commit early to svn :) But now the sqlite-components from Luis Pereira are available, which also works very good. On Wed, 2006-02-22

Re: [lazarus] Interbase library

2006-02-22 Thread Micha Nelissen
Joost van der Sluis wrote: SqLite works seperate. There was an connection for sqldb for SqLite, but it got lost in a HD-crash. ;-( Commit early, commit often, let the web backup/mirror your stuff ;-). (As Linus once said). Micha

Re: [lazarus] Interbase library

2006-02-22 Thread Joost van der Sluis
Could you try it again with ParseSQL := False? If that works it's still a bug, but then I know where to look at it. Ow, and could you try to remove the TimeIn (12:55) ? And the DateIn (22/02/2006) ? On Wed, 2006-02-22 at 13:29 +1000, SteveG wrote: Drat - spoke (or typed) too soon can you tell

Re: [lazarus] Interbase library

2006-02-22 Thread Joost van der Sluis
On Wed, 2006-02-22 at 13:15 +0100, Florian Klaempfl wrote: SqLite works seperate. There was an connection for sqldb for SqLite, but it got lost in a HD-crash. ;-( That's why you should commit early to svn :) At that time I didn't have cvs-write-access yet. But I have to confess that

Re: [lazarus] Interbase library

2006-02-22 Thread SteveG
Can do - possibly not till tomorrow though - have pulled my program apart (again) and need to get it stable to test understand about the Dt Tm - customer wants them this way for older program pulling data from file - cant (or wont) reformat to suit up the line (what can you do, they pay the

Re: [lazarus] Interbase library

2006-02-21 Thread SteveG
Thanks Joost - working find now does SqLite work using SqlDB, or is it seperate ? Joost van der Sluis wrote: On Tue, 2006-02-21 at 09:26 +1000, SteveG wrote: Now I know I haven't a clue :) If I remove the Interbase unit, Laz can no longer find the TIBDatabase / query / trans So I assume

Re: [lazarus] Interbase library

2006-02-21 Thread SteveG
Drat - spoke (or typed) too soon can you tell me whats wrong with this line (works ok using the Interbase unit) INSERT INTO NLISTest (RecIdent, DateIn, TimeIn, Agent, Lot, Paint, HeadCount,TagCount, ClientPIC, ClientNVD, ClientNAME, BeastPIC) VALUES ( '1370984712', '22/02/2006', '12:55', 'A1',

[lazarus] Interbase library

2006-02-20 Thread SteveG
I have an (fpc) dll function library that contains code for both Server and Client programs being created. The server code uses the Interbase unit to connect to firebird, but the clients do not need this. Problem is the IB unit seems to automatically require, and attempts to access the

Re: [lazarus] Interbase library

2006-02-20 Thread Joost van der Sluis
On Mon, 2006-02-20 at 22:57 +1000, SteveG wrote: I have an (fpc) dll function library that contains code for both Server and Client programs being created. The server code uses the Interbase unit to connect to firebird, but the clients do not need this. Problem is the IB unit seems to

Re: [lazarus] Interbase library

2006-02-20 Thread SteveG
Thanks Joost - having problems though If I follow it correctly, I place the 'Interbase, Ibase60Dyn' units in the uses section (this defines the flag for dynamic control) At the point just before I attempt to access the database, I place 'if LibLoaded = FALSE then begin LibLoaded := TRUE;

Re: [lazarus] Interbase library

2006-02-20 Thread Joost van der Sluis
If I follow it correctly, I place the 'Interbase, Ibase60Dyn' units in the uses section (this defines the flag for dynamic control) Please remove the interbase unit, it's obsolete and doesn't work with dyn. loading of the dll. If you need a dataset that can work with Interbase you should use