Karen,
That fixed my issue. Thank you so much! I guess I need more RBASE
training– I’ve never seen SQL syntax like this.
My query looks like this:
(AccountNum,datepd,depnum,checknum,amtpd,interest,principal,nsfflag)
SELECT T1.AccountNum AS AccountNum,T1.datepd AS datepd,T1.depnum as
depnum,T1.checknum as checknum,SUM (T1.amtpd) AS amtpd,SUM ( T1.interest ) AS
interest,SUM ( T1.principl ) as principl,T1.nsfflag AS nsfflag
FROM ActiveReceipts T1
ORDER BY T1.AccountNum, T1.datepd
GROUP BY T1.AccountNum, T1.datepd, T1.checknum, T1.depnum, T1.nsfflag
Really like the help being provided by this list!!
- John
_
John Murnane
UTO Computing Support
Arizona State University
work: 602-496-1137
mobile: 480-543-9582
From: karentellef via RBASE-L [mailto:[email protected]]
Sent: Tuesday, January 16, 2018 12:19 PM
To: [email protected]
Subject: Re: [RBASE-L] - Error using View to create new table
The column "amtpd" isn't by any chance a computed column in the ActiveReceipts
table, is it? If so, then change your "AS" alias
Karen
-----Original Message-----
From: John Murnane <[email protected]<mailto:[email protected]>>
To: rbase-l <[email protected]<mailto:[email protected]>>
Sent: Tue, Jan 16, 2018 1:06 pm
Subject: [RBASE-L] - Error using View to create new table
Hi All:
I’m using R:BASE X Enterprise v 10.03.20116. I am running into an issue with a
an RBASE view. I can successfully run a browse query, see image below, but get
a “Illegal column name (2056)” when I attempt to save the query results to a
new table. Any ideas as to what I’m missing? Thanks in advance!!
Query :
SELECT T1.AccountNum AS AccountNum,T1.datepd AS datepd,T1.depnum as
depnum,T1.checknum as checknum,
SUM (T1.amtpd) AS amtpd, SUM ( T1.interest ) AS
interest,SUM ( T1.principl ) as principl,T1.nsfflag AS nsfflag
FROM ActiveReceipts T1
ORDER BY T1.AccountNum, T1.datepd
GROUP BY T1.AccountNum, T1.datepd, T1.checknum, T1.depnum, T1.nsfflag
Browse Query Result:
[cid:[email protected]]
Error when attempting to “Save Query as Table”:
[cid:[email protected]]
Detail: The column name you specified is unacceptable. A column name must be
from one to eighteen characters long. It must start with a letter and cannot
contain blanks.
ActiveReceipts definition:
lastname
TEXT (30)
firstnm
TEXT (16)
AccountNum
"NUMERIC (8,0)"
pymtdate
DATE
depnum
TEXT (5)
checknum
TEXT (5)
datepd
DATE
amtpd
CURRENCY
nsfflag
TEXT (1)
interest
CURRENCY
principl
CURRENCY
field
TEXT (24)
pymtnum
INTEGER
acrdpd
CURRENCY
- John
_
John Murnane
UTO Computing Support
Arizona State University
work: 602-496-1137
mobile: 480-543-9582
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rbase.com_support_usersgroup-5Fguidelines.php&d=DwMFaQ&c=l45AxH-kUV29SRQusp9vYR0n1GycN4_2jInuKy6zbqQ&r=vpk0PyJh43xdqA62BEUOuvjPHYG0pBgqw__VMfJafi0&m=ZEZaa-skfkF-L5JviLr4O4tAnPjHR22F9XzC7yCRh4Y&s=yalUhvV6pyVbL0xUDFaP9zKe_9BX6uqi1tObexhZSko&e=>
---
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]>.
For more options, visit
https://groups.google.com/d/optout<https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_d_optout&d=DwMFaQ&c=l45AxH-kUV29SRQusp9vYR0n1GycN4_2jInuKy6zbqQ&r=vpk0PyJh43xdqA62BEUOuvjPHYG0pBgqw__VMfJafi0&m=ZEZaa-skfkF-L5JviLr4O4tAnPjHR22F9XzC7yCRh4Y&s=Gt-frJtCp9IAYwj6jzDyAYlOIKKmJLMnG4ZyE6ovwY4&e=>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rbase.com_support_usersgroup-5Fguidelines.php&d=DwMFaQ&c=l45AxH-kUV29SRQusp9vYR0n1GycN4_2jInuKy6zbqQ&r=vpk0PyJh43xdqA62BEUOuvjPHYG0pBgqw__VMfJafi0&m=ZEZaa-skfkF-L5JviLr4O4tAnPjHR22F9XzC7yCRh4Y&s=yalUhvV6pyVbL0xUDFaP9zKe_9BX6uqi1tObexhZSko&e=>
---
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]>.
For more options, visit
https://groups.google.com/d/optout<https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_d_optout&d=DwMFaQ&c=l45AxH-kUV29SRQusp9vYR0n1GycN4_2jInuKy6zbqQ&r=vpk0PyJh43xdqA62BEUOuvjPHYG0pBgqw__VMfJafi0&m=ZEZaa-skfkF-L5JviLr4O4tAnPjHR22F9XzC7yCRh4Y&s=Gt-frJtCp9IAYwj6jzDyAYlOIKKmJLMnG4ZyE6ovwY4&e=>.
--
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].
For more options, visit https://groups.google.com/d/optout.
