Search results

I thing i got it. I had: hb::buffer-field(bb.field-name):buffer-value = "yoohoo". just removed the one ":" to hb:buffer-field(bb.field-name):buffer-value = "yoohoo". It works :-) One more question. Are these 2 example the same: hb::Field1 = "SomeValue" or...

No this don't help. I get following error: "BUFFER-FIELD buffer-field was not found in buffer tt." and then "Lead attributes in a chained-attribute expression (a:b:c) must be type HANDLE or a user-defined type and valid (not UNKNOWN). (10068)" Try to run this example: /*temp-table with one...

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

I created a new project and added all my linked folders on server as "Linked folders". This works very ok in both 10.1a and 10.2b. But is very sluggish on 11.2

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

I agree. Sequence are better, but should't it work in the example ?

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

I thing i have found it. It was another program that where missing a delete object. :mad:

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

Ok. Just have to live with it then :-) Tom: Your last code is very similar to my last example, where i use find, but even that don't work :-) So, no worries. If this is bad practice i just have to get used to always use variables in for first, for each. Thank you for all help.

First, thank you for helping me. I have gotten this to work, but i don't understand why it is not working. Maybe bad practice but it should work. I have rewritten my exampel to use find table with recid and it still don't work: function GetRecId returns recid (): def var r as recid...

Ok, I did not specify how "oldSpotype" was defined, it is a normal string with some value, but i don't think it is vital to my exampel. Neither is how i use Find first. My main problem is that i can not use a user-defined function in a where clause. Maybe it is bad practice in progress, but it...

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

Thanks. I think i found a solution. Insted of returning a proDataTable or ProDataSet i just return the xml with the search result. Builing a temp-table dynamically and use the write-xml method. Seems to work :-)

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

Yes, this is possible. All our odbc-connections are connected to 2 databases at the same time (database "master" is always available. First the connection string like this: connectionString="Driver={Progress OpenEdge 10.1B...

Thanks for the reply Since this is a search program i thought it would be smart to start searching from the newest record and backwards (i leave at 250 recs), since this is probably the record the user is interested in. If i rewrite and uses get-first - get-next it speeds up. Hmmmmm. Can...

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