mrgrinch121828

I am attempting to automate the migation of some table from my Access db to MYSQL db using a script created from the MySQL Migration Tools. Below is the function created to run in Shell and the error I get from the shell program when it attempts to execute the script. Any help would be great.

Thanks

Function OpenGRTShell() As Boolean

Dim stAppName As String

stAppName = "C:\Program Files\MySQL\MySQL Tools for 5.0\grtsh.exe C:\Inetpub\wwwroot\injuries.lua"
Call Shell(stAppName, 1)

End Function

Error says:
error executing script: c:\Inetpub\wwwroot\injuries.lua:8: attempt to index global 'Migration' <a nil value> / >

Jonny

This is not an error with your VB code. You should check on a MySQL forum for this one.

Qua

Looks like there a bug in your LUA code. Properly a variable that hasn't been initialized since you're trying to use a null value. If you're not aquinted with LUA then I suggest you kindly ask for a help on a LUA Forum