Select command

[Scotte Meredith]

It's been awhile but as I recall you can use 

SELECT  * FROM F_PROP_DISPO ORDER BY <whatever> Desc Limit 1

To get the result I think you want. 

Sent from my iPhone

> On Dec 30, 2013, at 4:15 PM, <brian at revolution911.com> wrote:
> 
> I'm trying this combination against the native datafile.  Getting an error.
> Can you see what is wrong.  
> 
> SELECT TOP 1 * FROM F_PROP_DISPO WHERE F_PROP_DISPO.F_DISPO_BARCODE =
> '[AP46]' ORDER BY F_PROP_DISPO.F_DISPO_SEQ DESC
> 
> -----Original Message-----
> From: omnisdev-en-bounces at lists.omnis-dev.com
> [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of David Barnett
> Sent: Monday, December 30, 2013 2:45 PM
> To: OmnisDev List - English
> Subject: Re: Select command
> 
> Try:
> 
> Select top 1 * from myTable order by pkey desc
> 
> David
> 
> 
> David Barnett                 David at FairLibertysCall.com
> C: 516-398-8668               www.FairLibertysCall.com
> 
>> On Dec 30, 2013, at 5:27 PM, Jonathan Rumbold wrote:
>> 
>> Hi Brian,
>> 
>> Is SELECT LAST a regular sql command? I use something like this:
>> 
>> SELECT *
>> FROM mytable
>> WHERE pkey = (SELECT MAX(pkey) FROM mytable)
>> 
>> 
>> Jonathan Rumbold
>> 
>> Omni Potent Solutions P/L
>> 1537 Ghin Ghin Rd,
>> Highlands Victoria 3660, Australia.
>> 03 5796 9344
>> 0408 969399
>> 
>> 
>> 
>> 
>> -----Original Message-----
>> From: omnisdev-en-bounces at lists.omnis-dev.com
>> [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of 
>> brian at revolution911.com
>> Sent: Tuesday, 31 December 2013 9:10 AM
>> To: OmnisDev List - English
>> Subject: Select command
>> 
>> Can the SELECT LAST command be used with Studio?  I can't seem to find 
>> the right variation of it or it's use in the list or manuals.
>> 
>> 
>> 
>> Thanks,
>> 
>> Brian
>> 
>> 
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com