Page 1 of 1

It's possibilities to create table with ZTable?

Posted: 09.08.2013, 19:44
by kermipl
Hi, I'm Lazarus user under Linux and I want to connect not only one SQL server for example MySQL, PostgreSQL or SQLITE3. It's posibility to create using this metod (it's from SQLITE3 dataset code)

Code: Select all


 with TABLENAME do
  begin
    FileName := 'odbiorcy.db';
    if not TableExists then
    begin
      FieldDefs.Clear;
      FieldDefs.Add('indeks', ftString);
      FieldDefs.Add('nazwa', ftString);
      FieldDefs.Add('spi', ftFloat);
      FieldDefs.Add('procspi', ftFloat);
      FieldDefs.Add('spw', ftFloat);
      FieldDefs.Add('procsp', ftFloat);
      FieldDefs.Add('zwi', ftFloat);
      FieldDefs.Add('proczwi', ftFloat);
      FieldDefs.Add('zww', ftFloat);
      FieldDefs.Add('proczww', ftFloat);
      FieldDefs.Add('prodi', ftFloat);
      FieldDefs.Add('prodw', ftFloat);
      CreateTable;
    end;
    Open;
   end;
[code]

Sory for my English...
Thank for yours time.

Posted: 11.08.2013, 11:37
by EgonHugeist
kermipl,

nope, we don't support that. Zeos is a common Component palette for several protocols. Supporting this would make much trouble with other providers. The FieldRefs do not support default values, foreign/primary keys indices etc. So this would we not more than an ad hock approach. Sorry.