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:image004.jpg@01D38EC2.6B1208E0]
Error when attempting to "Save Query as Table":
[cid:image002.png@01D38EC1.5C2D2090]
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
---
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
