Sage 100

I have been attempting to simply change the data type of a column for a query I am running through the ProvideX ODBC but I keep getting errors, and I am wondering if this scalar function is not available here. Simply, I am trying to query the IM_PeriodPostingHistory…

I am writing out a program and I keep getting this error on my sql statement Error: Expected lexical element not found: <identifier> (State:37000, Native Code: 3F7) Here below is my sql statement. I am nesting a select statement. SELECT ItemCode…