Shell Command in VB6

[Andreas Huber]

Hallo together !

i´m a new mySQL User

I want to do some Shell Commands to manage the Database
My Problem is :

When i open a new MS-DOS Form and put following Command Line into it
mysql -h 127.0.0.1 -D lp1analog -e "SHOW TABLES" > C:\TEST.TXT
it work perfectly


When i put this command line into VB6 it doesn´t works.

shell "mysql -h 127.0.0.1 -D lp1analog -e ""SHOW TABLES "" >C:\TEST.TXT"
I can´t see any error line in the Promt-Form because it closes so fast

Can Somebody help me please ?

Greeting Andreas Huber