Sun java Creator has a mysterious verb
"execute"
as in RowSet.execute();
the only documentation is
"execute fills the row with data"
 its not clear when this should be called.
 ie some commands actually work
 others require a pre- or succeedint "execute" to execute
 as my boss says: what about "execute-the-execute" ???

in one demo, Sun have this mysterious comment
       // NOTE - no execute necessary because we used "Bind to Database"

Beware, I have a text field bound to daabase, but if I dont have "execute"
I get error message "execute neve called"

I wish the message said "execute not called after blah blah"

"never" is an exceedingly irritating word.

I suspect that there is no consistent description about "execute"
- its probably an ad-hoc throw it in.
But Creator is so slow testing is a pain.

Today I have
               int index = personRowSet1.getRow();
               personRowSet1.next();
Now, index returns 1
BUT "next" gives  SQL error "invalid state, may be before start or after end"
- this SunJavaCreator beast would be a monster on a good day,
but given that Sun Forum is unresponsive,
my chances of getting anything usefull out of this beast seem slim

kelvin

OK I admit, next will fail on a RowSet with one row
Its just so muddled having
personRowSet  with all rows
and personRowAet1 with 1 row

Please let it be possible to use one RowSet only to update a table...