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...
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...
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...
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...
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...
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...
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 =...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.