Hello Drew, On Thu, 2007-09-20 at 14:23 +0000, Drew wrote: > Howdy Swarup, > > Well, I was not as clear as I might have been on that then. > > Using a table grid control on a form you have control over the display > of the tables fields. > You can choose to not display a particular field in the table for > instance. > You can rearrange the order of the fields on the table for display. > You can NOT alter the structure of the table, to do that you must use > the table property editor found in the Tables section. > > This is similar again to how MS Access works. In the table view you > can rearrange the order of the fields, but to add a field to table > itself you must switch into design mode. > > For for example. Let's say that you created a table, began using it > and then realized you needed to add a new field. You would like that > field to display in the third position in the table. > > You would go to the Tables section in Base and open the table in edit > mode. This brings up the property editor. You would add a new field, > but this field will be added to the end of the table. That is the only > choice you have at the moment using the GUI. After saving your edits > if you opened the data view window on the table ( double clicking the > table name for instance ) the order of the fields displayed is > identical to the order they hold in the physical table. > > However if you instead return to your form, open it in edit mode and > select the grid you would do this. > Right mouse click on the table grid's header. On the context menu that > opens you select 'Show Columns'. The newly added field in the table > will be listed. You select it - again it is added to the end of the > fields. But here you can drag it to the third position and then save > the form. From now on when you open the form for data editing the > order of the fields will be what you wanted. > > Drew
Thank you very much. I will study this carefully, and test it out, and then get back to you if I have any further questions. I am also in the middle of investigating how to import a query from MSA into Ubuntu BASE. You had said earlier that I should do that by exporting from MSA as an SQL, and to make a temp file of the SQL file. I was in Windows MSA this morning trying to read up in the Help files on how to export as SQL. It was quite detailed reading, and I guess I haven't yet come away with a clear understanding. It talks about using ODBC file data sources, and exporting to an SQL server. I'm not quite sure if it has the needed driver or whatever is needed, already installed? Or if there is something more I would need in order to do this. I am using Office 2000. I'm going to read more on it, but if you have any tips in the mean time, that would be great! Regards, Swarup > >-----Original Message----- > >From: Dinbandhu [mailto:[EMAIL PROTECTED] > >Sent: Thursday, September 20, 2007 09:26 AM > >To: dev@dba.openoffice.org > >Subject: Re: [dba-dev] OO 2.3 Base "form" view says "read-only"-- But > it's not > > > >Hello Drew, > >Many thanks for the macro detailing how to change the header of the > form > >so it doesn't say "read-only". That is very helpful. > > > >One question I did have about what "read-only" actually means there. > You > >wrote: > > > >"That is telling you the 'document' is read only - in other words you > >can not move the controls around or edit their properties. The data > link > >is not read only." > > > >So I can change and add data, but I could not alter the structure of > the > >table? Is that what it means? If so, it confuses me a bit because > >earlier, you had told me that using the "forms" view I can add new > >columns and insert them wherever in the column order I like. > > > >So, what sort of structural changes can one implement using the > "forms" > >view, and what sort of structural changes would not be possible. > > > >Thanks, > >Swarup > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
