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]> 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] <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/!%26!AAAAAAAAAAAYAAAAAAAAABa4qWuusAlBoskXxE2AV1mChgAAEAAAANhSAiP4xRxJrW7v/ZiNnVMBAAAAAA%3D%3D%40vtgonline.com.
