Re: [lazarus] Interbase library
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 := SqlT; SqlT.StartTransaction; SqlQ.Database := DbConn[DatabaseOffset].SqlD; SqlQ.ParseSQL := FALSE; SqlQ.SQL.Text := QueryStr; Joost van der Sluis wrote: 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. _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 := DbConn[DatabaseOffset].SqlD; SqlQ.ParseSQL := FALSE; SqlQ.SQL.Text := QueryStr; Joost van der Sluis wrote: 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. _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
Joost van der Sluis wrote: > 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 nowadays I still wait too long before I > commit things. (Like the oracle-connection) If code doesn't compile, you can always work in a branch and commit. See e.g.http://svn.freepascal.org/svn/fpc/branches/florian/ :) _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 bills - indirectly) Joost van der Sluis wrote: 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 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', '0', 'P1', '0', '0', 'XXX-03', 'XXX-03', 'XXX-03', '' ) fails with the following err: PREPARESTATEMENT: [LF] -DYNAMIC SQL ERROR[LF] -SQL ERROR CODE = -104[LF] -TOKEN UNKNOWN - LINE 1, CHAR 176[LF] -A1 Thanks _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 nowadays I still wait too long before I commit things. (Like the oracle-connection) Joost. _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 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', '0', 'P1', '0', '0', > 'XXX-03', 'XXX-03', 'XXX-03', '' ) > > fails with the following err: > PREPARESTATEMENT: [LF] -DYNAMIC SQL ERROR[LF] -SQL ERROR CODE = > -104[LF] -TOKEN UNKNOWN - LINE 1, CHAR 176[LF] -A1 > > Thanks > > SteveG wrote: > > > 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 from your examples I need IbConnection in the uses as well? > >>> When I compile the alisttables.pp example, I get the error > >>> 'SqldbExampleUnit.pp(80,72) Warning: Constructing a class > >>> "TIBConnection" with ab > >>> stract methods' - which brings me back to where I began to have > >>> problems > >>> > >> > > _ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject >archives at http://www.lazarus.freepascal.org/mailarchives > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 at 08:31 +1000, SteveG wrote: >> Thanks Joost - working find now >> does SqLite work using SqlDB, or is it seperate ? >> _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
SqLite works seperate. There was an connection for sqldb for SqLite, but it got lost in a HD-crash. ;-( But now the sqlite-components from Luis Pereira are available, which also works very good. On Wed, 2006-02-22 at 08:31 +1000, SteveG wrote: > Thanks Joost - working find now > does SqLite work using SqlDB, or is it seperate ? > -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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', '0', 'P1', '0', '0', 'XXX-03', 'XXX-03', 'XXX-03', '' ) fails with the following err: PREPARESTATEMENT: [LF] -DYNAMIC SQL ERROR[LF] -SQL ERROR CODE = -104[LF] -TOKEN UNKNOWN - LINE 1, CHAR 176[LF] -A1 Thanks SteveG wrote: 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 from your examples I need IbConnection in the uses as well? When I compile the alisttables.pp example, I get the error 'SqldbExampleUnit.pp(80,72) Warning: Constructing a class "TIBConnection" with ab stract methods' - which brings me back to where I began to have problems _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 from your examples I need IbConnection in the uses as well? When I compile the alisttables.pp example, I get the error 'SqldbExampleUnit.pp(80,72) Warning: Constructing a class "TIBConnection" with ab stract methods' - which brings me back to where I began to have problems I was already affraid that you would see that. But if you take a good look, you'll see that these are only warnings, and yo can ignore them. The examples will compile. These warnings are fixed in the latest svn-development branche, and I admit it's somewhat confusing. Could you let me know how to correctly compile your examples please - I'm sure I can work it from there Just did as you did above, and ignore the warnings. Joost. _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 from your examples I need IbConnection in the uses as well? > When I compile the alisttables.pp example, I get the error > 'SqldbExampleUnit.pp(80,72) Warning: Constructing a class > "TIBConnection" with ab > stract methods' - which brings me back to where I began to have problems I was already affraid that you would see that. But if you take a good look, you'll see that these are only warnings, and yo can ignore them. The examples will compile. These warnings are fixed in the latest svn-development branche, and I admit it's somewhat confusing. > Could you let me know how to correctly compile your examples please - > I'm sure I can work it from there Just did as you did above, and ignore the warnings. Joost. _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 from your examples I need IbConnection in the uses as well? When I compile the alisttables.pp example, I get the error 'SqldbExampleUnit.pp(80,72) Warning: Constructing a class "TIBConnection" with ab stract methods' - which brings me back to where I began to have problems Could you let me know how to correctly compile your examples please - I'm sure I can work it from there Thanks again Joost van der Sluis wrote: 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 sqldb. Joost _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
> 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 sqldb. Joost _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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; InitialiseIbase60; end;' (and then release it in the Finalization section of the unit - if LibLoaded then ReleaseIbase60;) This appears to make sense (if I have done it correctly), but I still receive the 'missing gds32.dll' error Any suggestions ? Joost van der Sluis wrote: 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 automatically require, and attempts to access the gds32.dll (not present on the clients) Is there anyway I can (thru code, not recompiling) only load the gds32.dll when required (ie when I say so)? You can use the loadlibrary procedure with the other functions in the Dynlibs library. But why don't you simply use the ibase60dyn unit which is provided with freepascal? JoJo, Joost. _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Interbase library
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 automatically require, and attempts to > access the gds32.dll (not present on the clients) > Is there anyway I can (thru code, not recompiling) only load the > gds32.dll when required (ie when I say so)? You can use the loadlibrary procedure with the other functions in the Dynlibs library. But why don't you simply use the ibase60dyn unit which is provided with freepascal? JoJo, Joost. _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
[lazarus] Interbase library
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 gds32.dll (not present on the clients) Is there anyway I can (thru code, not recompiling) only load the gds32.dll when required (ie when I say so)? using Windows XP, latest Laz/fpc Thanks _ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives