So I have an app where I do this. How I do it is I loop over query-A and
use queryaddrow and querysetcell to add the data to query-B. In this
way, you can map the columns easily from one query to the next and still
use it as a query object. There may be advantages to just combining the
two in a structure, but this is what first came to my mind when I was
working on it and I find that it works well for me.

-Ferg



  _____  

hello all...
if you wanted to take two queries, with like columns, and data that
needed to be merged, what would you do?

1. turn the query record set into a structure, and find the matching
keys, and merge the data?
2. turn the query record set into an array and do the same kinda thing?
3. or some other way?

just wondering.  im leaning towards making it a structure, and
manipulating that way.
later.
--
tony

Tony Weeg
human.
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to