This command works:
R>SELECT slot_no AS `Employee ID`, emp_class AS `Employee Classification`, emp_sname AS `Employee Short Name` FROM emp_file Employee Employee Employee Short Name --------- -------- -------------------- ZG-03 AET NORBY, J ZG-01 FMS NELSON, V ZM-09 FOR BRAINARD JR., G You will notice the names get truncated; however, I can specify the lengths as follows: R>SELECT slot_no=15 AS `Employee ID` emp_class=25 AS `Employee Classification`, emp_sname=20 AS `Employee Short Name` FROM emp_file Employee ID Employee Classification Employee Short Name --------------- ------------------------- -------------------- ZG-03 AET NORBY, J ZG-01 FMS NELSON, V ZM-09 FOR BRAINARD JR., G And now all the aliases are displayed fully and correctly. You might try: SET MESSAGES ON SET ERROR MESSAGES ON And see what error you get and go from there. Javier, Javier Valencia, PE <mailto:[email protected]> [email protected] O: 913-829-0888 C: 913-915-3137 From: 'Jim Belisle' via RBASE-L <[email protected]> Sent: Thursday, March 4, 2021 5:16 AM To: [email protected] 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] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of [email protected] <mailto:[email protected]> Sent: Wednesday, March 3, 2021 3:30 PM To: [email protected] <mailto:[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 <mailto:[email protected]> [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. 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] <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] <mailto:[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/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAAI34dIwpqEBNr4Ghzau8LFgBAAAAAA%3D%3D%40vtgonline.com.
