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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CH2PR02MB682135DE10B0A9F40119E93EA0989%40CH2PR02MB6821.namprd02.prod.outlook.com.
