I'm away on a trip so no laptop, I have a a similar function with alias column names and from memory I included option nochg off, can't remember but give it ago
On Fri, 5 Mar 2021, 12:53 am 'Jim Belisle' via RBASE-L, < [email protected]> wrote: > I do not see pagenumber as a reserved word in RBASE nor do I see it as > part of the ANSI reserved words. > > > > James Belisle > > > > *Making Information Systems People Friendly Since 1990* > > > > *From:* 'Karen Tellef' via RBASE-L <[email protected]> > *Sent:* Thursday, March 4, 2021 7:54 AM > *To:* [email protected] > *Subject:* Re: [RBASE-L] - edit table using aliases > > > > You didn't put quotes around the alias, did you? I've never done that, > and when I tested one I got an error. > > > > Also do you run with ANSI OFF? I'm wondering if "pagenumber" is a no-go > > > > Karen > > > > > > > > -----Original Message----- > From: 'Jim Belisle' via RBASE-L <[email protected]> > To: [email protected] <[email protected]> > Sent: Thu, Mar 4, 2021 5:16 am > Subject: RE: [RBASE-L] - edit table using aliases > > I tried all the suggestions, removed the spaces in the alias names, > removed the extra comma and removed the extra plus sign. Still no go. I > changed code back to using all actual column names and it now edits. > > > > If others can try that on their RBASE and it is successful, any blues > clues would be appreciated. > > > > James Belisle > > > > *Making Information Systems People Friendly Since 1990* > > > > *From:* [email protected] <[email protected]> *On Behalf Of > *[email protected] > *Sent:* Wednesday, March 3, 2021 3:30 PM > *To:* [email protected] > > > *Subject:* RE: [RBASE-L] - edit table using aliases > > > > *CAUTION:*This is an EXTERNAL EMAIL, *STOP!* and think before clicking on > any links or opening attachments. > > Just a correction that might make a difference. Remove the comma after > “`Page Number`, ” > > > > EDIT + > > model# AS `Model Number`, + > > kprsellpw AS `KPR List Price`, + > > proddesc AS `Product Description`, + > > modelwgtpw AS `Weight`, + > > sortonepw AS `Prod Line`, + > > sorttwopw AS `Sort Two`, + > > pagenumpw AS `Page Number` + > > FROM xlistupsurcharge + > > OPTION CAPTION 'Backup Catalog Product Information' + > > |WINDOW_STATE MAXIMIZED + > > |COLUMN_WIDTH[0] 150 + > > |COLUMN_WIDTH[1] 150 + > > |COLUMN_WIDTH[2] 400 + > > |COLUMN_WIDTH[3] 50 + > > |COLUMN_WIDTH[4] 50 > > > > ..and it should work…I think. 😊 > > Javier, > > > > Javier Valencia, PE > > [email protected] > > O: 913-829-0888 > > C: 913-915-3137 > > *From:* 'Jim Belisle' via RBASE-L <[email protected]> > *Sent:* Wednesday, March 3, 2021 12:13 PM > *To:* [email protected] > *Subject:* [RBASE-L] - edit table using aliases > > > > I am using the syntax given in the help in an attempt to edit a table > using alias column names. > > This is the syntax I am using. > > EDIT + > > model# AS `Model Number`, + > > kprsellpw AS `KPR List Price`, + > > proddesc AS `Product Description`, + > > modelwgtpw AS `Weight`, + > > sortonepw AS `Prod Line`, + > > sorttwopw AS `Sort Two`, + > > pagenumpw AS `Page Number`, + > > FROM xlistupsurcharge + > > OPTION CAPTION 'Backup Catalog Product Information' + > > |WINDOW_STATE MAXIMIZED + > > |COLUMN_WIDTH[0] 150 + > > |COLUMN_WIDTH[1] 150 + > > |COLUMN_WIDTH[2] 400 + > > |COLUMN_WIDTH[3] 50 + > > |COLUMN_WIDTH[4] 50 > > RETURN > > > > However when I go to edit the table, after changing the info in one column > and attempting to go to the next line, I get this error message. > > > > > > The help instructions below seem to use this same syntax. > > EDIT + > > CustID AS `Customer ID`, + > > Company AS `Company Entity`, + > > CustAddress AS `Home Office Address`, + > > CustCity AS `Home Office City`, + > > CustState AS `Home Office State`, + > > CustZip AS `Home Office Zip Code`, + > > CustPhone AS `Primary Phone Number`, + > > CustFax AS `Fax Number`, + > > LastUpdateDate AS `Last Date Modified`, + > > LastOrderDate AS `Last Order Date`, + > > CustURL AS `Company Home Page`, + > > CustEMail AS `Primary Email Address`, + > > CustStatus AS `Active Status`, + > > PaymentTerm AS `Payment Terms`, + > > CreditLimit AS `Imposed Credit Limit` + > > FROM Customer + > > WHERE CustStatus = 'A' + > > ORDER BY Company ASC + > > OPTION CAPTION 'Active Customer Information'+ > > |WINDOW_STATE NORMAL + > > |COLUMN_WIDTH[4] 50 + > > |COLUMN_WIDTH[5] 50 + > > |COLUMN_WIDTH[12] 50 > > > > Has anyone else run into this problem? > > > > James Belisle > > > > *Making Information Systems People Friendly Since 1990* > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/CH2PR02MB682135DE10B0A9F40119E93EA0989%40CH2PR02MB6821.namprd02.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/CH2PR02MB682135DE10B0A9F40119E93EA0989%40CH2PR02MB6821.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/rbase-l/CH2PR02MB682110C80CD8E266507B8BECA0979%40CH2PR02MB6821.namprd02.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/CH2PR02MB682110C80CD8E266507B8BECA0979%40CH2PR02MB6821.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> > > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/1843710720.385801.1614866019000%40mail.yahoo.com > <https://groups.google.com/d/msgid/rbase-l/1843710720.385801.1614866019000%40mail.yahoo.com?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/DM6PR02MB6828FBDB44AE44D5AE3D9E92A0979%40DM6PR02MB6828.namprd02.prod.outlook.com > <https://groups.google.com/d/msgid/rbase-l/DM6PR02MB6828FBDB44AE44D5AE3D9E92A0979%40DM6PR02MB6828.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDASxDE2XPoSfYJgcHs6K1Wh7cdgMa41nPaokDixTqqvH6g%40mail.gmail.com.
