Search results

Well in my opinion these things DO make a language more superior. When you cannot work with dynamic arrays and multipe dimentional arrays, when in other languages you have a "bunch" of functions for working with strings, arrays, objects, xml's etc... Anyway I just worked with Progress for the...

:( ... that's a pity. I can't understand why it's not public...

I looked in a lot of manuals but I didn't find the sintax for thing like: ADD INDEX "Kunden-Num" ON "KunBonusKartenUmsatz" AREA "Indexarea" PRIMARY DESCRIPTION "Index nach Kunden-Num" INDEX-FIELD "Kunden-Num" ASCENDING ADD INDEX "Auftrag" ON "KunBonusKartenUmsatz" AREA...

Hi, Where can I find a doc with the complete syntax for database structures. I looked in every Database Admin pdf from psdn.com but couldn't find any references. I'm looking for specs for commands like: create table add field create sequence create index drop ... etc. Thanks in advance.

Just an observation: If I make a proutil dbname -C idxbuild after that it seems to works fine. At least the connection runs faster. Does that have an explication?

Hi, I made a dump (backup) from a database and restored it on an another computer. The dump file has about 6GB. I copied the .st file from the original DB and made the restore. Everything runed ok. The problem is that every time I connect myself to this DB takes a lot of time (around 20...

I have to fill it with about 60000 rows. The Programm is already written, but the performance is really really bad so I have to rewrite it. But i think that the main problem is not only the temp table, ... in the old programm for every row that is written in the temp table there are about 10...

I noticed that Temp Tables are heavily used... but when filled with lots of data they run real slow. Now I want to ask some performance issues: 1. are they only created in the memory? 2. are they running on the server or on the local machine (where the software is running)... at this I think...

Don't get me wrong, I don't want to debate about how bad Progress is. I just say that there are functionality leaks. All these are based on my observations in these 3 months. Specific problems(probably for this we should make an other thread that others can find that too): - Simple commands...

Yes because to make an ERP ... you need some years of development. All the running ERP systems started in the 90's or maybe start of 2000 and they were developed then. If you would start now to develop an ERP would what would you choose? OK.. now this is my experience so far: Well ...

Hi, I have more frames and I have to run the same procedure on all of these frames. So I want to specify the frame handle or frame name as a parameter to this procedure. Untill here everything is clear. How do I access the frame in the procedure? I tried this: .. procedure ... DEFINE...

This is maybe off topic and I don't want to hurt nobody's feelings, but if there is still a "question" of using OO or not to use OO... I feel sorry for the progress "mass". I come from Visual C, .Net and PHP field, I developed web and desktop applications and honestly I feel like jumping back...

What do you really understand by data access layer? From what I noticed, there is the application and the database. In progress there are "somehow" more or less related. But the same DB can be used by more apps. Anyway, I would like to guarantee the data consistency through the...

Thanks for the infos. I will give it a try.

Is it possible to say for a DB field to say: default value = NEXT-Value(Sequence)? Will this work? I don't want to control sequence value from the application, just from the DB. Andy.

Hi to all, I am new to progress and I have some questions to which I dind't find the answer yet: 1. How can I assign a sequence to a table field automatically? Like an autoincrement or serial or sequence(that's how they are called in other DB's). 2. How do I make a foreign key?(or a...