pcsoft.us.windevCopyright 2026, PC SOFT26 Nov 2017 14:43:00 Z25 Nov 2017 16:37:00 ZHi, recently I get work to create small program using windev to populate data into excel from another excel files and data from mssql server. I encounter problem when I run query . no error when connecting using sqlconnect() and no error when executing using sqlexec() . but return empty . The query is quite long and need 3 temp tables. the last part I return the data from temp3 table. after google , I realize problem oledb with temp table in which solution is using storedproc how do people here resolve this by not using storedproc while still using oledb and not native access ?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63465-wd20-mssql-oledb-temp-table/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63465-wd20-mssql-oledb-temp-table-63473/read.awp26 Nov 2017 14:43:00 Znever mind . add SET NOCOUNT ONhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63465-wd20-mssql-oledb-temp-table-63473/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63465-wd20-mssql-oledb-temp-table-63473/read.awp[WD20] MSSQL oledb temp table