Search results

To Tom We do not upgrade, because, we're moving our application away from Progress :( The most vital parts of our application is build using C and sql89/C. Progress does not support embedded SQL in version 10 (instead they promote using ODBC). The performance of the SQL92 interface is not nearly...

Hi Tom! I'll try to explain my situation. We're building Dispatching systems for Taxi-Company's. Trips are being booked into the system by operators, internet, batch systems and the like. The number of bookings per day can be several thousand. For every booking a number of cars a being tested...

Hi Joey! Thanks for the reply m8. I've read the PEG discussion, and also received a reply from Progress support, which basically said "apart from using DO WHILE, we don't have any information to give you...". The details about how 4GL works in this situation, is not given by Progress...

Running Progress version 9.1D on Linux RedHat. We're starting to get the following error: "Limit of repeat/undo units per session reached. (9456)" The problem occurs in a persistent procedure running on an Appserver. This procedure is used to poll the database for changes. Within the procedure...

Hi! You're out of luck here, because sql92 triggers do NOT fire if you update the database from 4GL, and vice versa. You have to comminucate in some other way (sockets). Kind regards Mike

I can't imagine how!! :blue: Regards Mike

Probably! Progress did not have native SQL support until version 9. Queries is working fine, but parsing the ODBC calls takes time. They're working on it. :) Regards Mike

You want to do something if data is in DB1.MyTable but not in DB2.MyTable - Am I correct? Try this: for each DB1.MyTable where .....: if not can-find( first DB2.MyTable where <Join to DB1.Mytable>) do: display "Not in DB2.MyTable". end. end. can-find is faster, beacuse...

Hi All - Thanks for your answers! :) I've looked into the matter my self, and found out a lot of things. First of all - The ODBC server (Not Open Interface, but SQL-92 ODBC server) DOES NOT WORK until 9.1C - Progress told me this. The query optimizer and the server is buggy. 9.1C...

Hi! We've developed an application in java, using appservers as the connection to the database. It works quite smoothly except for the stability of the appservers. Speed is acceptable. There are some overhead in calling the methods on the appserver, but by optimizing the serialize methods...

Hello Talkers Is there anybody out there - who knows about Java stored procedures? I can't understand why I get almost the same performance using ODBC from C++ and Stored Procedures. Off-loading to the server should boost performance considerably. Is there some setup I should check...

Uh!! Ehh! That's quite a mouth full :D First of all, when you call your windows persistent, they'll run simultaneously (not multithreaded - Big difference). Progress will load a persistent procedure into memory, run the main part, and return to the caller. The new procedure will respond to...

Hi Kenneth Persistent procedures will be deleted when the calling procedure ends - is this the Case? If your testing from a procedure editor, your window will flash. Try adding: wait-for "close":U of hProc. After the call. If you start Pro*Tools / Procedures You'll be able to...

Hi Kenneth! Running a window persistent is no different that any other procedure. DEF VAR hProc AS HANDLE NO-UNDO. RUN wMyWindow PERSISTENT SET hPROC. IF NOT VALID-HANDLE( hProc ) THEN DO: MESSAGE "Could not start MyWindow" VIEW-AS ALERT-BOX ERROR. END. A persistent procedure...

No! This is under windows' control! Regards Mike

Hello Peggers and Happy New Year! I have a little problem for you, so you can get those alcohol infested brains in gear again. :D I'm trying to make a procedure to calculate table/row size - basically the same as tabanalysis, but from 4GL. It works - kind of. Some tables are off by a...

Hi! Only thing I can think of is the Com-Object viewer from Pro*Tools! Have you tried this. Regards Mike

Hi Peggers! Progress 9.1A, HPUX11, Merrant ODBC-driver on NT. I've started experimenting with SQL-92/ODBC and I'm very puzzled with the performance I'm getting. I have a table a table which looks like this. trip_date as date car_number as int tke_recnr as int company_number as...

Hi Mikedestructor! How is your setup? Are you normally running your data objects from an appserver? I get the same error, if I disconnect the database, and remove the "partition" from the data object. If you're running the data objects locally, you have to have a database connection...

Hi! True! Can you quantify the performance impact? It is after all at most 128 * 8Kb each time. Our problem is uptime, the time required to create 1Gb of data extent is unacceptable for most of our clients. Regards Mike