You didn't put quotes around the alias, did you? I've never done that, and
when I tested one I got an error.
Also do you run with ANSI OFF? I'm wondering if "pagenumber" is a no-go
Karen
-----Original Message-----
From: 'Jim Belisle' via RBASE-L <[email protected]>
To: [email protected] <[email protected]>
Sent: Thu, Mar 4, 2021 5:16 am
Subject: RE: [RBASE-L] - edit table using aliases
#yiv3190467343 -- filtered {}#yiv3190467343 filtered {}#yiv3190467343 filtered
{}#yiv3190467343 p.yiv3190467343MsoNormal, #yiv3190467343
li.yiv3190467343MsoNormal, #yiv3190467343 div.yiv3190467343MsoNormal
{margin:0in;font-size:11.0pt;font-family:sans-serif;}#yiv3190467343 a:link,
#yiv3190467343 span.yiv3190467343MsoHyperlink
{color:blue;text-decoration:underline;}#yiv3190467343
.yiv3190467343MsoChpDefault {font-size:10.0pt;}#yiv3190467343 filtered
{}#yiv3190467343 div.yiv3190467343WordSection1 {}#yiv3190467343 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] <[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] 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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CH2PR02MB682135DE10B0A9F40119E93EA0989%40CH2PR02MB6821.namprd02.prod.outlook.com.
--
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.
--
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/1843710720.385801.1614866019000%40mail.yahoo.com.
