Why wont my Import script work?! 1

[woodyinoz]

Using the text import expert I have saved the script that imports data from a text file into a specified table. This works fine when run using the expert but when I try and import using the same script nothing is imported into the table and a single blank column is all that appears.

Has anyone got any ideas as this is driving me mad!!

Thanks

Woody.

 

[Langley]

Sounds like an alias/working directory issue. Examine the script and see if there is a path or alias. If not, make sure you are in the proper working directory.

Mac

 

[footpad]

Woody,

Not sure how you've laid out your script, but it does sound like something isn't working properly. You might be getting a warning error that isn't being displayed.

Try running your script and then moving your mouse pointer over a blank area of the status line after you run your script. If it turns into a pointer with a question mark, it means that an error occurred. Clicking the status bar at this point will display that error.

You might also consider making two changes to your script:

1. Add the following line before your first line of executing code:

errorTrapOnWarnings( True )

2. Save your script with Compile with Debug checked. (This option appears under the Program menu in most recent versions of Paradox.)

These changes will do two things:

1) Treat warning errors as critical ones, which in turn presents them in a dialog box.

2) Provide additional debugging information about the error, e.g. the line number where the error occurred.

One you have that information, you should be able to move forward.

Hope this helps...

-- Lance