Search results

  1. B

    Problem with dynamic temp-table. Exceeding temp-table limit 32762

    Hi all. I have a program that is called from an appserver routine. It fetches data from multiple tables (specified by user) and returned data as xml to a .net program. I have recently received an error that number of active temp-tables have reached a limit 32762. Am i not deleting objects...
  2. B

    Fill a temp-table using sql statement. Is it possible

    Hi all Quick question. I am working on a c#/appserver "GetRecords" test project Is it possible to fill a temp-table using sql-select statement (that i pass in as parameter ? For instance: def temp-table tt like customer. select * from customer where c-name like 'Nor%'. create tt...
  3. B

    Question Progress Application Server

    Hi all So I have been reading this "Progress - keys to success pasoe.pdf" which says that progress application server is the way to go. We currently use both odbc and classic appserver in our .NET solution. I would like to explore the new progress application server, but I can't find out what...
  4. B

    Question Linked Server Sql - Get Sequence Value

    Hi all We have an external program that inserts data into one of our progress database. They have set up linked server within Microsoft sql-server. Today we can connect and insert records into the progress database (10.2b). But we would like to take use of a sequence that is defined in our...
  5. B

    Question Read File (img) Binary

    Hi all I have a problem that mr. Google can't help me with. I am trying to print a label on a zebra labelwriter with a logo (image in pcx file format). According to epl2 programming guide i must send imange as "Raw binary data without graphic file formatting. Data must be in bytes" How do i...
  6. B

    Question Connect to progress from BizTalk

    Hi all Is it possible to send messages from a BizTalk Server (version 2013 R2) to an Progress AppServer (Progress version 10.2B) over a TCP/IP connection? Is it possible to use IP and port to connect to the AppServer? We have a BizTalk server on a windows platform, and the AppServer is on a...
  7. B

    Question Index on datetime fields ?

    Hi all I have a rather large table that and i want to use as many indexes i can in order to get performance. I have the following indexes: -iClosecode -iGroupName -iFromDateTime -iToDateTime if i use: def var dtStart as datetime no-undo. def var dtEnd as datetime no-undo. assign dtStart =...
  8. B

    Answered For each using only lookup = no index

    Hi all We have a rather complex search site that searches in multiple tables. The query for this search is buildt up dynamiclly, then executed and the result is returned to a .NET site as xml. (I use appserver for calling the search and returning the search result). Sometimes a user creates a...
  9. B

    Resolved smtpMail and creating email

    Hi guys I am trying to get smtpMail to create and send me a email with text in multiple columns/formatted text. I do not want my "text" in a attachment. I am simply trying to fill out body in a email This works fine if all text start from left, but if i try to build up text in 2 columns the...
  10. B

    Resolved Building and populating dynamic temp-table.

    Hi all. I need some help. I will try to explain my problem. I am building up a dynamic temp-table and populating it from a query before i export this temp-table as xml over to my .NET application. Building the temp-table is ok, but upon filling it with data i have come across a problem. On a...
  11. B

    Question Progress Developer Studio 11.2 - slow ?

    Hi guys. Just installed version 11.2 and are setting up a Progress Developer Studio project for our procedures. I am using "linked folders" the same way i have used other version of OpenEdge Architect. But this new 11.2 version is soo slow and slugish. Many of these operations during save...
  12. B

    Error Slow function gave error

    Hi all We tried to change a function yesterday which resulted in loop and serious problem for our database. Thought i share the function with you and see if you can spot any problems with it. The scenario is very easy. Create a new record and assign a counter (which is our primary key for...
  13. B

    Question Memory leak on appserver

    Hi guys We are having some problems with our appservers. They are running out of memory and i suspect my new "search" is the reason. I have written a small exampel to demonstrate how i search for records. My new Appserver search is called from .NET and looks like this. (just a small...
  14. B

    Error Use functions in for each statement

    Hi all Something strange here. Is this a progress bug or a limitation. I am having problem using call to functions within a for statment. Using 10.2b at the moment. Is this a bug in Progress ? function GetRecId returns recid (input cSpotype as char, input...
  15. B

    Answered Create and pass temp-table dynamically

    Hi all I have a big problem that i can't find a solution to. We use .NET as frontend and appserver to get data from db. To get this to work both DataTable in .NET and temp-table on appserver has to be defined identical. I would like to know if it is possible to create this temp-table...
  16. B

    Write-Xml - small problem

    Hi guys I am testing out write-xml method and have a problem with naming the nodes. The simple test-program: def temp-table tt xml-node-name "entries" field tf1 as char field tf2 as int. def var a as logical no-undo. create tt. assign tt.tf1 = 'test' tt.tf2 = 123. create...
  17. B

    Performance differences in static and dynamic queries ??

    Hi all. I am having some speed problems when creating queries with 'OR' inside it. first some background info. I am searching in a table with many records(over 2 mill) that has many columns (over 50) and of course many indexes. To be able to reproduse this slow performace i have written...
Top