Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Execute Create View code in Actian Zen?

Status
Not open for further replies.

dgillz

Instructor
Mar 2, 2001
10,038
US
Its been 15 years since I worked with Pervasive SQL. I want to create a view. Here is my code to do so:

Code:
CREATE VIEW "ItemBeginningBalance" AS
select i.ItemID,i.ItemDescription, sum(c.quantity) as BegBal
from LineItem i
left outer join InventoryCosts c on c.ItemRecNumber=i.ItemRecordNumber
where c.TransDate<'2023-01-01' and c.RecordType<>50
Group By i.ItemID, I.ItemDescription

How the heck to I execute this in Action Control Center? Or am using the wrong tool?

Macola and SAP Business One Consultant
Check out our Macola tools:
 
When using the Control Center (since v9) there have been three buttons. They are "execute into text", "execute into grid", and "execute all" (I think). In the picture below they are disabled but are the three next to the red arrow. They are enabled after you click the Execute SQL Commands link in the Welcome tab then select the machine where the database engine is running and then Database name. That should open a SqlDoc1 (or some other number) tab where you put the SQL code. The buttons should be enabled at that point. There are also keyboard shortcuts F9 will execute into grid, Shift+F9 will execute to text, and F10 will execute all statements.
javapcc_pcc_xigiyu.png


Mirtheil
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top