1 Reply by zabukowski

(6 replies, posted in General)

Thanks !!

but you can always override the default setting :
Fill in the database property
set connected to false
set MyDb.DatabaseType := dbtSqliteExpert
set connected to true

I did that without success. Nevermind, I guess i did something wrong ... I'll leave extension as it is for now, no big deal.

I've discovered another thing, which I can't resolve.

I use 'locate' function to find a record with exact key value. But, if key value starts with a number, record is not found (key type is char(32)), if it starts with a letter it is normally found.

Is there something i am doing wrong ? I saw from sources that locate is using filters. Is there a function to find a record using index like FindKey in TTable ?

edit:
I will send you my database in the evening !

Thanks again
Zabukowski

Go to forum: General

2 Reply by zabukowski

(6 replies, posted in General)

And another few issues, sorry sad

1. Trying to empty table ...

I found that emptytable function finds dataset type dtSQLSelect and not dtTable as expected. So, nothing is really deleted.
How do I create dtTable type ?

2. 'Dataset name' property is not reloaded with delphi project !? Is this ok ?

edit:
There is something strange going on.

I've removed following 2 lines

   if (DatasetName <> '') and not FInInternalSetDatasetType
      then DatasetName := '';

from procedure

Procedure TSqlitePassDataset.NotifySQLChanged(Value: TSqlitePassSQLChange);

Delete is now working. But still, if I reload project, dataset name is empty again. I have to choose table again. If I don't, delete is not successful.

edit:

If I set datasetname realtime in code, everything works (i put everything back, as it was). Looks like there is a problem with a datasetname property in design-mode only.

Thanks
Zabukowski

Go to forum: General

3 Reply by zabukowski

(6 replies, posted in General)

Thanks for your quick answers.

I've changed code as you suggested and it works smile

btw. how can I determine which database error occured (errorcode ?) within standard exception handler ?

Regarding mass inserts using transaction start/commit ...

WOW, that's what I call speed big_smile Unbelievable ! I guess this nontransactional mode inserting is REALLY slow !


Another one:

I've created database with SQLite Expert (.db3). Then I changed extension to .db. Suddenly some database fields were missing when using database components within Delphi. Dataset component is showing only 2 of 6 fields. If I change extension back to .db3, everything is ok again. Is this normal ?

Thanks again !

Zabukowski

Go to forum: General

4 Topic by zabukowski

(6 replies, posted in General)

Hi !

First I would thank you for your excellent components - great work !  smile

I am using SQlite (pass) for the first time - real rookie wink

1. how do I disable error log window ? I would like to catch database exceptions manually. What is the easiest way to do it ?
2. I am doing massive inserts. I've tried to post (commit) after each insert, then i've tried to post at the end of inserts, but there is no noticeable speed difference. Any thoughts ? (btw. I am not using SQL statements, but standard methods - insert, post, cancel etc.)

Thanks in advance. I'll probably come back here with new questions -  hope I won't bother you too much.

Zabukowski

p.s. using Delphi 2009

Go to forum: General