Recent content by tsp

Hi We upgraded to openedge 10.2a. We have a PUB database which we have an ODBC connection set. We can view the tables in access but when selecting we get the progress error 7512 which is do with access denied. This was working fine on previous openedge version. have dropped the tables and...

Hi Fixed the issue. We were using static temp tables but were being passed through the procedure as table-handles which when removed and using static tables it speeded it up! also in one of my loops the table-handle was being returned when it needed not be in the loop thanks for the help guys...

hi its passing the table once populated back to the client side. The client side program accepts the table as table handle. all creates are defintely done on appserver side

DEFINE TEMP-TABLE ttConflictMatter NO-UNDO FIELD cCode AS CHARACTER FORMAT "x(20)":U FIELD cDescription AS CHARACTER FORMAT "x(25)":U FIELD cRelationship AS CHARACTER FORMAT "x(20)":U FIELD cConflict AS CHARACTER FORMAT "x(20)":U...

hi thanks for reply. we running openedge 10.1c on windows xp

heres the code nothing different of how this is created as it is similar in other parts of the system. If the records are say 500 then its is very quick! but struggling with such high number of records FOR FIRST pdm_client FIELDS (pdm_client.client_obj) WHERE pdm_client.organisation_obj =...

hi Thanks -BT is currently set to 5120 i have increased it to 40000 but made no difference it also has indexes on the table In regards to the .dbi files. I have some in my temp table which are 32kb what does that mean? cheers

Hi I have a temp table that is being populated with around 3000 records. The speed is fine when populating at the beginning but as the table gets bigger its performance is degrading. I have found this out by outputting to a file and checking etime what things can i do to improve this...

hi Its taking much longer than looping through the actual temp table where it creates it. there is about 3000 records i outputted the results to a file

Hi I have a temp table which is being passed through and the procedure is accepting it as a table handle. But when looping through the table it is taking a very long time. I have indexes on the temp table that is being passed in but not sure what else i can try to check if indexes are being...

cheers for reply i had the wrong com-handle at the beginning and should have been the handle to worksheet working great now :biggrin:

Hi I am trying to get a page break set in excel. I have a handle to the range which is only 1 row. But does not do anything here is my line chRange:hPageBreaks:ADD(chRange) NO-ERROR. any ideas? cheers tj

brillant cheers for that will give it a go thanks again

Hi I am trying to solve an issue in regards to outputting to excel. I have a list of numbers which need to relate to a column. Example 1 - column a 2-column b..... 27- column AA When the number gets over 27 it needs to start to assign to columns AA etc.... cheers

Hi I have a window with a treeview. i can expand a node and then right click to refresh the treeview to bring the relevant data binded to the item clicked. As i do this further i then get the error message: -nb exceeded. Automatically increasing from <old value> to <new value>. (5407) this...