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...
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...
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...
Anyone know of any good books to get for open edge 10.2b (progress database coding books)
I get rather annoyed of having to look on the forum for answers etc I've used many good VB and C# books before to help me do stuff. Also great web resources but progress doesn’t seem to be as good I know...
realised that it must be coming from another program im running something strange in way i call otherprograms i make the currrent window = to the new program so that means the error message is most likely coming from somewhere else... oh joy
well I have these 2 procedures to try and deal with the window
/*prepareWindowForChar */
assign hanPrevWindow = current-window
intPrevWindowWidth = current-window:virtual-width-pixels
intPrevWindowHeight =...
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.