Search results

Thanks Gavend. I'll give NO-UNDO a try. I always use it normally... can't think why I didn't do it this time :confused: I'll also try clearing the TT out manually before closing the program down... The TT isn't shared... the program that gets called by the web service client checks that the...

Hi RealHeavyDude, No, they were just created in the procedure editor. Example: define temp-table ttBranches serialize-name "BranchList" field branchID as integer serialize-name 'branchID' field branchName as character format 'x(24)' serialize-name 'branchName'...

Mate, did any of this advice solve the problem for you? I have error 12296 as well. Running 10.2b05 and Tomcat 6 together on a Linux box, trying to call a 4GL routine on a state-free Appserver via the web services adapter. The program runs fine from the procedure editor but when I run it...

Hi all, I've never bothered to learn Smartobjects but recently I've been thinking about it, just to add another string to my bow. However, chatting to people I get the impression that they're in decline and that very little - if any - new development is being done with them. One guy suggested...

Hi all, Are 10.1B database backups (created with the probkup utility) compatible across platforms at all? I'll have a bucket-load of databases to move from Tru64 to AIX in the near future, and I'm trying to work out the easiest way to do it. If I can avoid a dump-and-load exercise by simply...

It looks like your problem might be with a bit of the program that you didn't show us; the COMMIT statement. Does the program generate any errors if you try it without the COMMIT? It might just be that you're not terminating one of your statements properly...

Yeah, there's not much Progress info out there...

That's right - it doesn't use a network port, and it only accepts local connections. You have two choices: 1) Start a broker (_mprosrv) for it and make a multi-user connection. 2) Do not start a broker. Make a single-user (-1) connection. I'm not sure if you can do this in 8.1, but in later...

I assume you've already checked that the database HAS been started i.e. there is a broker (_mprosrv) process running for it?

I would have thought it was impossible. To my knowledge, Progress's PROBKUP is the only utility that can perform incremental backups of a Progress DB, and you typically start it from the command line or an OS script. I suppose you can get VB to run OS commands, but there isn't any kind of VB API...

Hi, Does your ORDER BY clause reflect the indexes on the tables? It's one thing to have indexes on all the columns in your search criteria, but if the sort order is something totally different to the order in which the data is initially returned from the database then you could see a big...

Hi all, In Oracle DDL, you can define a length for each VARCHAR2 column either in bytes or characters. I don't currently specify either (just a length), so Oracle is using the default, which is bytes. I want to switch to specifying everything in characters to minimise i18n issues, and I...

In case it helps anyone... it turned out to be a problem with the "foreign owner" column in the _file and _sequence records. In the tables and sequences that were causing me problems, this column contained the unknown value, and should have contained the name of the user who owns the schema...

Hi all, This is my first post to Progress Talk... now that the PEG has started charging! When I pull an Oracle schema into a schema holder using the Dataserver "update/add table definitions" utility, I find that it creates duplicates of some of the objects in the schema. I might get a...

Who are you connecting as when you execute the query? It's a while since I've done it, but I seem to remember that doing it as sysprogress is the easiest way. You can grant the necessary permissions to other users, but if memory serves, I typically connected as sysprogress and everything seemed...

Assuming the lock table is the one in the Progress database itself, as opposed to some internal ODBC structure, it's a parameter that you set when you start the broker process (_mprosrv / proserve) for the database. Take a look at the database startup script and see if there is a value specified...