Zeoslib Portal

btrewern

Yea sorry, RecordCount.

Ben

btrewern

What value do you expect RowsAffected to return for a SELECT statement? Arn't you looking for RowCount?

Ben

btrewern

Adrian,

If you want 'SELECT * FROM ...' to work then try putting something like:

Code: Select all

var
  i: Integer;
begin
  for i := 0 to ZQuery1.FieldCount - 1 do
  begin
    if ZQuery1.Fields[i].Required then
      ZQuery1.Fields[i].Required := False;
  end;
end;

in the AfterOpen event.

Ben.

btrewern

There's a svn repository at svn://firmos.at/zeos

Ben

btrewern

I don't think there is any built in support for array datatypes in ZeosLib. You may be able to insert data using the builtin firebird SQL commands. I had to do similar in Postgresql some time ago.

Regards,

Ben

btrewern

To download from SVN in windows use TortoiseSVN at http://tortoisesvn.tigris.org/

Ben

btrewern

What database are you using?

Ben

btrewern

I use ZeosLib 6.5.1 with PostgreSQL 8.x and everything relating to default values works well.

Regards,

Ben

btrewern

As I understand it this is only because the field objects are initialized as Required for Not Null fields. If you change that then everything just works.

Regards,

Ben

btrewern

Look at ZPlainPostgreSqlDriver.pas and ZPlainPostgreSqlxx.pas.

Ben

btrewern

I use QuotedStr() but I'm not sure if that covers you for every eventuality.

Regards,

Ben

btrewern

Try using the 7.4 version of the dll. Has worked for me against 7.4, 8.0 and 8.1 for some time now.

Ben.

btrewern

Try using ClientDataSets if you want this feature see cloned cursors. It does this kind of stuff and other clever things.

Ben

btrewern

Look at the source, find out what the problem is, fix it and that should solve your problem.

If you want better help please give at least some information.

Regards,

Ben

btrewern

I'm new to that too but try TortoiseCVS. Everyone seems to recommend it.

Ben

Search found 193 matches