table display

[Bart Pietercil]

On 5-mei-07, at 20:12, Robert Mann wrote:

> Not sure what you are asking for?
> I am using a valentina 2 database
> The SQL works fine with the mysql database


I'm sure it is

>
> And your table schema is what exactly ?


In order to be able to verify the sql  you have written, I think it  
would be good if we understand the way you have structured the data  
in your table
such as:

Table A

field a  varchar(100)
field b integer
field c date

.....

This is what I mean by Table schema.
It is hard to validate the sql you have written against a table where  
we do not know the schema
Of course Ruslans advice to try your SQL on your database using  
VStudio might have already resolved the issue...

Bart

>
> On 5-mei-07, at 15:27, Robert Mann wrote:
>
>> Have a table with the following in it
>>
>> 2002 CR 85
>>
>> 2002 CR 125
>>
>> 2004 CR 125
>>
>> 2002 CR 250
>>
>>
>>
>>
>>
>> And I would like to be able to display it for highest to lowest
>>
>> Like this
>>
>> 2004 CR 125
>>
>> 2002 CR 250
>>
>> 2002 CR 125
>>
>> 2002 CR 85
>>
>>
>>
>> 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
>>
>>
>>
>>
>>
>>
>>
>> Thanks
>>
>> Rob