Lazarus and ZEOS lazarus / 16-Databases ---------------------------------------------------------------------- Josef Koller · 2005-05-19 06:59 Hello, I found yesterday the Lazarus Project and I have had tested it. Fine. I found all needed components like LazReport or a Graph-Component (TA) and the printer4lazarus-components. After the new Lazarus-Version all works fine. But I have problems to install the ZEOS Components. I followed the steps reported here in this forum. At first I startet csv.sourceforge.net, but I only get sourceforge.net. I found no possiblity to give "anonymus, etc. So I searched in the sofwaremap and found a link to zeosdbo_rework and I found the needed 5 files (zcore.lpk, parse.., plain, etc.). But after click to download I only get a "text-file", no download-file like zip-file. Than I found a patch on the ZEOS side. But it is only for ZEOS and Kylix (I have WIN32). Can you help me to find the correct way to install ZEOS in Lazarus? Many thanks and best regards Josef ---------------------------------------------------------------------- matthijs · 2005-05-19 16:10 I had put a ZEOSdbo_rework zip file on my ftp for someone else who could not cvs. If you want I can put it back on and let you download it. ---------------------------------------------------------------------- Anonymous · 2005-05-19 17:07 Hy for getting zeosdbo_rework with cvs,  you have to put CVSROOT to  ":pserver:anonymous@cvs.sourceforge.net:/cvsroot/zeoslib. In  my case this helped. ---------------------------------------------------------------------- Josef Koller · 2005-05-19 17:49 Quote from: "matthijs"I had put a ZEOSdbo_rework zip file on my ftp for someone else who could not cvs. If you want I can put it back on and let you download it. Hi, thanks. Where can I downöoad this Zip-File? Best regards Josef ---------------------------------------------------------------------- matthijs · 2005-05-19 20:03 ftp://willemstein.net/pub/zeosdbo_rework.zip should work. ---------------------------------------------------------------------- Anonymous · 2005-05-19 22:00 Thanks, now I have all packages (components) I need to develope a test application. After a first look I have many problems with the ztable. for example I get the message " Dataset is read-only ". but it isn't. than why can I select the fields for a dbgrid (in Delphi you can add or delete columns). Than I miss a possiblity to give a display or edit mask to the fields. How can I do this things? Best regards Josef ---------------------------------------------------------------------- Anonymous · 2005-05-20 11:23 Hello, I found the missing link. To edit datas I need requestlive:=true; In Delphi ZTable has this property. I found ztable1.requestlive in the codeidentifier. But after insert in the event form1.activate (for example) I got the message: error: Identifier idents no member RequestLive. In other events, too. What have I to do to get an editable Grid? Other question. I built the same application in Lazarus and Delphi (A form, Zconnection, ZTable, Datasource, DBGrid, DBNavigator). In Delphi the project is 1247 KB in Lazarus 12889 (factor 10 higher). Is that normal? Best regards Josef ---------------------------------------------------------------------- jesusr · 2005-05-21 07:27 Quote from: "Anonymous"Thanks, now I have all packages (components) I need to develope a test application. After a first look I have many problems with the ztable. for example I get the message " Dataset is read-only ". but it isn't. than why can I select the fields for a dbgrid (in Delphi you can add or delete columns). So you can in Lazarus, select the grid and in object inspector search columns property, select it and click the button there, the column editor will popup. Quote from: "Anonymous" Than I miss a possiblity to give a display or edit mask to the fields. How can I do this things? Best regards Josef Field.EditMask is not implemented (yet) in fcl/db (the package from fpc that provides db suport), Dbgrid provides a mean to set a editmask for each field using the OnFieldEditMask event, unfortunately this event is not yet published It will be published in the next grid's update. Jesus Reyes A. ---------------------------------------------------------------------- jesusr · 2005-05-21 07:49 Quote from: "Anonymous"Hello, I found the missing link. To edit datas I need requestlive:=true; In Delphi ZTable has this property. I found ztable1.requestlive in the codeidentifier. But after insert in the event form1.activate (for example) I got the message: error: Identifier idents no member RequestLive. In other events, too. What have I to do to get an editable Grid? Other question. I built the same application in Lazarus and Delphi (A form, Zconnection, ZTable, Datasource, DBGrid, DBNavigator). In Delphi the project is 1247 KB in Lazarus 12889 (factor 10 higher). Is that normal? Best regards Josef As dgEditing option is set by default and the ReadOnly property is set to false by default too, the only thing needed is one 'not ReadOnly' underlaying dataset active and linked to the grid throught a datasource. About the executable size, this is a topic discussed largely in the forum that only can  recommend to do a search and will find explanations and solutions. Jesus Reyes A. ---------------------------------------------------------------------- Anonymous · 2005-05-21 18:40 Hi, thanks for help. I gave the ztable1.readonly:=false-propberty to the form1.create-event and now it works. But I found another mistake. If I change the maxsize (default = 200) of a column (dbgrid)  I got the error Access violation Press Ok to ignore ..etc. After Ok Lazarus ends with an error. What's wrong? Any ideas? Best regards Josef ---------------------------------------------------------------------- jesusr · 2005-05-21 19:17 the problem appears when changing the columns size in the column editor or in code at runtime? Can you please follow the procedure described in http://lazarus- ccr.sourceforge.net/kb/index.php/Creating_a_Backtrace_with_GDB and sent me a backtrace to jesusrmx [at] yahoo.com.mx . Jesus Reyes A. ---------------------------------------------------------------------- Anonymous · 2005-05-21 20:08 the problem appears when changing the columns maxsize in the column editor. I haven't tested it in runtime. But I will do it. Josef ---------------------------------------------------------------------- Josef Koller · 2005-05-21 21:12 Quote from: "Anonymous"the problem appears when changing the columns maxsize in the column editor. I haven't tested it in runtime. But I will do it. Josef Hi again, I tested the maxsize at run-time. I gave a button1-onclick event the code dbgrid1.Columns[1].MaxSize:=300; No reaction. I only can drag the borders of the columns by mouse. Best regards Joef ---------------------------------------------------------------------- jesusr · 2005-05-22 00:10 Quote from: "Josef Koller"Quote from: "Anonymous"the problem appears when changing the columns maxsize in the column editor. I haven't tested it in runtime. But I will do it. Josef Hi again, I tested the maxsize at run-time. I gave a button1-onclick event the code dbgrid1.Columns[1].MaxSize:=300; No reaction. I only can drag the borders of the columns by mouse. Best regards Joef The properties MinSize,MaxSize,SizePriority are supposed to work together with AutoFillColumns grid's property. An algorithm will be implemented so when AutoFillColumns:=true the grid will autosize the columns so they fill( or fit) all available space according to these properties and some rules. At the moment the algorithm is not yet implemented, however a simpler one is used, when AutoFillColumns:=true SizePriority column's property indicates if the column should be autosized, if SizePriority is >=1, the columns will AutoSize, currently it is fixed to 1 so all columns (except fixed ones) are autosized. Being MaxSize not used at the moment it's weird that it cause AV's, I will check this ASAP. Jesus Reyes A. ---------------------------------------------------------------------- matthijs · 2005-05-22 08:23 it is not as much a ZEOS problem but a dbGrid bug. Jesus, I sent you a Windows bt, and I'll try to get a Linux bt as well. ---------------------------------------------------------------------- Anonymous · 2006-05-18 22:44 I'm trying installing the zeoslib_rework.zip, but the IDE give this error: --------------------------- Error --------------------------- Runtime error 210 at $009505D9   $009505D9  FPC_CHECK_OBJECT,  line 468 of C:/lazarus/source/fpc/fpcbuild-2.0.2/fpcsrc/rtl/inc/generic.inc   $00801086  ZVARIANT_init,  line 1486 of C:/lazarus/zeosdbo_rework/src/core/ZVariant.pas   $0094D14D  fpc_initializeunits,  line 593 of C:/lazarus/source/fpc/fpcbuild-2.0.2/fpcsrc/rtl/inc/system.inc   $00401041  main,  line 76 of lazarus.pp --------------------------- OK   --------------------------- I'm not getting install the ZeosLib. What's this and how can i solve it ? I'm using a FPC 2.0.2 on Lazarus 0.9.14 . Thankz. ---------------------------------------------------------------------- Anonymous · 2006-05-19 18:16 I supossed that Zeos cannot be installed on this version of Lazarus... I had tried version 0.9.10, 0.9.12, 0.9.14 and 0.9.15. But, for my purpouses (connect with Mysql 4) only on version 0.9.10 Zeos is working ---------------------------------------------------------------------- Lord_ZealoN · 2006-06-06 20:39 Same in Lazarus 0.9.16, now, lazarus don't run ---------------------------------------------------------------------- barko · 2006-06-07 12:41 Upgrade fpc from 2.0.2 to 2.0.3... ---------------------------------------------------------------------- Lord_ZealoN · 2006-06-07 16:04 I may upgrade the fpcsrc directory and rebuild lazarus with zeos packages? I will try when back to home ---------------------------------------------------------------------- Lord_ZealoN · 2006-06-07 16:13 Uhm...how to upgrade? downloading from svn? I don't find fpc 2.0.3 download. ---------------------------------------------------------------------- barko · 2006-06-07 21:30 fpc source latest Upgrade from 2.0.2 to 2.0.3 fpc: for windows: unpack fpc.zip to "anywhere" go to "anywhere"\fpc directory and select all go to c:\lazarus\fpcsrc and paste open command line (cmd) and use this command: go to c:\lazarus\fpcsrc 1. make all clean 2. make install INSTALL_PREFIX=c:\lazarus\pp for linux (in console as root user): unpack fpc.zip to "anywhere" (use unzip command or mc) go to "anywhere"/fpc 1. make all clean 2. make install INSTALL_PREFIX=/usr 3. rm -f /usr/bin/ppc386 4. ln -s /usr/lib/fpc/2.0.3/ppc386 /usr/bin/ppc386 5. /usr/lib/fpc/2.0.3/samplecfg /usr/lib/fpc/2.0.3 /etc ---------------------------------------------------------------------- Lord_ZealoN · 2006-06-08 19:27 grrrrr D:\lazarus\components\zeoslib\src\component\ZPropertyEditor.pas(149,40 ) Fatal: Can't find unit PropEdits But in the uses section, if i do SHIFT+click in PropEdits it opens. ---------------------------------------------------------------------- Lord_ZealoN · 2006-06-08 20:45 Well, seems to work. After the make FPC....you may rebuild Lazarus. Then, compile again all the packages in order, an finally compile and install zcomponent.