migration script error
Posted by: scott mcdonald
Date: June 23, 2010 02:46PM

I have front end Access and MySQL back end that I use for my website. I use the access to process much of the data tables and then use the Migration tool kit to convert and upload the tables to my site. It works well, but I would like to do some automation by using a migration script that is executed by a button in my access program. I have already created the migration script based on what the toolkit generates. I have listed below the code I am using to launch the script, but it gives me an error "error executing script:...scripts\transfer.lua...8: attempt to index global 'migration' <a nil value>


Function OpenGRTShell() As Boolean

        Dim stAppName As String

        stAppName = "c:\Program Files\MySQL\MySQL Tools for 5.0\grtsh.exe \r c:\Inetpub\wwwroot\SSFHL2008\Scripts\scrStatTransfer.lua"
        Call Shell(stAppName)

    End Function



Edited 1 time(s). Last edit at 06/23/2010 03:00PM by scott mcdonald.

Options: ReplyQuote


Subject
Written By
Posted
migration script error
June 23, 2010 02:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.