>>>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,;
>> Expr2,;
>> Expr3;
>> )
>>
>
>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.