Topic: TSQLiteDatabase Options

Hi,

An example. I place a TSQLiteDatabase component on a form. Looking at the Options property I noticed that these are strange settings meaning not the default of SQLite. For example Synchronous is set Off but the default of SQLIte is FULL.
Also when I use CreateDatabase then the settings of this new created database are different. The options are not all used when creating the database. Is this correct?

Regards,
Pascal

Re: TSQLiteDatabase Options

Hi Pascal,

The database.options are correctly only when the database is connected.

Obviously, I didn't finish the job for GetFSynchronous and GetFTemporaryStorage.

function TSqlitePassDatabaseOptions.GetFSynchronous: TSqlitePassSynchronous;
begin
  Result := FSynchronous;//TSqlitePassSynchronous(FDatabase.GetIntPragma('synchronous'));
end;

function TSqlitePassDatabaseOptions.GetFTemporaryStorage: TSqlitePassTempStore;
begin
  Result := FTemporaryStorage;//TSqlitePassTempStore(FDatabase.GetIntPragma('temp_store'));
end;

One more thing to do... smile

Regards

Re: TSQLiteDatabase Options

Some extra work :(

- No GetSetFCaseSensitiveLike Function, Option is always True in db component properties
- SQLiteLibrary is not saved in db component properties
- When I create a database (using your db component) then the case_sensitive_like option is True when I look in the options of the connected database component. This should be False (False is the default in SQLite).

Regards,
Pascal

Last edited by pcoenen (2010-04-01 19:59:17)

Re: TSQLiteDatabase Options

hello there axelent,

I'm having the same problem here...
If i found out something I'll let you know...

If anyone can help us I'd be gratefull...


Spider Injector

Last edited by johansmith (2011-05-24 05:47:07)

Re: TSQLiteDatabase Options

you will solve it:D