Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERT not as maintainable?
Message
 
To
26/07/2006 16:32:32
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01140411
Message ID:
01140452
Views:
22
>>>Buffering removes these concerns as well, no?
>>
>>O, yes :-)
>>Buffering and/or Transactions remove all concerns, buy I still prefer INSERT :-)
>>You could make it more redable with a few comments:
>>
>>INSERT INTO Test (;
>>                  Field1,;
>>                  Field2,;
>>                  Field3 ;
>>                  );
>>            VALUES;
>>                  (;
>>                  Expr1,; && Field1
>>                  Expr2,; && Field2
>>                  Expr3;  && Field3
>>                  )
>>
>
>Not funny! More typing leads to more mistakes!! :)

Agree, but with APPEND BLANK/REPLACE you type more than if you use just INSERT.
What about this:
INSERT INTO Test (Field1, Field2, Field3) VALUES;
                 ( Expr1,  Expr2,  Expr3)
Of course this format is not suitable for long field list insert.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform