Select command

[brian at revolution911.com]

I was afraid they didn't have that built into native datafile.

Thanks,
Brian

-----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 3:42 PM
To: OmnisDev List - English
Subject: Re: Select command

Sorry, that would never work in OmnisSQL against the native datafile. That's
'real' sql.

David

David Barnett                 David at FairLibertysCall.com
C: 516-398-8668               www.FairLibertysCall.com

On Dec 30, 2013, at 6: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

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com