table display

[Robert Mann]

Thanks got it
Rob

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Sunday, May 06, 2007 1:46 AM
To: valentina at lists.macserve.net
Subject: Re: table display

On 5/5/07 4:27 PM, "Robert Mann" <robmann at gp-racing.com> wrote:

Hi Robert,

> But using the following SQL
> 
> put "SELECT Year_Model FROM yearmodelsize WHERE yearmodelsize.BID='" &
> gbrandid & "' and yearmodelsize.stock_specs_complete='no' ORDER BY
> Year_Model DESC" into theSQL
> 
>  
> 
> does not do this? What do I have to change with the table settings?
> 
> It displays like this
> 
> 2002 CR 85
> 2002 CR 125
> 2004 CR 125
> 2002 CR 250

Have you download Valentina Studio?
If not - download it.

Then open your db in Valentina Studio,
And in SqlEditor try execute above query.

Also try REINDEX database. You can do this in Valentina Studio also,
Using e.g. Contextual menu on db object in second column.


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


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina