Search results

  1. K

    Database Documentation?

    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.
  2. K

    6GB DB Restore, Connection very very slow

    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...
  3. K

    Temp Table Performance

    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...
  4. K

    Dynamic Frame, Frame as Parameter

    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...
  5. K

    Some practical questions, tehniques

    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...
Top