i read a previous one incorrectly. We are using ODBC to get to the Sequel Server.

setting a variable is easy. When we had access links, I use to write the SQL and "start" was a variable that i could pass to the SQL,

in this case "Scedule.allappointments gstartdate" was used in code


scedule = name of the Data Environement Link
Allappointments = name of the SQL that was written in the Data Environment
gstartdate = the variable that has the date in it that the query needs



now that we have moved to ODBC Sequel Server based DB's instead of Access, the SQL queries no longer work the same. the first query had

SELECT Schedule.ASC_ApptDate, Schedule.ASC_ACL_ID,
Schedule.ASC_AAU_ID, Schedule.ASC_QtrID,
Audiologist.AAU_Initials, Schedule.ASC_Status,
Audiologist.AAU_FirstName, Audiologist.AAU_LastName
FROM Audiologist INNER JOIN
Schedule ON
Audiologist.AAU_ID = Schedule.ASC_AAU_ID
WHERE (Schedule.ASC_ApptDate BETWEEN 'start' AND
DATEADD(d, 6, 'start')) AND (Schedule.ASC_ACL_ID = ' ')
AND (Schedule.ASC_Status = 'C')

the "dbo." was added after I tried to move to SQL server. It was added automatiacally by the Data Environment.


Is there any way to change keep the SQL in the Data Enviroment and not move to code.