Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 7 of 7 total |
And another enhancement suggestion |
Sun, Jan 28 2007 8:30 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I have columns where there are a few limited choices. The one that brought this to mind was daily/weekly/monthly/annual. I know I can set up another table holding these and use RI to link but I thought it would be nice to have somewhere in the catalogue to define the "picklist" which could then be accessed to populate dropdowns or picklists in a grid. I can easily cludge it by using the description field which may even be a better option. Your thoughts would be welcome. Roy Lambert |
Sun, Jan 28 2007 10:52 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I have columns where there are a few limited choices. The one that brought this to mind was daily/weekly/monthly/annual. I know I can set up another table holding these and use RI to link but I thought it would be nice to have somewhere in the catalogue to define the "picklist" which could then be accessed to populate dropdowns or picklists in a grid. >> Well, you could always define a CHECK constraint like this: My Column IN ( 'Daily', 'Weekly', 'Monthly', ) and then parse out the bits that you want from the CHECK constraint expression found here in the CheckExpr column: http://www.elevatesoft.com/edb1sql_constraints_table.htm << I can easily cludge it by using the description field which may even be a better option. >> That might be a better option because it would eliminate the need for parsing the above and you could just specify it like this: DESCRIPTION 'Daily Weekly Monthly' and then it will be in nice, neat rows in this information schema table: http://www.elevatesoft.com/edb1sql_tablecolumns_table.htm -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Jan 28 2007 11:48 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< I can easily cludge it by using the description field which may even be a >better option. >> > >That might be a better option because it would eliminate the need for >parsing the above and you could just specify it like this: > >DESCRIPTION 'Daily >Weekly >Monthly' > >and then it will be in nice, neat rows in this information schema table: Thinking about it this is the way I'm going to go. Once I learn how I can then extract the description and use it to populate the picklist. Roy Lambert |
Mon, Jan 29 2007 3:31 AM | Permanent Link |
Chris Erdal | Roy Lambert <roy.lambert@skynet.co.uk> wrote in
news:95FEDF4F-733F-4BBE-BBFD-DFA372364120@news.elevatesoft.com: > I have columns where there are a few limited choices. The one that > brought this to mind was daily/weekly/monthly/annual. > > I can easily cludge it by using the description field which may even > be a better option. > > Your thoughts would be welcome. Roy, I work in France, where they often speak French. Actually in the south of France in a bit that is part of the area known as Catalunya, where some of them prefer to speak Catalan. Right on the border with Spain, where several companies have subsidiaries in Barcelona, etc.etc... I wouldn't ever consider putting a pick-list in the database definition. You never know who's going to see your program and then contact you to use a copy in their part of the world. I really feel RI is the way to go. Caching should make the little tables zip along, and they'd allow you to add Maestro cards to Mastercard and Visa without reinstalling the database! -- Chris (XP-Pro + Delphi 7 Architect + DBISAM 4.24 Build 1) |
Mon, Jan 29 2007 4:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Chris
>Roy, I work in France, where they often speak French. What a dreadful fate Roy Lambert |
Mon, Jan 29 2007 6:29 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< What a dreadful fate >> Don't let my daughter hear you say that. She's in her second year of French and her first year of German, and she loves them both. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jan 30 2007 5:01 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Children are such weird things, I'm always amazed I used to be one Roy Lambert |
This web page was last updated on Friday, September 20, 2024 at 05:39 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |