Schemas

[Scotte Meredith]

You would need to get the list of schemas and then loop through to get the columns for each schema and add them to another list.

If the schemas are in lList, loop through the list doing something like this:

Do $schemas.[lList.C1].$objs.$makelist($ref.$name) Returns lColumns

This will give you a list of the names of columns. You can include any other properties of the columns as well.



> On Sep 7, 2022, at 6:33 AM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi All,
> I have this command that lists all the schemas in use:
> Do $schemas.$makelist($ref.$name) Returns lList
> 
> Which similar command can I use to get all the columns in all my schemas?Which command could I use to filter out some of the schemas?
> 
> Rgds,Martin O.
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



Scotte Meredith
spomacguy at gmail.com
509/998-0991