Zeoslib Portal

Hello, Martin.

in postgresql current date can be obtained using CURRENT_DATE. For formating date field please use to_char function.

Good luck!

Yes, heavy. But if the only possible way to do it is this, then so be it. Its always better to do something than not to do
Right now I'm busy at my day work, but in free moment i'll give one more look at the code. You mention FPC - its free pascal I guess. Zeos supports both?

Hello,

I've investigated TField class and found no method to distinguish field with no value from one with value of NULL in it... Do you know if dataset gets noticed when the value is assigned to the field? If so - maybe theres a way to keep list of changed fields on dataset ?...

Ok - I read it. Generaly fixing one would fix the other. I'll try to investigate the possibility of setting "changed" or "assigned" flag on field. Even if its possible it should be intrusive. I'd have to change data assignment to field process, SQL generation (using just the righ...

Hello, Mark

Would you be more specific what discussion you have in mind? I tried searching, but with no results.

Hello, mdaems. From my point of view the bahavior should be similar to SQL's. That is if the field doesn't get the value of some sort it should by treated as unassigned. Lets say I have table foo(id integer, value varchar(20) default 'hello'. If I add some value to field "value" then on po...

Hello, so how about the status of this behavior. How would you address this issue - bug or a feature? If it's considered to be a bug, then what should be the way to fix it. I guess some flag "changed" should be set on field when somebody assigns value to it. Not assigned values should not ...

Hello, yes, I have used TZUpdateSQL component in the past, and I'm sure if I use it in my current application it will solve my problem (inserting NULL instead of default). I haven't looked at the output from a TZSQLMonitor, but I traced down to the place the SQL statement is formed in Zeos code - it...

I'm using zeos 6.6.5-stable with delphi 2006 to connect to postgresql (8.3.3). Theres a problem I'd like to discuss - how to insert a record with a null value if corresponding database column has default value? Thats wat I have: 1. In DB CREATE TABLE test ( id serial NOT NULL, "value" inte...

Hello,

Interval type in Postgresql is interpreted as string in Delphi (ftString). Anyway - editing it is a nightmare for a not English speaking person. Is there a component that could ease this?

trupka - could you send me your test project. I would test it on my computer. My email: kosh.mariux at gmail.com

OS: WindowsXP SP2

Sure, I did. When I do connect in design mode its all OK, but after building the project and then starting the service I get the error mentioned above.

Hello, I'm trying to make SERVICE that does some work to DB. The problem is that I get "Requested database driver was not found" then I try to do Connected := true. I copyed the needed dll's to the project folder and to the windows\system32 but still no connection. What to do? I even tried...