Dinbandhu wrote: > On Wed, 2007-09-05 at 18:23 +0200, Andreas Saeger wrote: >> Swarup, >> Please notice the P.S. at the bottom before you continue. > > I've got success. The database is created, it has all the correct data > in it, and it is fully editable. > > Using the guidelines you've given in this current letter about how to > set up the "Date" field in the spread sheet and get all the dates to > copy over in the ISO format, it all worked. > > There is one slight problem I do have, which I can manage with but which > should be able to be fixed. I tried having the wizard set up its own > primary key. But after finishing all the field parameters etc in the > wizard and giving it the order to "create table", it gave an error: > "java.lang.NullPointerException". Any idea why?
Sorry, no idea. And having given that > error, when I clicked on "ok", then that was the end. That is, it didn't > even create the table. So I tried it again, this time without having the > wizard create a primary key. And without a primary key, it created the > whole table just fine. Then I went to the table's contextual "edit" and > made my "ID" field the primary key. And it worked. The table opens and > is fully editable. The only question that remains is that, the primary > key does not auto-add when I make a new row at the bottom of the table. > It should auto-generate a new number, but it is not doing that. I have > to type it in myself. --But that is the only problem. So how do I make > the primary key autogenerate a new number when I start a new row in the > table? If I can understand how to do that, then this whole work will be > complete. > > Many thanks for all your help, > Swarup > Call the edit view of the table and select the field in question. At the bottom you can choose "Auto Value" = Yes. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]