Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Codage, syntaxe et commandes
>>To be honest, I think the ansi SQL should provide us with some mechanism to do more or less what we did in VFP for years. Not looking too strict on the fields missing an aggregation function, but by default take the last (non null) value as VFP did.
>
>I understand what you are saying, however doing that would render the ANSI SQL Standard syntax able to accept queries that have ill defined results according to the statement itself. Knowing the data doesn't cound when you are setting a standard. The non-aggregarate fields in one of those selects are not well defined in their return value so the standard disallows them.
>
>This problem is not really new to VFP9 it was a problem when trying to run queries that ran fine in VFP in SQL Server or Oracle where they violated the standard. Although I can understand what you are saying I don't agree that having VFP9 enforce the standard is a bad thing. Just have to get used to it and write queries that comply with it. Don't pull those extra fields in the original query rather get them after the first query with a seocnd one.
I don't say that VFP9 implementation is bad, however splitting one statement into two (pre
VFP9) is notreally a viable alternative when dealing with views: it has to be done in one.
Anyways, I'm still working with set enginebehaviour 70 in my applications as I like to have the opportunity to do it the VFP way, esspecially on local (cursor) data.
Walter,
Walter,
Précédent
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