>
>Dmitry,
>when you want to use Parameter you have to put Variable or Field name as parameter:
>

>lcDate = DATE(2008,6,1)
>cSqlCommand = "select * from mytable where myDateTimeField >= ?m.lcDate"
>
>** or
>CREATE CURSOR crsTest (Fld1 D)
>INSERT INTO crsTest VALUES (DATE(2008,6,1))
>cSqlCommand = "select * from mytable where myDateTimeField >= ?crsTest.Fld1"
>

>
>When you want to send Date as value built-in the string, then better use so called ISO standard (yyyymmdd) and pass it as string. SQL Server will parse it w/o any troubles. Sending DateTime that way is setting independent.
>
>

>lcDate = DATE(2008,6,1)
>cSqlCommand = "select * from mytable where myDateTimeField >= '"+DTOS(lcDate)+"'"
>*** result should look like this:
>** select * from mytable where myDateTimeField >= '20080601'
>

Borislav,

Thank you for the explanation and for your code. Since I want to send Date as a value built-in string, the method of using DTOS( lcDate) works for me. It works when retrieving the data from SQL Server.

Unfortunately I have to maintain a different code when sending a SQL string to get data from VFP database. In my VFP database, I store dates in DATE type field whereas in SQL Server I use DATETIME type. Therefore sending cSqlCommand as following to VFP does not find the records:

cSqlCommand = "select * from mytable where myDateField >= '" + DTOS( lcDate) + "'"

Again, thank you.