the indentation is simply what the tab was/is set to... trivial.
i already have an sql schema.. so i don't need sqlobject to create the table... i'm interfacing with a live mysql/db.
It was just my reaction to the SQL code in your posting. I had a feeling you are creating/dropping the table using this code.
while it's easy/trivial to add the 'id' via calling the class, and setting the 'id' just like the other fields... my real goal/task was to see if you can set a field in the "set" method. the "set" method works for any field that i've tried, except the "id" issue!
the docs imply that you should be able to have the constructor be able to set a field within the constructor.
so.. this is the goal...