>I've had a similar complaint with INSERT-SQL
>
>INSERT INTO TABLE (;
> FIELD1, ;
> FIELD4, ;
> FIELD2, ;
> FIELD3, ;
> FIELD6, ;
> FIELD5, ;
> FIELD8, ;
> FIELD9 ;
> ) ;
> VALUES ;
> (;
> 'A', ;
> 'D', ;
> 'B', ;
> 'C', ;
> 'F', ;
> 'E', ;
> 'G', ;
> 'H', ;
> 'I' ;
> )
>
>Why does the above line not give me the correct result? field1 gets a to field9 gets I.
For this one I've found by trial and terror that the best way is to arrange them in threes or fours - whatever makes a line not too long:
insert into mytable (field1, field2, field3, field4, ;
field5, field6, field7, field8, field9);
values ("a", "b", "c","d", ;
"e", "f", "g", "h", "i")
Then even if they aren't lined up in any alphabetic or logical order, they can still be counted in chunks that I can mentally follow, line by line.