Jump to content

ODBC import map problems


blitskreg
 Share

This topic is 5732 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I'm trying to setup a FileMaker script to import records from a MSSQL database via a calculated SQL query in an Import Records script step. The problem is in the "Import Field Mapping" screen, it does not show field names or data from the ODBC source. If I run the scrip with the default map it imports the fields with no errors returned.

The odd part is that I thought it was working properly just yesterday when I was doing some tests.

Here is my calculated query:

"SELECT RecordId, TimeIn, TimeOut

FROM EmployeeHours

WHERE UTCDateModified >= '" & Punches::LastImport & "'"

Link to comment
Share on other sites

This topic is 5732 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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