B
bstaunton
Guest
Hi, So at the moment I have the code CREATE QUERY queryh. queryh:SET-BUFFERS(bufferh, cbufferh). queryh:QUERY-PREPARE(SUBSTITUTE("FOR EACH &1, EACH &2", tableh:NAME , ctableh:NAME)). queryh:QUERY-OPEN(). tableh:TRACKING-CHANGES = TRUE. DO WHILE queryh:GET-NEXT() ON ERROR UNDO, THROW: bufferh:BUFFER-COPY(cbufferh). END. tableh:TRACKING-CHANGES = FALSE. The problem is that I want the first record of the bufferh buffer to copy the first record of the cbufferh buffer then the second of the second and etc. Problem is FOR EACH bufferh, EACH cbufferh: copies the first record of the bufferh buffer to copy the first record of the cbufferh buffer but then the first of the second (or vice-versa, I'm not sure). I think to solve this I need to join the tables but I'm unsure how to do this with dynamic tables. If it helps the two tables, regardless of what I feed in, will always have the same fields and primary and unique indexes. Thanks.
Continue reading...
Continue reading...