Zeoslib Portal

try this :
insert into Event ( B1, B2, B3) Values ( 'Y', 'N', 'N') ;

thanks for your contribution, probably it's better.

try to rebuild (not just compile) the package.
thx

I have the same problem. MASTER table: (notran, custno, kontak, .....) KONTAK table (id, nama, ....) DsMaster.DataSet := MASTER; KONTAK.MasterSource := dsMaster; KONTAK.MasterFields:='custno'; KONTAK.LinkedFields:='id'; MASTER contains lookupfield calls luKontak luKontak.LookupDataset:=KONTAK; luKon...

also u can use GetTableNames() function in ZConnection component

Lazarus based on FPC 2.0.4 does not support FieldEditor
Try to download and install lazarus based on FPC 2.1.1 or currently 2.1.5
you can download it from official lazarus url on the daily snapshot

regards

Detail dataset is automatically fill the key field with the value of master's key field. if master's key field is null (e.g. becouse the key field is autoincreament), the value of detail's key field also null. Solution : You first have to post (applyupdate) the master dataset (and get the key value)...

IF YOU ARE USING MYSQL 5, PLEASE CONSIDER THAT FLOAT TYPE OF
MYSQL IS BUGGY. TRY TO CHANGE TO DOUBLE TYPE.
REGARDS

Hi napi What mdeam says is corret, you don't have to make any modification in your DDL (Data Definition Language) like removing the primary key. Do not do anything over the DDL. Also you dont have to remove anything on your Dataset. You Just have change the "Required" property to False on ...

Thak you very much.......

Where can I download the latest version of SQLite Administrator?

Like swiersbicki said, u can use TStingList.

zippo is right, as far as I know, we can make multiple statements using ZProcessor or ZSequence, but we can't do that using ZQuery.

For retrieving field names you can use GetFieldNames function

ex. ZTable1.GetFieldNames(List);

regards

I made some revision in ZAbstractRODataset.pas, for fine-tuning such properties. The are now more stable and better behavior.
The changes based on revisions proposed by pawelsel and his testers, also some comments on the forum.
Regards.