SHeidenreich
Programmer
Hi.
We´re migrating our application from the FoxPro-Database to Microsoft SQL.
To translate the SQL-Statements with Cursor-DBF-Joins we want to use the temporary tables of T-SQL:
nresult=SQLEXEC(nhandle,"select * into #curtemp from adresses")
This is working fine. We can access #curtemp as a table from this handle.
But if we have Parameters, this isn´t working, the temporary Table is not created, also there is no Error
nresult=SQLEXEC(nhandle,"select * into #curtemp from adresses where adr_nid = ?nid")
Result ist 1, but the table #curtemp can not be accessed.
Also working (and atm. our alternative)
nresult=SQLEXEC(nhandle,"select * into #curtemp from adresses where adr_nid = "+transform(nid))
but the use of parameters is normal the better choice.
What is the problem of parameter usage ?
We´re migrating our application from the FoxPro-Database to Microsoft SQL.
To translate the SQL-Statements with Cursor-DBF-Joins we want to use the temporary tables of T-SQL:
nresult=SQLEXEC(nhandle,"select * into #curtemp from adresses")
This is working fine. We can access #curtemp as a table from this handle.
But if we have Parameters, this isn´t working, the temporary Table is not created, also there is no Error
nresult=SQLEXEC(nhandle,"select * into #curtemp from adresses where adr_nid = ?nid")
Result ist 1, but the table #curtemp can not be accessed.
Also working (and atm. our alternative)
nresult=SQLEXEC(nhandle,"select * into #curtemp from adresses where adr_nid = "+transform(nid))
but the use of parameters is normal the better choice.
What is the problem of parameter usage ?