ORDER comes after GROUP maybe… [cid:[email protected]]
From: [email protected] [mailto:[email protected]] On Behalf Of John Murnane Sent: Tuesday, January 16, 2018 1:06 PM To: [email protected] 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 --- 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. -- 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.
