Select command

brian at revolution911.com brian at revolution911.com
Mon Dec 30 18:15:58 EST 2013


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




More information about the omnisdev-en mailing list