OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Real-World Form

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
littlehouse
Guest





PostPosted: Wed Oct 29, 2003 2:50 am    Post subject: Real-World Form Reply with quote

Hi everyone.
mysqltables
Table (autoid,item, price)
item(autoid,item)
price(autoid,price)
I want to construct a form for browsing and adding data to table.
I want to build this form in a smarty way so that when a user want to add a record the form should present in a combo-box not the real value of the Table fields (1,2,3,4,5 for example) but the masked value: flower, tree, grass...and the same for the price, but will store in Table the autoid of the item and the autoid of the price.
Browsing the record should also appear the masked values.
Is there an example of how to do this.
Is just the way the phpmyadmin extension work.
Thanks
Back to top
GraemeWi
OOo Enthusiast
OOo Enthusiast


Joined: 21 Jan 2003
Posts: 117
Location: Auckland, New Zealand

PostPosted: Wed Oct 29, 2003 11:31 pm    Post subject: Reply with quote

I did something similar for another user a couple of weeks ago:

http://www.graemewi.orcon.net.nz/OOo/products.html

The only thing that would need to be changed is the properties of the columns in the table control, set them to enabled and change the read only to 'no'.

Ignore the bit about the filters as well as the user was after a form to update just the price (not adding more fields etc)

Cheers,

G
Back to top
View user's profile Send private message
littlehouse
Guest





PostPosted: Fri Oct 31, 2003 12:31 am    Post subject: Real World Form Reply with quote

Thanks very much
Back to top
littlehouse
Guest





PostPosted: Mon Nov 03, 2003 2:19 am    Post subject: Reply with quote

Ops.
Everything work but the update process is not correct. When I look at the value stored with phpmyadmin I see the masked values (grass, flowers,...) and not the autoid values (1,2,3,4,5...) so it doesn't store the correct values.

In my version of openoffice (RC5 Italian) the data properties of the control doesn't have the "Bound field" row: it has only Data Field, Type of list contents, List Contents and The Zero-Value control.
Back to top
Guest






PostPosted: Mon Nov 03, 2003 3:16 am    Post subject: Reply with quote

Solved.
I used the wrong widget (combo instead the list box)
Whit list box everything is ok
Back to top
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group