SQL problem

Charles Yeomans charles at declareSub.com
Tue Dec 19 12:18:37 CST 2006


On Dec 19, 2006, at 3:31 AM, Ruslan Zasukhin wrote:

> On 12/06/19 5:33 AM, "Kay C Lan" <lan.kc.macmail at gmail.com> wrote:
>
>>>> Can Valentina not handle date strings in SQL format?
>>>
>>> In fact it can, if you set the VDatabase.DateFormat and DateSep
>>> properties appropriately.
>>
>>
>> Thanks for finding that 'gotcha'. I'm about to head down that path  
>> so you've
>> probably just saved me an hour of head scratching.
>
> Actually it is obviouse
>
>     Vfield.SetString( 'date' )
>
> Consider all that Date/time properties of your Vdatabase.
>
> The same do of course SQL way,
> Otherwise it will be non-cosistent.


Maybe -- it seems like SQL standard date format should also be  
supported.

Charles Yeomans


More information about the Valentina mailing list