Passing MSSQL TAble Column as VFP UDF Parameter in SQLEXEC()

[ariftheruvath]

I'm trying to do this
sqlexec(handle,"select vfp_UDF(MSSQL_table_column) from mssql_table")

how to do this pls..

 

[Olaf Doschke]

You can't. Check out, if T-SQL offers something you can use via CONVERT or CAST, for example.

Bye, Olaf.

 

[Olaf Doschke]

another simple two step solution:

sqlexec(handle,"select MSSQL_table_column from mssql_table","curVFP")
select vfp_UDF(MSSQL_table_column) From curVFP into curResult

If the problem is retrieving the sql server type field 1:1 you're back to CONVERT and CAST.

Bye, Olaf.

 

[ariftheruvath]

thanks olaf