Zeoslib Portal

If you use a TZQuery component and you select from only 1 table, then the dataset is Read/write since the component knows how to do the updates (Insert, update, delete). Example SELECT * FROM Employees However, if you select from 2 or more tables, then the component DOES NOT know which table or fiel...

I am including components to connect Zeos components with Fast Report 4.x.

Please advice me if anyone has problems with it.

Regards,

Jay

I suppose that you have defined persistent fields for this query and that is the problem. Depending on the database and the server version, a COUNT() may return different integer types. For example, FB may return a INTEGER type (ftInteger) and MySQL may return a BIGINT Type (ftLargeInt). If you crea...

This is a fantastic start !!! congratulations!!!! How is this documentation going to be managed? 1) It should be somewhere in a downloadable file. 2) How are the diferent contributions going to be able to be incorporated without overlapping somebody elses work. For example, If 3 persons want to docu...

Jedi's JvQuery is a descendent on delphi's TQuery which depends on the BDE, which means that BDE MUST be installed along with your application. The main reason you would use Zeos or any other data access components is precisely not to depend on the BDE and have a "Native" access to the dat...

I just verified the situation you describe and I have no problem with it, it works correctly as it should. The only problem I see in your code is that you are putting blank spaces in the ROLENAME property, try it without the spaces. Your code says: Properties.Add(‘ROLENAME = ‘ + user_role) It should...

I agree with gury, TJvDBUltimGrid is an excelent component. Beside that, the JEDI VCL project has tons of excelent components.

Regards
Jay

I don't know PHP but you can accomplish this with only one DML statement INSERT INTO telford_1 (match_no, div, hometeam, sets_home, awayteam, sets_away, posted_on, posted_by) SELECT '' match_no, '1' div, TeamName hometown, '0' sets_home, '' awayteam, '0' sets_away, '' posted_on, '' posted_by) Regard...

I have looked deep into the sources and have not quite found exactly where the problem is, but it does appear to be a small bug in the interbase/firebird driver. background: Decimal types are stored internally as some variation of an integer type depending on the precision and scale of the decimal. ...

The situacion is the TYPE of variable or FieldType that is being generated, which is a TFloatField. This is NORMAL behaviour for most data access components. The fix being mentioned in this thread is ONLY functional for displaying purposes, e.g. display the value correctly, but internally, the value...

When the TField component is generated, it generates a TFloatField component which is equivalent to a DOUBLE PRECISION. This only affects the Delphi component and not the actual database. It should be generating a TBCDField or a TFMTBCDField component instead.

Regards
Jose Ostos

Thank you very much for your time and effort on this issue. I am in the process of moving my main DB to MySql 5 which will probably still take a couple of months. For the time being, the program I was intending to use Zeos 6.6 with, will be done with something else. When I have the DB in MySql 5 I w...

I am using the LibMySql40.dll that comes with the Zeos 6.6 download. I renamed it to Libmysql.dll and use the "mysql" option on the connection component, since there is no option for "mysql-40".

Regards
Jay

The Test I did was with a table of 31,000 records, 19 fields for the actual data. Besides, there are 6 other tables used for the dimension values which have: 2 records 4 records 43 records 143 records 6 records 19 records The problem is that this was actually just a test cube, most of the real cubes...

I have recently started to look into Zeos 6.6 after being a long time user of of Zeos in version 5 and abandoning my efforts with 6.1 a couple years ago. I just remembered why I abandoned it!! It was because I was having MAYOR speed problems with large MySql tables. I rememberd now that I am having ...