TOPIC:

Ready filled tables 05 Oct 2011 14:01 #108

Kevin Topic Author Visitor	When I build a table to use for a drop down menu eg Mr, Mrs,Ms or Monday Tuesday Wednesday etc, it would be nice to be able to add this data into the component. That way it will me ready to go when installed. Sorry should have put this in new functions [MOVED]
	Please Log in or Create an account to join the conversation. Last edit: by admin.

Re: Ready filled tables 05 Oct 2011 17:15 #109

zutiste Offline New Member Posts: 18 Thank you received: 1	For lists like Mr, Mrs you can use the enumeration data type
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 05 Oct 2011 17:53 #110

griiettner Offline Senior Member Posts: 73 Thank you received: 12	zutiste Can you give an example of how to use the enumeration... because last night was trying to find a good use ofr it, but I still did not get it... thanks Paulo Griiettner
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 05 Oct 2011 18:07 #111

zutiste Offline New Member Posts: 18 Thank you received: 1	well, not sure I understand your question because it looks very simple to me. for example, a table with first name and last name. you can add an enumeration field with the values "Mr, Mrs, Miss". just edit the field to specify the values. I guess it's good for values that won't change.
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 05 Oct 2011 18:14 #112

griiettner Offline Senior Member Posts: 73 Thank you received: 12	If I understood right... I could use it to make to fields like "Pending", "Canceled" and "Sent" for orders for instance? If that's the use of this field, I think is nice... Paulo Griiettner
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 06 Oct 2011 05:26 #114

zutiste
Offline
New Member
Posts: 18
Thank you received: 1

yes, correct.

- if the data won't change
- if there is no extra information associated to the data

ie :
-> "Pending", "Canceled" and "Sent" is set for eternity and does not need any extra information
-> List of prices : it might change
-> List of countries : there might be associated information like biggest cities, international country calling code, time zone, etc

The following user(s) said Thank You: griiettner

Please Log in or Create an account to join the conversation.

Re: Ready filled tables 06 Oct 2011 06:01 #115

griiettner Offline Senior Member Posts: 73 Thank you received: 12	Thanks mate... I got it now... I found a good use for it now... I was doing in another way, but using this feature, makes things easier... Paulo Griiettner
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 06 Oct 2011 08:13 #116

Kevin
Topic Author
Visitor

Nice one zutiste this has made life so much easier.
I was using the foreign key method to show info from another table.

The problem I had with foreign key was, the id was stored in the database instead of the value.
i.e Mr=1 Mrs=2 Ms=3.

I want to be able to export the data to an excel file so that would have been a problem./

Very happy I asked the original question now or I wouldn't have learned this.

Karma added, cheers

Please Log in or Create an account to join the conversation.

Page:
1

Forum

Ideas & Suggestions

New functionalities

Ready filled tables

Time to create page: 0.137 seconds

“

”

I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)