(no subject)

[Ruslan Zasukhin]

On 28/2/07 4:11 AM, "Robert Mann" <robmann at gp-racing.com> wrote:

Hi Robert,

> put "SELECT record_id, yrmodsize FROM stockvalving WHERE
> stockvalving.brand='" & gbrand & "' ORDER BY yrmodsize DESC" into theSQL
> 
> this sql statement works fine with mysql but with valentina it is ordered by
> record_id not yrmodsize any idea why this is?

What type have yrmodsize ?

Don't it have flag IndexByWords ?

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