Recent content by jmac12

Cheers RHD, Moving when I added the columns did the trick. I add them before I do any query on the data. So i have browse with no data but columns then just run the query and bobs ur Uncle for some reason i thought you had to add the columns each time to get the data to be displayed but I...

any one come up with anything for this?

have a look at the FIRST-OF( ) method for query objects

I agree training has its place. Its just the lack of documentation on progress (or at least its style) doesn’t help. I've used many good books and online resources for VB/C# etc in the past to do what I need to do. but thats just my 2 cents

I’m afraid its the same old story with progress... the help not that helpful or a least thats my Experience so wanted to code well feels like a very hard slog

yeah RHD is correct I've trying to do kind of the same thing of you http://www.progresstalk.com/showthread.php?117503-Dynamic-temp-table-to-a-static-temptable theres that post and ive done another so just look for my posts JMAC12 hopeful help you. I'm still trying to get what i want out of them

hi maximMonin, im getting the following error when im trying that code: browse requires the Query to be DEFINEd SCROLLING (3330). hi mosfin yes i could add where stuff.. but not doing that quite yet my main question is y is it slower than just doing a normal for each grades no-lock then...

I've got the following code (open edge 10.2b): chrQuery = "FOR EACH " + chrMyTable. do with frame {&frame-name}: create query hQuery. hQuery:set-buffers(hTempTable). hQuery:query-prepare(chrQuery). hQuery:query-open()...

heres a list of books I still have got any yet Im tempted to try Making good progress but its $160 so im a bit worried if i get it and it doesnt really tell me anything... any one brought it? BravePoint Progress Performance Tuning Guide (Foreman) Progress Database Administration Guide...

I've done the following: chrQuery = "FOR EACH " + chrMyTable. do with frame {&frame-name}: create query hQuery. hQuery:set-buffers(hTempTable). hQuery:query-prepare(chrQuery). hQuery:query-open(). hQuery:get-first()...

yeah ur prob right mate... I guess i could just go round colums of the browse which is better than my idea..and then i guess i wouldnt need the static table after all.. cause just apply the query to browse. the thing i was struggling with was getting the data ive got in the buffer out into the...

cheers for the help but im still struggling with it. maximMonin what im trying to do is have some code that just does a query on table X thus the chrMytable so this can be generic. The reason I’m using a static temp table in a browse is that the labels are incorrect from the database so need...

just trying to understand ur code? dont see how the dynamic table is passing anything to the static one? create temp-table DocumentData. /*create the temp table fine*/ I could do it like this: hTableLike = BUFFER ttRecs:HANDLE. create temp-table hTempTable...

Hi I'm using open edge 10.2b I have a program thats got a browse that displays a temp table ttRecs. In this instance it’s defined like a database table grades. I want to use a dynamic query/temp table to get all the grades records (to start with) and then display them in a browse. Now the...

cheers not been on PEG is ages every since the search function on there went south