Zeoslib Portal

btrewern

You need to login to see attachments.

Regards,

Ben

btrewern

First thing first - Don't use TZTable for anything other than very small tables!!

Try using Locate or Lookup.

Regards,

Ben

btrewern

What database are you using? In PostgreSQL I look up the required id for the field SELECT nextval(seq_name); and enter it into the dataset. It can then be posted to the database (ApplyUpdates) when needed or discarded if the user decides to cancel the transaction. I hope this helps, Regards, Ben

btrewern

Mark, Just tested this using task manager and some quite large query results and it does seem to make quite a difference. I could easily use all my swap space using TColumnArray=array[0..131072] of byte; TZRowBuffer = packed record Index: Integer; UpdateType: TZRowUpdateType; BookmarkFlag: Byte; Col...

btrewern

Mark,

Is this per table, per row or what? If it's per row then I'm not sure it's a good idea to x4 the memory used for just this case.

Regards,

Ben

btrewern

mdaems,

Does the TZSequence component work for all databases? I haven't tried it yet but I'll have a go now you mention it.

Thanks,

Ben

btrewern

You do also need to add all the folders within the Zeoslib src folder to your Library path.

Regards,

Ben

btrewern

BTW if you want to not have to refresh the row you can use

Code: Select all

SELECT GEN_ID(MAPS_ID_GEN, 1) FROM RDB$DATABASE;

to find the next ID and then enter it manually. I do this in PostgreSQL to get round similar issues.

Ben

btrewern

You can try using Lazarus see: http://www.lazarus.freepascal.org/ or I think you could install just part of Zeos and use the ZDBC API. See the Knowledge Base. the main problem with not having TDataset support is you'll not be able to use any data aware components - I'd have a look at Turbo Delphi. Y...

btrewern

If you try

Code: Select all

SELECT CAST("field" as integer) as "FieldName" From "table";

It may work.

Looks like this is to do with the slightly brain dead way Zeos finds the type of columns.

Regards,

Ben

btrewern

You could use:

Code: Select all

SELECT CASE WHEN "field" THEN 1 ELSE 0 END FROM "table";

You can also try

Code: Select all

SELECT CAST("field" as integer) FROM "table";

Regards,

Ben

btrewern

I would guess that Zeos is parsing your SQL to find parameters. Sees the = after the : and barfs. Not sure what needs to be done to fix this though. Try setting ParamCheck to False.

Regards,

Ben

btrewern

I think you'd be better off using the pg_dump and pg_dumpall included in the Postgresql distro. They are made for the purpose.

Regards,

Ben

btrewern

Shouldn't the parameter be 'connect_timeout' and should be set on the server itself.

Regards,

Ben

btrewern

I expect it's a limitation of the stringgrid. Try looking for a different component e.g. Virtual Treeview (http://www.soft-gems.net/index.php?opti ... &Itemid=33could do what you want but takes a little effort to program for.

Regards,

Ben

Search found 193 matches