I am palying with MS ACCESS database via ODBC from Visual FoxPro 9. I have
problem to get correct result from SQLEXEC - SELECT command
SQLEXEC(Handle,"SELECT * FROM Tab1 where date1>'1999-04-28 12:00:00'",
'Result1')

I would like to ask if there is a function or feature in VFP8 which will
properly retrieve an NVARCHAR(500) field from an SQL Server. Because what I
get is an unknown character filled in between each character values.
e.g. the word "QUERY" when retrieved it becomes "Q?U?E?R?Y". ...

Hi there, I am having this issue and it is driving me crazy and hope some
experts can give me a light.
In my form's DE I create few ODBC cursoradapters to retrieve date from
SQL2005. I have 2 SQL databases that having exactly same tables and

I am trying to translate this foxpro stuff into Tsql with no luck.
Apparently there is no calculate function  and arrays in tsql
I want to write this in TSQL
calculate max(times) to m.times for inlist(status,'K','T','M','N') and !