Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL query
Message
 
 
À
15/02/2019 10:49:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01666437
Message ID:
01666453
Vues:
58
Muito obrigado, Antonio!
I confess that I gave a sloppy description of the problem.
Please ignore the second column (Bore).
I am looking for the largest difference of depth in two consecutive records. I recieve these data from a measuring device potentially in more than one csv files which I append into that table. Primarily the raw data are not even sorted by depth, so first of all I may have to "translate" these data into an ordered table with an additive column "Position" and then perform your suggestion with the modification of joining the table against itself on D1.position = D2.position +1. (see new attachment)
Would you agree with that?

Best regards
Eugen
New Year's pledge: Last year I learned so much from my errors that I decided to make some more.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform