Hi group,
I've got a program that creates a bat and a sql file and then executes the
bat file
the bat file is called temp.bat
and looks like this:
osql -U"user" -P"password" -S"pcname\instance" -i temp.sql -o temp.txt
the temp.sql file that's called as input in the bat file looks like this:
use pfd
drop table ea005temp
select * into ea005temp from ea005
delete from ea005temp
now the problem is when I call the bat file from my program with
shell(filename) or process.start(filename) or process.start("osql",
"-U"user" -P"password" -S"pcname\instance" -i temp.sql -o temp.txt") I see
the dos window open but the bat file doesn't get executed, but when I double
click the bat file it runs just fine.
Anyone knows what could be the problem?
Greetz Peter