Mystery Crash II

[peter salomon]

John W. Miescher wrote:

> Dear Ruslan,
>  
> when I enter
> select *,RecID from hist where (mdate >= '2005-06-23') and (mdate <= 
> '2005-07-03')
> in Valentina Studio it works fine,
>  
> but when I do
> select *,RecID from hist where (mdate >= '2005-06-23') and (mdate <= 
> '2005-07-03') order by mdate

how many fields are included by "*"?

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

had similar problem once...
i needed to call the fieldname which sorts records

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

would mdate called by "*" be ignored when it is called by its fieldname?

peter

>  
> then even Valentina Studio chokes and just closes down withouth 
> warning. WHY?
>  
> rgs, john m.
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Valentina-beta mailing list
>Valentina-beta at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina-beta
>  
>