Zeoslib Portal

Hi use: TQuery.FieldByName('DATACADASTRO').AsDateTime := now; do not mix apples and oranges: DateTime is not TDate. Respectfully Silvio Guedes Yes, I think here's the problem, too by the way, you can use TQuery.FieldByName('DATACADASTRO').AsString := FormatDateTime('dd/mm/yyyy',now()); or TQuery.Fi...

Hello ! :) this is not the standard method (via bpg), but I like it :P I'll try to keep it simple: 1- download and unpack the zip contents to a directory that you can remember :) (I like to put it under delphi path\lib\zeos) 2- open delphi 7 3- using the file-open menu, open the folder you unpacked ...

Hello!

Are you setting the protocol property?
try with:

ZConnection1.Protocol := 'mysql-3.23';

hope it helps!

Hello there!

1st of all, please try to post with non capital text, it sounds like you're SCREAMMING!

please, tell us more details, like D2005 service pack, error message and more

and in the history there's some posts about issues with D2005, like here

The modified property comes from TDataSet in DB.pas
I dunno if it will work with zeos

Sometime ago I did almost the same thing, but it was not in a database project
I used a MD5 sum of the data
When needed, the program compares the old sum with the actual data, and everithing works !

Hello :) Well, dbExpress is a very thin layer between the application and database, so it's faster a bit.. In fact (answering your question), I think this is the only plus over Zeos. dbExpress, need to use connection drivers, and most of them are 3rd party commercial solutions... and the last time I...

Hello! I think that isn't possible to create directly from Zeos, I've searched a little and can't find anything =/ By the way, if you are using delphi, you may look at the "Interbase" palette (delphi 7 here), there is the IBDatabase component which have the CreateDatabase property... a thi...

What is your Zeos build? In the last one (cvs 13/10/2005), requestlive become readonly

Also, the options are inverted, when requestlive was active, now means readonly will be inactive

Using the way you tried, it will copy if you use something like this: for i := 1 to Query.RecordCount do begin ClientDS.Open; Query.Open; begin ClientDS.Insert; ClientDS.FieldByName('DestinyFieldName-1').Value := Query.FieldValues['SourceFieldName-1']; ClientDS.FieldByName('DestinyFieldName-2').Valu...

Hello gto, Just checking if BOF and EOF aren't both true, is imo the best way to check if a query didn't return a row. :wallb: I totally forgot about EOF and BOF ! :oops: thank you MarkusD !! There is an TZQuery.IsEmpty property which may be what you need. Regards, Ben tomorrow, in work, I'll check...

Hello!! Searching the forum and trying myself, I think the RecordCount is an expensive property and may be used with caution to avoid the component to pass through all the matched data only to count the rows... It's become more evident when we use big databases, like one I made to test, with 350000 ...

hello!

try the property RecNo

ZQuery.RecNo (ZTable and ZReadOnlyQuery has it too, I think) returns the number of the record in the "internal cache" of component

try it, see if it's what you are looking for

Yep! I've got problems with filters too, so there's my little function to convert a date in format "dd/mm/yyyy" to "yyyy-mm-dd": [syntax="delphi"] function FilterDate(Data: string): string; var Dia, Mes, Ano: string; begin Dia := copy(Data, 1, 2); Mes := copy(Data, 4, 2...

Hey zippo, I've been looking the sources for that option.. The main diference between SmartOpen and not SmartOpen is the procedure used to fetch the data on the background. The code actually is in ZDbcInterbase6Statement.pas Using SmartOpen will fire the ExecutePrepared function.. otherwise, the Exe...

Right!!
thanks for the attention anyway
We'll be waiting!