Jump to content
fmsavy

Import via ODBC

Recommended Posts

I use the import script step a lot and almost always from a outside ODBC data source.   The method I employ for importing is to set a variable with the sql text and then use that variable in the import script step as calculated text.  Doing it this way allows me to copy the text in a readable form from the variable when I get an "Extended Error (ODBC)" 1408  in debug and then paste it into MS SQL Studio and analyze the problem there.  

Every once in a while after making a change to sql text in Filemaker and getting a 1408 error in debug and then running the COPIED sql text in MS SQL Studio I get no errors in MS SQL Studio and the data is returned to me as expected.  I then would use the Filemaker LastExternalErrorDetail function to find out what the details of the error were because no error was reported in MS SQL Studio.  Now, sometimes I can simply delete the import script step and then add a new one and Filemaker will perform the import step without an error and sometimes NOT.  The other irony is that I can do an import from the File-Import-ODBC data source... in the same Filemaker solution and paste the COPIED text there and it works just fine but the text won't work in the script itself.  I'd also like to point out that this solution has been  running for years and just recently the target audience wanted an additional piece of data included in the results. 

What could possibly be going on here?   Did the script get corrupted?  When things like this happened I get so frustrated with Filemaker. 

Edited by fmsavy

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.