Select command

Jonathan Rumbold j.rumbold at bigpond.com
Mon Dec 30 17:27:40 EST 2013


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




More information about the omnisdev-en mailing list