Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting the last record of a table
Message
From
08/09/2003 17:13:17
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00827253
Message ID:
00827288
Views:
14
Hi Sergey,

I did not resist to show this likeable solution to you:
SET DELETED ON
CREATE CURSOR mcur ( F1 C(240) NOT null)
INSERT INTO mcur VALUES ('ZIPPO1')
INSERT INTO mcur VALUES ('ZIPPO2')
INSERT INTO mcur VALUES ('ZIPPO3')
INSERT INTO mcur VALUES ('ZIPPO4')
DELETE
SELECT TOP 1 * FROM mcur ORDER BY 0 DESC
This is usefull also on SQL Server for get last clustered index element
without known who is clustered index fields.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform