Zeoslib Portal

There's no this kind of features in zeosLib... but you can always write it

It's a very nice feature...

mmm

first upgrade to firebird 2.1.1
second you upgrade/download from a LAN or WAN (internet)?
third how do you make upload/download?

tflessak wrote:I didn't use aliases (even on 2.04).
I tried both embedded and SuperServer.

That's really wierd.

try to copy firebird\bin\fbclient.dll to

<system32\fbclient.dll
<system32\gds32.dll

I'm not sure that it's changed... but try it...

I try with a new installation of firebird 2.0.5 and zeosLib 6.6.4

no problem to open a zconnection
no problem open a zquery with this SQL

I use alias to connect to database, and you?

I have a field defined DECIMAL(18,6) with a default value 100.000000 When I append a new record, I set default value using component TZSQLMetadada and this code: tabella_default := tzsqlmetadata.create(self); tabella_default.tablename := tabella_tablename; tabella_default.metadatatype := mdcolumns; ...

or more simple you can do
gbak -b myolddb.fdb mybckdb.fbk
del myolddb.fdb
gbak -r mybckdb.fbk myolddb.fdb

NB fo rfdb name file use always a fullpath name

You can check default install dir with registry key HKEY_LOCAL_MACHINE\SOFTWARE\Firebird Project\Firebird Server\Instances into the string DefaultInstance you can find full path of firebird server installation. However you can use command line tool instclient i[nstall] [ -f[orce] ] fbclient.dll to a...

you cant make a FK on a not primary key field...

Foreign key would be a PK or a candidate key in referenced table

mdaems wrote:Fabio, did you check Postgres? (I'm not a postgres user, but I heard about events or something similar)

Mark

checking...........

mdaems wrote: Dream on

I 'm Firebird Foundation Committee Member, so ...

...Are you a candidate?

I will do, but I don't know when. I'm organizing FBCon 08 in Italy in september so I'm a bit busy at the moment...
But I wanna help, I believe a lot in this project!!!!

I can't find prepare query command.
I know this is probably a firebrid only feature!
I need it to prepare a query and after this operation understand all fields, parameters datatype

query.FieldByName('FIELDNAME').Datatype....

TonyG wrote:Hello to all.

I use MySQL with ZEOS and I need events too. I would like to know if is it possible to know when a table have been changed (insert, delete or just update a record) for refreshing the data.

Thanks in advance.

Anthony.

Events are ONLY a property of firebird. No other RDBMS have it

I hoep to have some freetime to port to 6.x

noone remember where can I retrieve TZIBEventAlerter?

really?

I need to develop event handler for firebird 2.0.x but I can't download TZIBEventAlerter from the site.
Someone can tell me if there is a copy somewhere and if is compatible with 6.5.x?