ZSchedFix Beta Support and Suggestions

[-Oz-]

some of that is your code. I used your thing you posted on how to access sqlite databases from vb6.

The thing was that the windows dir wasn't working so I found a tutorial to help with it.

I also did a lot of modifications to how the query is run to load it into two arrays, one with the column headers and a two dimensional one.

So yea, yours didn't work but that one should

[martint123]

Just to let you know - my 'windows' is in the normal place i.e. c:\windows
It's just my default 'program files' that resides elsewhere - E:\ in my case for historical and backup reasons.

Martin

[martint123]

Just so you all know, that what happens when ZSchedFix starts is it tests for existence of sqlite3vb.dll in the %SystemDir%. (eg c:\windows\system32) If not, it sends a copy of sqlite3vb.dll to that location...

That copy is getting done before the windows error box pops up.

BUT the files is appearing in \windows rather than windows\system32

Martin

[martint123]

edit: putting a second copy in \windows\system32 makes no difference.

[zehd]

some of that is your code. I used your thing you posted on how to access sqlite databases from vb6.

The thing was that the windows dir wasn't working so I found a tutorial to help with it.

I also did a lot of modifications to how the query is run to load it into two arrays, one with the column headers and a two dimensional one.

So yea, yours didn't work but that one should

You know I was looking at loading my data into an array, but I really really like seeing what I'm looking at. If I had to visualize my recordsets, I'd still be nowhere fast.

I forgot that I posted that snippet. I remember having the same issue, fixing it. (turns out I forgot the MAX_PATH const) forgot to post the fix...

Anyway, I still haven't had a chance to look at my code, But I'm SURE that that fix is there... Oh well, we'll see...

[zehd]

That copy is getting done before the windows error box pops up.

BUT the files is appearing in \windows rather than windows\system32

Martin

Right I was wrong to say Window/System32. And now remember that I never had that reference in my code.

If the copy worked, I'll probably have to add some doevents, to be sure the file transfer is finished. hmmm, didn't have to do this with ZRename...

Oh well

[martint123]

hmmm, didn't have to do this with ZRename...

Oh well

Just downloaded and fired that one up and starts up fine. No time at the mo to check what it does though, maybe tomorrow.

g'nite

[zehd]

Here's patch. I'll just release the attachment here. Try it. Doesn't work, Give me the log...

v 1.0.0.8

[-Oz-]

Failed, here's the log.

5/24/2007 8:08:03 PM : ********************
5/24/2007 8:08:03 PM : Testing for SQLite3VB.dll
5/24/2007 8:08:03 PM : ZSchedFix v 1.0.8 using SQLite3VB.dll: 3.3.13
5/24/2007 8:08:03 PM : Finished testing for SQLite3VB.dll

Win XP SP2, i obviously have the dll cuz i use it in my problems. I have all the VB stuff because I write VB.

[zehd]

Oz, It looks like the dll is loading. That's where the version number came from...

Here's another patch with more logging. Just opening and closeing should look like this...

When asked "Do you want to fill tables?" and answer NO

Code:

24/05/2007 9:39:50 PM : ********************
24/05/2007 9:39:50 PM : Testing for SQLite3VB.dll
24/05/2007 9:39:50 PM : ZSchedFix v 1.0.9 using SQLite3VB.dll: 3.3.13
24/05/2007 9:39:50 PM : Testing for sqlite3.exe
24/05/2007 9:39:50 PM : Testing for gbpvr.db
24/05/2007 9:39:50 PM : Setting up ListView controls
24/05/2007 9:39:50 PM : About to fill tables...
24/05/2007 9:39:53 PM : Skip Filling the tables...
24/05/2007 9:39:53 PM : About to show forms...
24/05/2007 9:39:53 PM : About to show forms...2

24/05/2007 9:39:53 PM : *****************
24/05/2007 9:39:53 PM : Starting ZSchedFix...

When asked "Do you want to fill tables?" and answer YES

Code:

24/05/2007 9:40:09 PM : ********************
24/05/2007 9:40:09 PM : Testing for SQLite3VB.dll
24/05/2007 9:40:09 PM : ZSchedFix v 1.0.9 using SQLite3VB.dll: 3.3.13
24/05/2007 9:40:09 PM : Testing for sqlite3.exe
24/05/2007 9:40:09 PM : Testing for gbpvr.db
24/05/2007 9:40:09 PM : Setting up ListView controls
24/05/2007 9:40:09 PM : About to fill tables...
24/05/2007 9:40:10 PM : About to show forms...
24/05/2007 9:40:10 PM : About to show forms...2

24/05/2007 9:40:10 PM : *****************
24/05/2007 9:40:10 PM : Starting ZSchedFix...
24/05/2007 9:40:12 PM : Exiting ZSchedFix...

(The ref to gbpvr.db and not db3 is a logging typo only...)

When posting logs paste everything to where it stops...