Search results

>[Error] Script lines: 1-1 -------------------------- [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Number of open cursors exceeds limit (7612)  [Executed: 5/26/06 2:17:25 PM EDT ] [Execution: 0/ms] I get the above error upon running my stored procedure for the 17th time. (the first 16...

You're going to think i'm crazy, but the eclipse/architect editor is acting really strange. It's exhibiting the following behavior: Hitting enter at the end of a line does not trigger a new line - instead it does nothing. pressing the dot key results in no dot being inserted - instead it does...

I'm just starting out with the Enterprise Architect using Eclipse. I'm wondering how to activate the feature where the editor will type-ahead certain things. For instance list the fields of a table as you type the table name followed by a dot. I think Microsoft calls it intellisense, not sure...

The SQL Explorer tool is gone as of 10.1a. As far as I can tell, we need to create a new ODBC DSN for each different database we want to connect to. All gripes aside, I know it's still possible to run SQL queries against the DB, it just has to be done through a third-party application...

So far I've done all of my Progress/Java experimenting in the SQL explorer tool. It's getting to the point now where I need a real development IDE. I could copy my code out into my .net IDE, but that would be cumbersome as I make small changes, compile, fix things, make more changes... Which...

I would like to create my first stored procedure, so I have created what I think is an extremely simple (so it should work, right?) procedure that does basically nothing. My Query (executed through SQL Explorer tool) create procedure MyFirstProcedure () BEGIN string strHello = new String...

Say for simplicity that we have two tables. One table is called shoes. It contains an index field and a description field. Next, say we have a table called people. In the People table, there are two columns - one for work shoes, and the other for leisure shoes. We store the index of the shoe...

We're trying to delete "all items in the database that don't have a UPC associated with them". Our primary key is "item#" and the tables are PUB.item and PUB.upc. items are in the item table, and upcs are in the upc table. each UPC has an item number associated to it in the "item#" field. I...

I've created a Crystal report to chart sales totals by date and by store from a large Progress database. In Crystal the data looks great, I'm using SQL expressions to parse out discrete values from extented fields using pro_element() ... However in my application, when I run the report I...