It's possibilities to create table with ZTable?

[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.

[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.