Cursoradapter...

WITH oCA

  .ADOCODEPAGE = 850
  .ADDPROPERTY( "oconnection" , CREATEOBJECT( "adodb.connection" ) )
  .oconnection.ConnectionString = oPrivatecParamCR.cconnectstring
  .oconnection.OPEN()
  .Setconnection ( .oconnection )
  *-- Foxpro n'accepte pas de chiffre ds un alias !
  .ALIAS 	= "Alias" + m.cFich && "boaccoun"
  .TABLES	= THIS.cDossierJn + UPPER( m.cFich ) && "boaccoun"
  .DATASOURCE.cursorlocation = 3
  .DATASOURCE.locktype= 3
  .BUFFERMODEOVERRIDE = 5

>How is connecstring?
>
>MartinaJ
>
>>Hi martina,
>>
>>when i use your code
>>

>>TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
>>			SELECT HDBK, Hid , HDOCNO, HAMOUNT,  HDOCDATE ,CREATEDBY,
>>			Createdon , hremint   FROM <<.TABLES>>
>>			WHERE hdocdate > {d '2010-01-31'}
>>      ENDTEXT
>>

>>I have the error in attachment
>>
>>>Hi Bernhart,
>>>
>>>You try use escape sequence...
>>>

>>>...where hdocdate > {d '2010-01-31'}
>>>...where hdocdatetime > {ts '2010-01-31 12:13:14'}
>>>

>>>
>>>MartinaJ
>>>
>>>>Hi all,
>>>>
>>>>please see attachment.
>>>>
>>>>

>>>>...where hdocdate > {^2010-01-31}...
>>>>

>>>>
>>>>Fails..
>>>>
>>>>what 's the good command ?
>>>>
>>>>Thank in advance
>>>>
>>>>
>>>>bernhart