RE: [RBASE-L] - Error using View to create new table

2018-01-16 Thread John Murnane 
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:rbase-l@googlegroups.com]
Sent: Tuesday, January 16, 2018 12:19 PM
To: rbase-l@googlegroups.com
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 >
To: rbase-l >
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:image001.jpg@01D38ED2.3A144680]

Error when attempting to “Save Query as Table”:

[cid:image002.png@01D38ED2.3A144680]
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.
--
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.

-- 
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

Re: [RBASE-L] - Error using View to create new table

2018-01-16 Thread karentellef via RBASE-L 
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 
To: rbase-l 
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:
 

 
Error when attempting to “Save Query as Table”:
 

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.


-- 
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.

[RBASE-L] - RE: Error using View to create new table

2018-01-16 Thread Claudine Robbins 
ORDER comes after GROUP maybe…

[cid:image001.png@01D38ECB.AB9C5150]

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
John Murnane
Sent: Tuesday, January 16, 2018 1:06 PM
To: rbase-l@googlegroups.com
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:image003.jpg@01D38ECB.AB9C5150]

Error when attempting to “Save Query as Table”:

[cid:image004.png@01D38ECB.AB9C5150]
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.

-- 
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.

[RBASE-L] - Error using View to create new table

2018-01-16 Thread John Murnane 
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.