Search:

Redacted (before posting).

I'll follow my rule of not answering this kind of messages.
I can say that now, at least once, I did it.

I understand your idea, but I think what you are not realizing is that every time that you call Command1_Click, it is doing exactly everything that is inside Command1_Click, including calling...

I think I agree with everything.

☮︎

I've read your post again, and decided to give it some of my valuable time.

PS: I didn't review, some phrases may not be perfect (maybe later if I feel like it).

Some parts changed order:


...

He sees issues, but doesn't connect them.

I see jbro that you like troubles.
I wish you find all the troubles that you want.

If Not ListItemExistsByText(ListView1, PacketArray2x(1)) Then
With ListView1.ListItems.Add(, , PacketArray2x(1))
.ListSubItems.Add , , PacketArray2x(2)
.ListSubItems.Add , ,...

Advices are welcomed in general, and many times they have been helpful (other times), but not when the issue was clearly explained many times that it had nothing to do with DoEvents, and he still...

I'm thinking in writing an article about DoEvents like I already did about Twips/Pixels/DPI awareness, another difficult subject that even some most skilled programmers do not get it right, because I...

Thanks for your idea.
I was going to leave it as it is, because what user would be opening that file anyway? But you are correctly pointing that may be running a background backup utility or...

You must have read somewhere that DoEvents was "evil" and "should never be used".
Probably in many places by many different people.

But it is myth.

No. You need to actually modify something.

Once more: there is no problem with DoEvents.

Yes.



185496

At:


Set gDataBase = DBEngine.OpenDatabase(DatabasePath)

OK, I was able to recreate the situation of the error:

185489

I did what I already described in some other message:

I started to compress the database file to a rar file using Winrar, and...

Nice try, keep trying.

Do not waste time. I have this program very advanced already.

Who or what would be "they" in your sentence?

You solved the thread many times already, you seems to be a master thread-solver :cool:

You could? LOL!

Yes, I also could use some threading class, that would add a lot of complexity and would be a lot harder to debug (and have many, many crashes) for no reason (having exactly the...

OK, I won't use any OCX anymore, because MS and other authors don't know what I'm doing.
Good luck, specially with your business.

And your suggestion of using timers instead...
Using timers would produce exactly the same situations.

I really think that you don't understand DoEvents.

The only difference using timers...

The problem was that generic error "Too busy" instead of saying something more specific.
I now handled it from my side:


Public Sub CloseDatabase()
If Not mDataBase Is Nothing Then
...

I see you are too narrow-minded about how program's client code could work.
And I mean, right or wrong. A component maker should think in all situations, and not to expect what he thinks is the...

There is no reason for that to be a problem (if there are not windows that can receive messages involved). I don't know what The Trick would say, but if he says that there is a problem, I'm quite...

The main problem seems to be the locking mode of SQLite, but I'll have to live with that.
I think it might be possible in a component to handle transactions automatically, but not easy to do (and...

PS: it seems that the latter cause if the "too busy" error was caused by closing a connection without ending the current transaction.
Now I'm testing again with that fix and seems not to cause the...

That's already done here (or something like that).

You are very funny.
Your misunderstanding of programming with DoEvents seems to be uttermost (I would never guessed).



Yes, I guess that could help in some cases, but it should not be...

I don't think that the database driver (the C code) is creating any dummy window to process messages, and I'm not messing up anything in my own code, maybe your component creates a window and does...

I also noticed that at a time, when the database file was opened by another program,


Set gDataBase = New_c.Connection(DatabasePath)

opened the database anyway. But much further in the code,...

I can't work like that. I need the component to be more intelligent in handling error situations transparently.

Also, I see some misconceptions.
There is no cConnection.Close. This relies...

Unfortunately, I definitively came to the conclusion that there must be a bug in RC6. There is no database (connection) open, and I open a new cConnection and can't do anything that involves an...

I tested with the version that is found at the link I posted (I just downloaded it for the test).
You sent me that file before, probably another compilation? But now I used that one that is...

Do you realize that people trying to help here want to have the test project in the condition that produces the error already?

Perhaps you can provide the test project with the database with the...

My test where it worked on pair of RC6 was wqweto's compilation.
I also noticed that there is also too much overhead when using the "normal" fields collection, but it worked OK when accessing the...

Are you joking?

If the same file is added twice, I would compare the date of the new with the one already in the zip, if it is newer I would replace the file, but if the date is the same or before, I would not add...

' DAO
Dim f2 As Field
Dim f3 As Field
Dim f4 As Field

iT1 = Timer
Set iRecDAO = iDbDAO.OpenRecordset("Files")
iRecDAO.Index = "Path_Hash"
Set f2 =...

So, there is a huge performance penalty for accessing through the normal interface.

Times now:


RC6-Chunks: 0,85
DAO: 1,3
VBSQLite Cursor: 0,41
RC6 Cursor: 0,38

The problem is there, nobody knows how you are zipping the files.
If you are using a program, usually it will ask for overwrite or will overwrite the file without asking when the same file already...