0 Replies Latest reply on Oct 25, 2012 6:57 AM by Hudi

    Import ODBC. WHERE is $variable

    Hudi

      Hey,

      New Day, New FM Question.

       

      I would like to do the following in the Import records script step, with an ODBC data source.

      Basically, I only want to import the records that match the variable I set.I very much hope this can be done.

       

       


      SELECT "Grades"

      FROM "Students"

      WHERE "grade"."Students" > N'$MinGrade'

       

       

      ($MinGrade=65)

       

      Is this at all possible.

       

      Thanks