>>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......
DELETE tableX FROM TableX XAlias JOIN .... XAlias......
On VFP
DELETE tableX FROM TableX JOIN .... TableX......
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