Using a temporary table in the embedded SQL will result in the error message "Invalid object name 'xxx'" at the application runtime.
Or when creating a DataWindow dynamically using the SyntaxFromSQL function, the retrieve operation fails with the error message "Invalid object name 'xxx'" due to the use of a temporary table (for example, #product_list).
Cause & Solution: Refer to Enabling long connections.
