Hi Steve,
I can't think of any way to do this with SQP Pass Through (SQLEXEC) (short of doing a second, local translation query on the SQLEXEC result set), but you can set the properties of fields in a remote view so the translation is done.
Cheers,
Andrew
>Does anyone know how to just return the date and not the time from ms-sql server when you use sqlexec ?
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.