Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting the last record of a table
Message
De
08/09/2003 17:13:17
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00827253
Message ID:
00827288
Vues:
15
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform