prompt in bat

[joesruk]

hi there,

this is what I'm trying to make into a bat, it's to run a txt file against an sql database, the problem is, it gets as far as the third line, then brings up a prompt >  where the line .read UpdateBS.sql is the next step .  How do I get this to work please?


cd\
cd "C:\Program Files\K\BS"
SQLIte3 BS.sqb
.read UpdateBS.sql
.quit
pause


mtia
Mark

[gpl]

I have had a VERY quick look at the documentation - I think you might get somewhere with this:

create a text file containing your interactive commands:

.read UpdateBS.sql
.quit
Call it sqlcmds.txt

now on the commandline, run this

Code: [Select]

SQLIte3 BS.sqb < sqlcmds.txt
What this does is tell SQLIte3 to run with the command line param that you had (BS.sqb) - but when it prompts for interaction, ignore the keyboard and take the input from the sqlcmds.txt file, line by line as if they had been typed in.

Check out 'redirection of input' here on this site and others to understand

Good luck
Graham

[joesruk]

thanks very much Graham, that's done it

Mark

[joesruk]

H,

one more question please,  this was what I've been using:

cd\
cd "C:\Program Files\KA\BS"
SQLite3 BS.sqb <Readcmd.txt

but some users of my programme have their installation on other drives, not the same drive as their DOS cmd default and have been having trouble.   It has been suggested to me that the first line should in fact be that drive for example if it was on the E:drive

E:
cd\
cd "E:\Program Files\KA\BS"
SQLite3 BS.sqb <Readcmd.txt

is this correct, will it make a difference?

mtia
Joe

[joesruk]

can someone give me an answer to this please?

mtia
Joe

[maymon123]

I would say yes to your question, joesruk.

[Salmon Trout]

You can specify a drive and folder this way

E:
cd\
cd "Program Files\KA\BS"

or this way using cd with the /d switch

cd /d "E:\Program Files\KA\BS"

[joesruk]

thanks guys