Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Crystal Reports
Versions des environnements
Network:
Windows 2000 Server
>>>What can be more concise than REPLACE a WITH b?
>>
>>Sorry Bill but this gave me a chuckle. How is that concise? You don't say if b is a field or a memvar and you don't say the alias. ;) Just kidding around.
>
>UPDATE Table SET Column = 'some value'
>
>Pretty concise to me :)
We discovered a bug yesterday. 1 REPLACE only allows 128 a with b sets and gives a syntax error if you go beyond that, whereas SQL gives a too many fields in update error, if you go beyond 256. Even it's bug reporting is more concise. :)
However, one of my pet peeves about SQL is why do they use SET column = value in the UPDATE command, but
INSERT INTO TABLE (field1, field2, field3, field4, field5)
values (asdgagrwsf,asdfasg,asdfkaflka,asfkslkasklf,afklasdlka)
I find it hard to match the values against the field names. IMO it would be better
INSERT INTO TABLE (
field=asdgagrwsf,
field2=asdfasg,
field3=asdfkaflka)
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