|
| [WD20] MSSQL oledb temp table |
| Iniciado por guest, 25,nov. 2017 16:37 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 25,noviembre 2017 - 16:37 |
Hi,
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 ? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 26,noviembre 2017 - 14:43 |
never mind .
add SET NOCOUNT ON |
| |
| |
| | | |
|
| | | | |
| | |
|