How to Execute Create View code in Actian Zen?

[dgillz]

Its been 15 years since I worked with Pervasive SQL. I want to create a view. Here is my code to do so:

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:

http://www.gainfocus.biz/exceladdin.html

 

[mirtheil]

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.

Mirtheil

http://www.mirtheil.com