Problem with b12 and RB -- SOLVED.

[Ruslan Zasukhin]

On 1/14/09 7:11 PM, "Stan Busk" <maxprog at mac.com> wrote:

Hi Stan,

Okay, I think story is next:

* you did work with 3.5, then swithc to 4.x

* few months ago - may be June - we have realize that DATABASE FILE itself
must not keep on disk DateTime format after close and restore it back on
open().

    Why? Because if DB is under VSERVER then each connected user must be
able to establish OWN value of dateTime format.
    This is really cool, when the same VSERVER connects, US man, Russian man
and Japan man, and each can work with dates in own format.

* as result of this change

    you must have in your code AFTER db.open
     db.DateTimeFomrat = xxx



> I use that code for the database creation but not when opening an
> existing one.
> I have added the code there as well and at least it fixes the whole
> problem for me.
> I have sent an updated version to all the affected people to see it
> everything work as it should.
> 
> I will let you know if the problem is still there for any of them... I
> hope not.
> 
> Thanks!
> Stan
> 
>> On 1/14/09 4:34 PM, "Stan Busk" <maxprog at mac.com> wrote:
>> 
>>> It seems the second Query causes a Kernel error 0x65502. I ran it
>>> twice and I got the same error.
>>> 
>>> Following kernel_errors.xml file this error is
>>> ERR_DATE_VALUE_HAVE_WRONG_NUMBERS
>>> "Date value "%S" is invalid. Boundary check error."
>>> 
>>> I am not sure to understand what's happening here... do you?
>> 
>> Yes all clear
>> 
>> 1) Compare FIRST query on both computers, LAST coumn
>> 
>>    your DEV has            01/07/2009              DMY
>> 
>>    CLEAN                   07/01/2009              MDY
>> 
>> You see this
>> 
>> 
>> 2) and this is why Valentina give error on SECOND query in CLEAN
>> computer,
>> 
>>    because it have e.g.  < '12/31/2009'
>> 
>> So this date looks wrong on second computer.
>> And error says clean about this.
>> 
>> 
>> Now question is why you get this?
>> 
>> You sure you set db.DateTime format  AFTER db.open ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]