Some other questions.
The SQLiteToolbox program does not seem to use the sqlite3.dll. Is that the case? And my final question. Is source available for the SQLiteToolbox program?

attach

I installed version 0.50 in Delphi 2010. I playing around with the components and did some reading in the help file. Not all is clear to me and I'm getting warning messages.

Questions:

- I'm creating the database with:

dbSQLite.CreateDatabase('SQLitePassTest.db3', dbtUnknown, UTF16);

Q1. Is dbtUnknown the correct type? Any other type is giving me a warning after the second time that I open the database: Error while loading data from database. The "SqlitePass_DbSettings" table is corrupted or was created using an older version of this component.
Q2. I'm using UTF16 because delphi 2010 uses this as default string type. Is this correct what I'm doing?

- I created a table using the following code, this works fine

  With TSqlitePassEngine.Create(dbSQLite) do
  begin
    Try
      OpenDatabase(dbSQLite.Database);
      ExecSQL('CREATE TABLE [tblFileMemory] ([Filename] TEXT  NULL, [Filesize] INTEGER  NULL,[Filedate] INTEGER  NULL)');
    Finally
      CloseDatabase;
      Free;
    End;
  End;

- I've placed a TSQLitePassDataset and set the SQL to

SELECT * FROM [tblFileMemory]

When I try to open the Dataset I get the following error: TSqlitePassDataset.InternalOpen : Cannot Open Dataset.
The database is connected (checked) and assigned using the database property of the TSQLitePassDataset component.
I can't get this simple Select statement to work.

Help appreciated,
Pascal

I guess it is more compatible with delphi compilers with 'conditinal expressions(support in delphi 6+)'.

http://www.mediafire.com/?4xndnd0cf64z2al

p.s.

more modification for delphi & some bug fix.

http://www.mediafire.com/?3jxybdyce1e6nff

sqlite 3.7.0.1 for sqlitepass.

http://www.mediafire.com/?3f278273poa7o1y

This error occurs when I use a SQLitePassDataSet (in conjunction with the standard Data Source) on the list side of the combo

If I use the equivilent Zeos component on the list side of the combo then all is fine and works ok.

I'm trying to delete all the data in a certain table of SQLite database using a TSqlitePassDataset.
My TSqlitePassDataset is connected to the database and I try to use TSqlitePassDataset.EmptyTable;
Nothing happens until I call TSqlitePassDataset.Refresh. Then the data is deleted. Is this normal. In the code I see that FRefetchRows is set to True after the EmptyTable procedure.
Do we need to do somthing with this FRefetchRows ?

Regards,
Pascal

first: congratulation to this product, it seems a lot easier to use than the lazarus internal sqlite components.
and i need the blob-support, this is on of the main reasons i try it out. :-)

* i use lazarus 0.9.29 (win32)
* sqlitepass 0.5.1
* my sqlite database was created with sqlite expert 3.0.33.2068, file ending is ".db3".

what i want:
1. i try to create a database and a dataset object in a simple unit, not a form.
2. connect to the database
3. make a query the the db
4. show the result in a grid.
5. close the database and free all ressources.

but i have a problem, i can´t figure out. i post my code, and please correct it at any location if it is not the "best practise" way for sqlitepass. had this code yesterday written, it was my first try.

    // creating and connecting to the db
    sqlDB:=TSqlitePassDatabase.Create(nil);
    sqlCur:=TSqlitePassDataset.Create(nil);

    sqlDB.Database:='ds_db.db3';
    sqlDB.DatabaseType:=dbtSqliteExpert;  // is this right / nessessary ?
    sqlDB.Connected:=True;
    sqlCur.Database:=sqlDB;

    //quering
    sSQL:='SELECT a.*, b.WeCl2_Name, c.WeCl1_Name '+
               'FROM Weapons a '+
               'INNER JOIN WeaponClassification2 b ON a.WeCl2_ID=b.WeCl2_ID '+
               'INNER JOIN WeaponClassification1 c ON b.WeCl1_ID=c.WeCl1_ID '+
                'ORDER BY c.WeCl1_Name, b.WeCl2_Name, a.We_Name;';
    sqlCur.SQL.Text:=sSQL;
    sqlCur.Open;
   
    // no recordset-iteration, because of an easy example
    showmessage( sqlCur.FieldByName('WeCl2_Name').AsString );
    sqlCur.Close;

    // closing and freeing objects. is this enogh?
    sqlDB.Connected:=False;

    sqlCur.Free;
    sqlDB.Free;

it crashes on the line
    >sqlCur.SQL.Text:=sSQL;

the message is: excepotion "EDatabase Error", "1: no such column: Weapons._RowID_"
have tried the rewrite the select without ".*"(naming all fields) ->same result.
the query is ok, works with sqlite expert and the lazarus sqlite-components.

what i have to do to correct this prolem?

thanks.

When I run a simple app it executes correctly (code below) but when I close it gives "Project project1 raised exception class 'External: SIGSEGV'." I'm using Lazarus 0.9.31 in Ubuntu 10.10.

procedure TForm1.Button1Click(Sender: TObject);
begin
     with SqlitePassDataset1 do begin
          SQL.Text:= 'select chemid,name from chem_info where chemid= 3982';
          Open;
          showmessage(FieldByName('name').AsString );
          Close;
     end;
end;

In the form put a component and a component TSqlitePassDatabase TSqlitePassDataset. I went and compile these errors appeared:

/usr/bin/ld: warning: link.res contains output sections; did you forget -T?
//home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/lib/i386-linux/sqlitepassdbo.o: In function `main':
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/sqlitepassdbo.lpr:19: undefined reference to `THREADVARLIST_SQLITEPASSDBO'
//home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/lib/i386-linux/udm.o: In function `TDM__DATAMODULECREATE':
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASE'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATASET'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSRECORDSET'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSPARAMS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSINMEMORYINDEXES'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSINMEMORYINDEX'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSFIELDFILTER'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSFIELDFILTERS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSQLSECTIONS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSQLTOKENS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSQLTOKENIZER'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSQLSTMT'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSELECTSTMTTABLEDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASESATTACHED'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASEATTACHED'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSGENERICTABLEDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSELECTSTMTTABLEDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSELECTSTMTFIELDDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSELECTSTMT'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATASETVERSIONINFO'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATASETINDEXDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATASET'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASEERRORITEM'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASEERROR'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATASETS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTABLEDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASEINDEXDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSQUERYDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSVIEWS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTRIGGERS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSQLSTMTDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSCUSTOMFIELDDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSFIELDTYPESGENERICTRANSLATIONRULES'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSFIELDTYPESDEFAULTTRANSLATIONRULES'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSFIELDTYPESTRANSLATIONRULES'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASEDATATYPEOPTIONS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTRANSACTION'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSENGINE'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTRANSLATOR'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASEOPTIONS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASEVERSIONINFO'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSDATABASE'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSPARAM'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSFIELDFILTEREXP'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSQLTOKEN'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSGENERICFIELDDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSELECTSTMTFIELDDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSINDEXCOLUMNS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSINDEX'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTABLEFIELDDEFS'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTABLEDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTABLEFIELDDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSQUERYDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSVIEW'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSTRIGGER'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSSQLSTMTDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSCUSTOMFIELDDEF'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSFIELDTYPETRANSLATIONRULE'
/home/robson/Programas/lazarus/components/SQLitePass_0.55/Demo/udm.pas:36: undefined reference to `VMT_SQLITEPASSDBO_TSQLITEPASSINDEXCOLUMN'
//home/robson/Programas/lazarus/components/SQLitePass_0.55/Packages/Build/SqlitePassErrorLogDialog.o: In function `SQLITEPASSERRORLOGDIALOG_TSQLITEPASSERRORLOGDLG_$__SBCLEARCLICK$TOBJECT':
SqlitePassErrorLogDialog.pas:(.text+0x2da): undefined reference to `SQLITEPASSDBO_TSQLITEPASSDATABASEERROR_$__CLEAR'
//home/robson/Programas/lazarus/components/SQLitePass_0.55/Packages/Build/SqlitePassErrorLogDialog.o: In function `SQLITEPASSERRORLOGDIALOG_TSQLITEPASSERRORLOGDLG_$__SBSAVETOFILECLICK$TOBJECT':
SqlitePassErrorLogDialog.pas:(.text+0x3b0): undefined reference to `SQLITEPASSDBO_TSQLITEPASSDATABASEERROR_$__SAVETOFILE$ANSISTRING'
//home/robson/Programas/lazarus/components/SQLitePass_0.55/Packages/Build/SqlitePassErrorLogDialog.o: In function `SQLITEPASSERRORLOGDIALOG_TSQLITEPASSERRORLOGDLG_$__SBPRIORERRORCLICK$TOBJECT':
SqlitePassErrorLogDialog.pas:(.text+0x3cf): undefined reference to `SQLITEPASSDBO_TSQLITEPASSDATABASEERROR_$__GETPRIORERROR$$BOOLEAN'
//home/robson/Programas/lazarus/components/SQLitePass_0.55/Packages/Build/SqlitePassErrorLogDialog.o: In function `SQLITEPASSERRORLOGDIALOG_TSQLITEPASSERRORLOGDLG_$__SBNEXTERRORCLICK$TOBJECT':
SqlitePassErrorLogDialog.pas:(.text+0x3ff): undefined reference to `SQLITEPASSDBO_TSQLITEPASSDATABASEERROR_$__GETNEXTERROR$$BOOLEAN'
//home/robson/Programas/lazarus/components/SQLitePass_0.55/Packages/Build/SqlitePassErrorLogDialog.o: In function `SQLITEPASSERRORLOGDIALOG_TSQLITEPASSERRORLOGDLG_$__SHOWLASTERROR':
SqlitePassErrorLogDialog.pas:(.text+0x42f): undefined reference to `SQLITEPASSDBO_TSQLITEPASSDATABASEERROR_$__GETLASTERROR$$BOOLEAN'
sqlitepassdbo.lpr(19,1) Error: Error while linking
sqlitepassdbo.lpr(19,1) Fatal: There were 1 errors compiling module, stopping
------------------------------------------------------

Has a solution?

in TSqlitePassDatabaseDataTypeOptions.LoadFromDatabase you need to replace

if DbSettingsRecordset.RecordsCount = 0
  then Exit;

Try {1}
 Try {2}

[...]

 end; {Try 2 }
finally
StorageInfoStrings.Free;
MainPropertiesStrings.Free;
TranslationRulesStrings.Free;
CustomFieldDefsStrings.Free;
DbSettingsRecordset.Free;
end; {Try 1}

with

if DbSettingsRecordset.RecordsCount <> 0 then
Try {1}
 Try {2}

[...]

 end; {Try 2 }
finally

end; {Try 1}
StorageInfoStrings.Free;
MainPropertiesStrings.Free;
TranslationRulesStrings.Free;
CustomFieldDefsStrings.Free;
DbSettingsRecordset.Free;

Thank you for this library, I'm just starting to use it and I'm already happy with it!

I have an issue with parameters when using strings, see the code above. I'm not able to see where the bug happen.

  Dataset.Close;
  Dataset.Params.Clear;
  Dataset.ParamCheck := True;
  Dataset.SQL.Text := 'SELECT * FROM archive WHERE path=:PathAsString;';
  Dataset.Params.ParamByName('PathAsString').Value := ('path');
  Dataset.Open;

I'm getting an access violation in:

SqlitePassUtils.TSqlitePassAnsiStringList.Get(131184)
SqlitePassDbo.TSqlitePassRecordset.GetFieldAsAnsiString($91E0140)
SqlitePassDbo.BindUTF8AnsiStringFieldValueBufferToSqliteValueAsUTF16($F33290,$91E0140,$AE7098,1)
SqlitePassDbo.TSqlitePassParam.BindValue
SqlitePassDbo.TSqlitePassParams.BindValues
SqlitePassDbo.TSqlitePassDataset.InternalRefresh
SqlitePassDbo.TSqlitePassDataset.InternalOpen
:00657b3b TDataSet.DoInternalOpen + $1F
:006578f6 TDataSet.Open + $A

for the following reasons, FList is "nil" in TSqlitePassAnsiStringList.Get, and I can see that StrIndex is not valid (I'm getting a random value > 255)  in GetFieldAsAnsiString

If FList is "nil" it should mean that the parameter has not been stored correctly in the TSqlitePassAnsiStringList ?
Any help ?

sqliteDBO is really a good library to deal with sqlite DBs. Thanks for all involving to develop the library.

I've an error to use mastersource and masterfield properties. i want to use a master-detail relation with my database. Normally everythind works as i expect, but when i close my executable, it says the leak error/warning shown in the picture above:

Just when i close the program, error occurs. it's a leak error. i've inspected but i could not find.
Can you add this to buglist, admin?
Thanks.

     ftWideString:
       begin
       // TODO - Check WideString Size...// Length
       StrSize := (Length(StrValue)*2)+1;

with

     ftWideString:
       begin
       // TODO - Check WideString Size...// Length
       StrSize := (Length(StrValue)+1)*2;

because #0 is also stored on 2 bytes