Jim,
Spaces are not allowed. Suggestion: Use the underscore: Model_Number
Tony
Op 03-03-2021 om 19:13 schreef 'Jim Belisle' via RBASE-L:
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
<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/80191f4c-cb7a-543a-aa5d-0c8d9648db63%40cio-bv.nl.
