Does anyone have a function that will allow me to loop through a list retrieving values based on the index of the item, count items in the list. This list could be dynamic or static.
Any help would be greatly appreciated, also in adding this to ebase.
Loop Through List
Moderators: Jon, Steve, Ian, Dave
- Joost
- Ebase User
- Posts: 49
- Joined: Fri Sep 14, 2007 6:14 pm
- Location: The Netherlands
More work and code then a (custom) function, but if you haven't tried this yet you could create a db-resource which queries the dynamic/static list and use it to fill a table-field.
You then may loop at the table and count or get the required data. You could even use the modified table data to fill a dropdown field.
You then may loop at the table and count or get the required data. You could even use the modified table data to fill a dropdown field.
0 x
-
- Ebase User
- Posts: 22
- Joined: Fri Jun 06, 2008 8:35 am
The problem i have is that the product we have, has a tailorability statement which prevents us doing such things, however functions are permitted.Joost wrote:More work and code then a (custom) function, but if you haven't tried this yet you could create a db-resource which queries the dynamic/static list and use it to fill a table-field.
You then may loop at the table and count or get the required data. You could even use the modified table data to fill a dropdown field.
0 x
-
- Ebase User
- Posts: 94
- Joined: Fri Sep 14, 2007 12:18 pm
- Location: The Netherlands
- Contact:
RE: Loop Through List
Does "tailorability statement" mean that contractually you are not allowed to connect directly to and query the database?
How exactly are you getting the list into Ebase?
An Ebase list is (normally speaking) a table in a database. Static Lists are in the repository and Dynamic Lists can be in any database to which you are connected. All the list is, is a query on a table in a database. Since you already have a query on the database referencing the list I am not sure where the problem is in creating another query on the same database.
How exactly are you getting the list into Ebase?
An Ebase list is (normally speaking) a table in a database. Static Lists are in the repository and Dynamic Lists can be in any database to which you are connected. All the list is, is a query on a table in a database. Since you already have a query on the database referencing the list I am not sure where the problem is in creating another query on the same database.
0 x
Who is online
Users browsing this forum: No registered users and 133 guests