New V2a DataBase.zip

[Ruslan Zasukhin]

On 7/1/05 6:10 PM, "John W. Miescher" <miescher at bizdata.com> wrote:

> 
> Hi Ruslan,
> downloaded fc12 RB-WIN and I still get these mystery crashes, apparently
> the program stumbles over destroying a cursor at the end of a
> subroutine, because it does everything fine within that subroutine. The
> error occurrs always in
> 
>  msl_all-dll90_x86.dll
> 
> could yo please send me the latest version of that dll to try again.
> Thanks in advance,

This is Metrowerks dll, I do not think that problem here.
See below.
   
> Dear Ruslan,
> attached find our DB that brings 'ORDER BY' to fall.

Hi John,

1) So am I right that I need do

select *,RecID 
from hist 
where (mdate >= '2005-06-23') and (mdate <= '2005-07-03')
order by mdate 


-------------------
I have try it on my MAC -- no problems.
Although I was need change date values

    '2005-06-23'  to   '06-23-2005'

Are you sure that you need use '2005-06-23' ?
I see that your database have db.DateTimeFormat = 1, this is
        kDMY    = 1,


Aha!!!! 

I see that mDate this is String[10].
Why you use strings but not Vdate type ?


2) do you work only on windows?
    may be problem happens on windows?
    we will test today.


-- 
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]