zeoslib - problem to open query lazarus / 16-Databases ---------------------------------------------------------------------- JanH · 2006-02-28 13:55 Hi, now that I have installed the zeoslib in lazarus 0.9.12 (Windows XP SP2) I created a sample app. I put a ZConnection and a ZReadOnlyQuery on my form and set the properties. But everytime I want to activate the query crashes the app. At design time it will crash lazarus, at run time it crashes my app. What's wrong? Anyone with the same problem? add: error: access violation -> runtime error 210 at $0050df59 ---------------------------------------------------------------------- matthijs · 2006-02-28 15:35 Check if you are connecting to an existing db, check if server is running, check ...  etc etc. It is very hard to tell what is wrong on your side if you do not give any information. ---------------------------------------------------------------------- Anonymous · 2006-03-01 06:23 okay, the database file exists, the connection seems to be okay because I set ZConnection.Active := true; and no error raises. I created a table for testing. Other Properties are: ZConnection: database := C:\temp\test.gdb hostname := localhost passwort := protocol := firebird-1.5 user := sysdba ZReadOnlyQuery: Connection := ZConnection Datasource := Datasource SQL := select * from test_table Datasource: DataSet := ZReadOnlyQuery The debugger opens the ZDbcInterbase6Utils at line 1777 (2nd line in funtion GetVersion). ---------------------------------------------------------------------- JanH · 2006-03-01 06:26 For ZConnection.Active I mean ZConnection.Connected ---------------------------------------------------------------------- barko · 2006-03-01 18:24 Quote from: "JanH"For ZConnection.Active I mean ZConnection.Connected JanH, which version of fpc do you use? ---------------------------------------------------------------------- JanH · 2006-03-01 18:32 The fpc version is 2.0.2. It's the version which is in the win32 installer of laz0.9.12. don't pay attention on my post "...ZConnection.Active...". I just was accustomed to SQLQuery from SQLdb-lib. ;-) ---------------------------------------------------------------------- barko · 2006-03-01 18:45 Good, because ZeosDBO doesn't work with fpc 2.0.2 and up. I miss in sqldb some things that are in zeosdbo... Like: ZUpdateSQL.DeleteSQL, ZUpdateSQL.InsertSQL, ZUpdateSQL.ModifySQL... or I can't find this functions in sqldb... this is usefull when user edit data in dbgrid... ---------------------------------------------------------------------- JanH · 2006-03-06 09:18 What functions are ZUpdateSQL.* you wrote? And why they are so useful. I also have a dbGrid where users can change data. if the changes should be saved I call IBConnection.Commit; (sqldb) ---------------------------------------------------------------------- Anonymous · 2006-03-07 15:24 I am using ZeosLib with latest lazarus and fpc2.1, but I needed to obtain the zeosdbo_rework (cvs files) and modify the compiler directives in zeos.inc. These changes have already been discussed in this forum. My biggest gripe is that whenever I am using the debugger, if I forget to reset the debugger before running my application then it generates an exception. ---------------------------------------------------------------------- Anonymous · 2006-03-07 21:04 Ha! I used to use the latest revisions of FPC and Lazarus, but since FPC build 2694, the integrated debugger has been broken in windows. It still works with FPC 2.0.2 and latest Lazarus. ---------------------------------------------------------------------- barko · 2006-03-08 09:49 Quote from: "JanH"What functions are ZUpdateSQL.* you wrote? And why they are so useful. You define ModifySQL with update statement, InsertSQL with insert statement and DeleteSQL with delete statement... and other do zeos for you. Example: Code: [Select] ZUpdateSQL.ModifySQL.text:='update tablename set field1=:field1, field2=:field2 where field3=:field3;'; When user change data in dbgrid (dbmemo), ZUpdateSQL update tables without any other programming... that is why is zeos for me very good...quick programming. ---------------------------------------------------------------------- JanH · 2006-03-08 10:30 Guest... can I anywhere download a latest compiled fpc? Or how can I compile the latest fpc-sources? I'm desperating but I absolutley want to use the zeos-lib ;-) ---------------------------------------------------------------------- barko · 2006-03-08 10:45 You can download latest fpc 2.1.1 from svn. Look here www.freepascal.org (Development). FYI: from today svn i can confirm that zeosdbo is useable again ... without patched Zeos.ini file... Ihaaaaaaaaaa Thanks to fpc dev team! ---------------------------------------------------------------------- Anonymous · 2006-03-08 12:22 Okay, I downloaded the latest fpc, compiled it with my current fpc. Then I replaced the compiled ppc.exe with the ppc386.exe. But if I try to compile a project there comes a compiler-error: Illegal paramter -TWin32... :-( ---------------------------------------------------------------------- barko · 2006-03-08 12:39 I think that you must compile with fpc 2.1.1? Try to compile with this http://ftp://ftp.de.freepascal.org/pub/lazarus/Lazarus-0.9.13- 20060308-win32.exe snapshot. compile with this command's from command line (cmd): cd path_to_fpc_source make clean all make install INSTALL_PREFIX=c:\lazarus\path_to_exist_fpc_dir (i think that is c:\lazarus\pp..) ---------------------------------------------------------------------- Anonymous · 2006-03-08 16:03 Hello..  my friend, I followed the steps but, at the moment of install the Zeos (rebuild Lazarus), I have to following message: "C:\lazarus\ide\lazarus.pp (1,1) Fatal: Can' t find unit LCLType" I tried to resolve it but without sucess.  Some idea? Thank you ---------------------------------------------------------------------- Anonymous · 2006-03-08 16:10 oops... I forgot to say: I'm under Windows XP and trying install zeosdbo_rework ("http://www.opinfos.com/tempo/zeos/zeosdbo_rework.tar.gz" , recomended for you in http://www.lazarus.freepascal.org/index.php?name =PNphpBB2&file=viewtopic&t=1952). Thank you ---------------------------------------------------------------------- barko · 2006-03-09 09:27 ftp://ftp.de.freepascal.org/pub/lazarus/Lazarus-0.9.13-20060309- win32.exe try this one, now is with yesterday fpc 2.1.1 first uninstall and remove lazarus dir, then install this one. ---------------------------------------------------------------------- Anonymous · 2006-03-10 07:23 I did having the problem above.  After a "Build Lazarus", Sucess.  However, with the SVN of the day 03/09/06 (20060309) the Zeos dot not install again. sorry for my bad english. Thank you