Re: (no subject)

Aubit4GL shouldnt need an oid column, the oid column is only mainly to
replicate the ROWID functionality of Informix.
If you dont use the ROWID but use a proper primary key, you shouldn't need
a separate OID column

That said - you can use the "THRU" syntax to pick a range of columns

DISPLAY BY NAME gr_customer.customer_num  THRU  gr_customer.phone



On Thu, 24 Jun 2021 at 17:55, James B. Byrne via Aubit4gl-discuss <
[email protected]> wrote:

>
>
> On Thu, June 24, 2021 10:57, Mike Aubury wrote:
> > Probably.
> >
> > On Thu, 24 Jun 2021 at 15:48, James B. Byrne via Aubit4gl-discuss <
> > [email protected]> wrote:
> >
> >> This would not be due to the oid field would it?
>
> Yes, it was the oid field.  This is a problem.  Postgresql has eliminated
> the
> table oids and has removed the ability to add them.  Therefore, as Aubit4gl
> requires an oid exist on each row that it it updates, an explicit oid
> column is
> required.
>
> Which oid column is returned when one uses the table,* syntax.  Which
> requires
> that a field for the oid be present on any form that uses the table.*
> syntax to
> populate the display.
>
> I have added an oid field to the screen layout which removes the error.
> However, displaying an empty, inaccessible [      ] field is a little
> crude.
>
> Is there any way of putting the oid field in the screen without displaying
> delimiters but permitting the other fields to have them?  The NOENTRY and
> INVISIBLE field attributes work  but the delimiters remain.
>
> Thanks,
>
> >>
> >> On Thu, June 24, 2021 10:34, Mike Aubury wrote:
> >> > And the form ?
> >> >
> >> #### f_customer.per                                      ####
> >> #### fcompile f_customer.per --> f_customer.afr.dat      ####
> >> ## v 1.0.0 - 2021-02-01 - Initial (JBB)
> >> ## Uses:
> >> ## Used by: ex5.4ae
> >> ## Purpose: Input screen for customer table data entry
> >> ####
> >>
> >> DATABASE demo_stores
> >>
> >> SCREEN
> >> {
> >>
> >> Customer Number:    [f000   ] Company Name:     [f001
> >>    ]
> >>         Address:    [f002             ]
> >>                     [f003             ]
> >>           City :    [f004             ] State:[f5] Zip Code:[f006  ]
> >>    Contact Name:    [f007             ] [f008               ]
> >>       Telephone:    [f009             ]
> >>
> >> }
> >>
> >> TABLES
> >>   customer
> >>
> >> ATTRIBUTES
> >>   f000 = customer.customer_num, NOENTRY;
> >>   f001 = customer.company;
> >>   f002 = customer.address1;
> >>   f003 = customer.address2;
> >>   f004 = customer.city;
> >>   f5 = customer.state, UPSHIFT;
> >>   f006 = customer.zipcode;
> >>   f007 = customer.fname;
> >>   f008 = customer.lname;
> >>   f009 = customer.phone, PICTURE = "###-###-#### XXXXX";
> >>
> >>
> >> --
> >> ***          e-Mail is NOT a SECURE channel          ***
> >>         Do NOT transmit sensitive data via e-Mail
> >>    Unencrypted messages have no legal claim to privacy
> >>  Do NOT open attachments nor follow links sent by e-Mail
> >>
> >> James B. Byrne                mailto:[email protected]
> >> Harte & Lyne Limited          http://www.harte-lyne.ca
> >> 9 Brockley Drive              vox: +1 905 561 1241
> >> Hamilton, Ontario             fax: +1 905 561 0757
> >> Canada  L8E 3C3
> >>
> >>
> >>
> >> _______________________________________________
> >> Aubit4gl-discuss mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
> >>
> >
>
>
> --
> ***          e-Mail is NOT a SECURE channel          ***
>         Do NOT transmit sensitive data via e-Mail
>    Unencrypted messages have no legal claim to privacy
>  Do NOT open attachments nor follow links sent by e-Mail
>
> James B. Byrne                mailto:[email protected]
> Harte & Lyne Limited          http://www.harte-lyne.ca
> 9 Brockley Drive              vox: +1 905 561 1241
> Hamilton, Ontario             fax: +1 905 561 0757
> Canada  L8E 3C3
>
>
>
> _______________________________________________
> Aubit4gl-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss