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: sqlite-users@sqlite.org
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]
-----------------------------------------------------------------------------

Reply via email to