>>REPLACE ;
> field1 WITH "value1", ;
> field2 WITH "value2", ;
> field3 WITH "value3", ...
> IN TableAlias
>
>Al;
>
>Good advice. I would like to suggest two reasons for following your example. First is it is easy to read - with long statements that will make debugging easier. The second reason is the Replace statement is seen and run as one line of code and will thus execute quicker then line by line Replace statements.
>
>Tom
Yes, I'm a big believer in whitespace. Got that from an instructor in an introductory C course about 15 years ago; he actually deducted marks from assignments if there was, in his opinion, insufficient whitespace. Seemed petty and stupid at the time, but looks like genius today...
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up