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 [cid:[email protected]] 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]<mailto:[email protected]> O: 913-829-0888 C: 913-915-3137 From: 'Jim Belisle' via RBASE-L <[email protected]<mailto:[email protected]>> Sent: Wednesday, March 3, 2021 12:13 PM To: [email protected]<mailto:[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. [cid:[email protected]] 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 [cid:[email protected]] -- 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]<mailto:[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.
