?
Solved

SQL Error when creating a view in progress

Posted on 2009-02-17
2
Medium Priority
?
1,407 Views
Last Modified: 2013-12-25
I am trying to create the following view in proggress :

create view pub.binqtys as
select pub.partbin.partnum, sum(pub.partbin.onhandqty) as sumqty
from pub.partbin group by
partnum;
COMMIT;

And i receive the following error:

result:

=== START Tue Feb 17 16:56:12 GMT 2009 ===
create view pub.binqtys as
select pub.partbin.partnum, sum(pub.partbin.onhandqty) as sumqty from pub.partbin group by partnum;

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20074
[DataDirect][OpenEdge JDBC Driver][OpenEdge] View column list must be specified as expressions are given (7579)
=== END Tue Feb 17 16:56:12 GMT 2009  Processing time = 0.031 secs ===

=== START Tue Feb 17 16:56:12 GMT 2009 ===
COMMIT;

=== END Tue Feb 17 16:56:12 GMT 2009  Processing time = 0.000 secs ===

=== SUMMARY: SQLStatements =2.  Errors = 1.  Warnings = 0.===


Thanks



0
Comment
Question by:ross13
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 23675655
what about this:
create view pub.binqtys (partnum, sumqty)
as
select pub.partbin.partnum 
   , sum(pub.partbin.onhandqty) 
from pub.partbin 
group by pub.partbin.partnum;

Open in new window

0
 

Author Closing Comment

by:ross13
ID: 31547973
Thanks
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Suggested Courses
Course of the Month13 days, 19 hours left to enroll

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question