Select command

brian at revolution911.com brian at revolution911.com
Mon Dec 30 17:31:23 EST 2013


Hi Johnathan,

I thought I saw it inside a look up for regular SQL commands.  I checked it
again after your email and it is a MySQL and Oracle command.  I'll try your
Statement though.  

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 Jonathan
Rumbold
Sent: Monday, December 30, 2013 2:28 PM
To: 'OmnisDev List - English'
Subject: RE: Select command

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




More information about the omnisdev-en mailing list