There is no actual VBS file. I run it like this from VBA:
Sub UpdateReadSQLite2(bShowSQL As Boolean)
Dim oShell
UpdateReadTextFile bShowSQL, True
Application.StatusBar = _
"transferring the data from ReadCodeNoQuotes.txt to the SQLite DB"
Set oShell = CreateObject("WSCript.shell")
oShell.Run "cmd /C C:\SQLite\ReadCode.bat", 0
Set oShell = Nothing
Application.StatusBar = False
End Sub
Still, these are minor details and I will figure that out.
RBS
-----Original Message-----
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 15 November 2006 20:30
To: [email protected]
Subject: Re: [sqlite] Importing text file via .bat file
On Wed, 15 Nov 2006 19:46:32 -0000, you wrote:
>Kees,
>
>Just one other thing needed.
>In the .sql file is there a way to notify VB that the text import is
>finished? I run the .bat file now from VBS, so it won't be visible.
>I couldn't see anything suitable in the dot commands to tell VB.
>
>RBS
It is done when the .bat returns to VBS, I guess.
You could try to execute like this (just guessing, i never use
VBS):
start /w ReadCode.bat
Or add this to the sql script:
**** at the top:
if exist signal.txt del signal.txt
**** at the bottom:
.output signal.txt
select SUBJECT_TYPE from ReadCode limit 1;
and detect the presence of the file signal.txt in your VBS
script. Or do everything in your .bat (or better, .cmd).
--
( Kees Nuyt
)
c[_]
----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
