>>
>>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.
Dmitry,
Whether the backend is VFP, SQL server, Oracle ... using parameters work.
cSqlCommand = "select * from mytable where myDateField >= ?m.ldDate"
Cetin