On Tue, Apr 13, 2010 at 3:00 PM, John Harvey <[email protected]> wrote: > Maybe I'm missing something, but it seems to me you are just creating a > lookup table from the selected records, which will be used to pull from the > JMS charges table. Is that correct? ------------------------
Yes and no. I have to present to the user All potential charges that they can identify for inclusion in a sex offender report or methlab/abuse type of report. Not sure who gets the report but then not my need to know. In the end I expect to have a list of say 12-50 IDs that I have to pass to a SC java Web Service. They will give me collection of who was charged with any of the codes I presented between a set of dates. eLogs is the consumer of this. Over time I will be getting a few more "types" of report requests that my app will have to roll with. From my current design I am pretty sure I have most bases covered. I am just looking at this IDs table that is joined to a bastardized version of CJ02 that I have in SQL. I join the two tables to identify any codes in an earlier run at this task. Currently I have to remove the ones that were checked and now UNCHECKED when I present the object back to my WCF. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
