Re: (no subject)
"James B. Byrne via Aubit4gl-discuss" <[email protected]> Thu, 24 Jun 2021 12:54:52 -0400
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <[email protected]> |
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