P
Peter Judge
Guest
Nothing obvious. The datatype conversion is causing the AVM problems. I got some data by doing having the same data-relation you have in the last example define dataset debtors for tmp-debtor, tmp-stexob data-relation for tmp-debtor, tmp-stexob relation-fields ( stexob_key_value, key_value ) . And I changed the before-fill-stexob procedure to procedure before-fill-stexob: define input parameter dataset for debtors. data-source dsstexob:fill-where-string = "where stexob.key_value = " + quoter( tmp-debtor.debtor ). message 'before-fill-stexob' skip tmp-debtor.debtor data-source dsstexob:query
repare-string view-as alert-box. end procedure. and all the data was loaded: one two Note that it is NOT nested. If you add the NESTED qualifier to the DATA-RELATION statement you will see errors along the lines of Failed to auto-prepare an automatic fill query. (11981) This is because the field types are mismatched (I suspect).
Continue reading...
repare-string view-as alert-box. end procedure. and all the data was loaded: one two Note that it is NOT nested. If you add the NESTED qualifier to the DATA-RELATION statement you will see errors along the lines of Failed to auto-prepare an automatic fill query. (11981) This is because the field types are mismatched (I suspect).Continue reading...