General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I sure can't duplicate the problem on some test data regardless of the settings of ANSI and EXACT.
How big is pricelist.dbf. I want to run the SQL statement on my set up to see if I get the same results. If a zipped version of the DBF (all I need is the 4 listed fields) is less than 500k just send it to me as a e-mail attachment. My e-mail address is doresvei@halcyon.com.
If you find a solution in the interim, please post it so we all know what to look out for.
>I tried your suggestion to no avail. My SQL statement now looks like this:
>
>SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
> FROM price!pricelist;
> GROUP BY pricelist.ITEM;
> ORDER BY pricelist.DATE DESC;
> INTO TABLE temp.DBF
>
>Any other suggestions???
>
>
>>Strange behavior.
>>May I suggest:
>>1. Swap the order of the GROUP BY and ORDER BY clauses.
>>2. Refer to the GB and OB fields by number as in
>>
>>SELECT .... GROUP BY 1 ORDER BY 4 .....
>>
>>Good Luck.
>>
>>>I have the following SQL statement:
>>>
>>>SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
>>> FROM price!pricelist;
>>> order by pricelist.date desc;
>>> GROUP BY pricelist.ITEM;
>>> INTO TABLE temp.DBF
>>>
>>>The results do not show an item number:
>>>
>>>T97000-503
>>>
>>>but it will show an item number:
>>>
>>>T97000-503R
>>>
>>>What may I be doing wrong?
>>>
>>>Jeff Pearce
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only