This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I'm running the following query through LINQpad and see that the table name File is not properly escaped causing a syntax error at sql level since file is a keyword. from t in TaskItems join tr in TaskRuns on t.Id equals tr.TaskItemId join q in QueueItems on tr.Id equals q.TaskRunId join f in Files on t.Id equals f.TaskItemId orderby q.Priority descending orderby q.ScheduledRunTime descending select q |
|
|
Set LightSpeedContext.QuoteIdentifiers to true in code or configuration. |
|