Sqlite --> CreateTable but the DB file is 0Kb.
lazarus / 16-Databases

----------------------------------------------------------------------
alepio · 2008-12-10 17:55

this is my simple code:
Quoteprocedure TForm1.FormCreate(Sender: TObject);
begin
  Sqlite3Dataset1.TableName:='prova';
  Sqlite3Dataset1.Filename:= ExtractFilePath(application.ExeName) +
'data.db' ;
  ForceDirectories(ExtractFilePath(application.ExeName));
  with Sqlite3Dataset1 do
  begin
    FileName := ExtractFilePath(application.ExeName)  + 'data.db';
    if not TableExists then
    begin
      FieldDefs.Clear;
      FieldDefs.Add('Id', ftAutoInc);
      FieldDefs.Add('IdScanner', ftString);
      FieldDefs.Add('Action', ftString);
      FieldDefs.Add('Entrepot', ftString);
      FieldDefs.Add('Produit', ftMemo);
      FieldDefs.Add('DateInventaire', ftDate);
      FieldDefs.Add('HeureInventaire', ftTime);
      FieldDefs.Add('Stade', ftInteger);
      CreateTable;
    end;
    Open;
  end;
end;

This code create an file data.db 0Kb.
The function CreateTable result FALSE WHY?
the sqlite3.dll (for wince ) is the version 6.3.4.
Tks
Alessandro

----------------------------------------------------------------------
alepio · 2008-12-11 14:09

Help me!

----------------------------------------------------------------------
felipemdc · 2008-12-13 13:41

Oh, one hint. In Windows CE there is no such thing as "application
directory", so just putting the .DLL in the same dir as the EXE won't
do. Put it in the Windows directory.

If that doesn't work, I don't know ... I rarely work with databases.
Try asking in the lazarus mailling list. There are a couple of people
there which use lazarus for wince and sqlite.

----------------------------------------------------------------------
alepio · 2008-12-13 17:21

That work!!
Is the Emulator that wrong.