Search results

Why am I not allowed to concatinate strings in a WHERE clause? Is this not possible? SELECT i."Inventory-Item-ID", i."Inventory-Item-Desc", 'Works' + 'Fine' + 'Here' FROM PUB."InventoryItem" AS i WHERE i."System-ID"='PP' AND i."Cust-ID"='4601' AND...

To answer your question about whether or not you can use "JOIN in a query", the answer is yes. Since you're new to Progress, I would suggest going over the sql92 documentation for your particular version (http://communities.progress.com/pcom/docs/DOC-16074). I'd also recommend using a tool...

I am able to create the basic "Hello World" Stored Procedure just fine. The problem is when I try to call it. This is what I've done. Created Table @echo true; @autocommit true; CREATE TABLE PUB.HelloWorld( fld1 char(20) ); COMMIT WORK; Created Stored Procedure @echo true...