You should be able to change the data type to vMarkets.
Then it will ask you for the display field.

In the data type selector window, there are no listings for a data type called vMarkets.  I have conencted the SelectCommand objects to the form builder as well.

I probably wasn't clear.  The data type will be whatever the default name for the output for the select command thing is.
I'm assumming its somethingsomethingResult.  Look for that in the list.
Once you find that you will be able to select the vmarkets variable.

OK, I got the data type working now, but after that's selected, when I go to choose Items, I can't seem to get anything to work...nothing's coming up under process variables, and mappings don't seem to make sense...how do I populate the checkbox items with the data that will pull from the query once the data type is correctly assigned?

Wait, actually, I didn't find the data type (was lookign at a residual library that I had loaded).  Take a look at the screenshot.  The types are not getting pushed through.

Thanks

Ok I tested that control.  It seems to be a more difficult way to get a list from a database.
I would vote for you creating an integration library that does the same thing.  The data types and usage
of the integration library would be easier to use.

From what I can tell you would need 3 integration libraries GetMarkes, GetQueues and GetSelMarkets.
Tying those to a control would be alot easier.

That's the problem...I can't get teh integration libraries to work with Oracle.  I have another forum post from a few days ago about this.  I can create the integration library using the same query and conn string that are working in the SelectCommand component and when it runs, the debugger spits out a "ORA-00942: table or view does not exist" error.  I know this is a bug in the integration library, as the query works perfectly in every other component, so I'm kinda stuck.

If you have access to Microsoft Access, can you create linked tables to the oracle database then attach your project to the access database instead.  Its cludgy but may work around the bug temporarily.

Hi Dalceon,
  Send me your email address and we'll setup a GotoMeeting.

Regards,
Shawn Turnbow
Systems Engineering Specialist - Workflow
Symantec Corporation
www.symantec.com

Correction... DrGonzo65

Send me your email address and we'll setup a GotoMeeting.

Regards,
Shawn Turnbow
Systems Engineering Specialist - Workflow
Symantec Corporation
www.symantec.com

I think DrGonzo has resolved his problem in the original thread; it was incorrect conection info, I believe

Yes I got everything working by using the integration libraries as noted in my other thread.  Thanks for all the help