Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Cetin,
VFP is more flexible.
But, also SELECT GROUP BY clause on VFP7 has more flexible of the new implementation, more like to MSQL implementation, on VFP8;
new implementation cut not deterministic result.
But i think:
SELECT time to complete execution is not deterministic, and change on:
- various hardware;
- various SO;
- various database engine release;
- various dimension of database;
- various index declared;
- various history of database uses (on statistical parser optimization like MSQL ).
then if DATATIME() is eval dinamically, the result is not deterministic.
In fact, on MSQL also UDF can't uses GETDATE on internal code.
But all data read from tables used on SELECT are fixed ( database engine lock every row used ).
Then, exist a SELECT where dinamically is usefull ?
The only one i can think is monitor SELECT internal execution time.
You can found one ?
Fix time function on SELECT, is one SQL-92 definition rule ?
Fabio
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement