Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUGG: Correlated UPDATE and DELETE - SQL Commands
Message
De
24/02/2005 14:45:00
 
 
À
24/02/2005 13:29:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
00989905
Message ID:
00990277
Vues:
32
>>But why VFPT don't have choice the MS SQL syntax ?
>>Where is the benefit ?
>>
>
>Where is the problem?

1. maintenance or variation
On MS SQL
DELETE tableX FROM TableX JOIN .... TableX...... 
* this variation don't change the command
DELETE tableX FROM TableX XAlias JOIN .... XAlias......
On VFP
DELETE tableX FROM TableX JOIN .... TableX...... 
* this variation don't change the command
DELETE XAlias FROM TableX XAlias JOIN .... XAlias......
You say, a single word you have changed! True
But which:
the more important word into the command,
that one that says in which table will come made the modifications;
with MS SQL I do not have to make a translation in order to understand it,
in VFP I must search to right and find the effective tablename.

2. More important, This command does not have the same one meant in MS SQL,
therefore the amount of modifications or varying to make in a upsize or in an application that it uses VFP and MS SQL are uselessly greater.
DELETE tableX FROM TableX XAlias JOIN .... XAlias......
Of course, all it can be understood and be used,
but when it complicates the things without to carry benefits,
then it is a problem.

Aleksey, they are the details that make the difference.

However, by now the things have been made therefore and therefore will remain.

Hi
Fabio
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform