O$8172 Change schema column names

[Mike Rowan]

Thanks Daniel.  I'll try it.

On Wed, Aug 19, 2020 at 10:01 AM Daniel Sananes <daniel.s at kopparbergs.se>
wrote:

> I think you can exclude the .$ident. part in your assignment
> Below is in O7 Classic and works
>
> Set current list LIST
> Calculate LIST as
> $clib.$formats.Artikel.$objs.$makelist($ref.$name,$ref.$ident)
> Redefine list {LNAME,LIDENT}
> ;
> Calculate LNEWNAME as 'NEWNAME'
> Calculate #F as
> $clib.$formats.Artikel.$objs.[LIST(2,2)].$name.$assign(LNEWNAME)
> ;
> Local variable LIST (List)
> Local variable LNAME (Character   40)
> Local variable LIDENT (Long integer)
> Local variable LNEWNAME (Character   40)
>
>
> -----Ursprungligt meddelande-----
> Från: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> För Mike Rowan
> Skickat: den 19 augusti 2020 00:13
> Till: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Ämne: O$8172 Change schema column names
>
> I need to change some schema column names and think this should be
> possible using notation.
>
> So, I have used $makelist to list the $ref.$name, $ref.$ident into lvList
> and that looks good.
>
> But with the new column name in lvNew
>
> Do
> $clib.$schemas.[schemaname].$objs.$ident.[lvList.1.C2].$name.$assign(lvNew)
> Returns %R
>
> does not work, nor any variation I can think of.  All result in %R = 0 or
> %R IS NULL.
>
> Anyone know the trick?  Thanks in advance.  Mike
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new
> message -> mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>