- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Writing back to the ODBC Source in a VI import job
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-04-2010 09:30 AM
Hi all.
We have an import job that uses a SQL table as it's data source. The table contains 3 fields: SalesOrderNumber, OrderStatus and Imported. The VI job updates the OrderStatus for the SalesOrderNumbers in the table.
I want to be able to update the Imported field whenever the VI job updates the OrderStatus for each record. I was thinking this would occur in the OrderStatus field --> Perform button--> Perform On: A - After Assign
But I have no idea how I can do this. Would this be through a batch file? If so, does anyone have any examples on how I can do this?
Thank you in advance!
Re: Writing back to the ODBC Source in a VI import job
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-04-2010 09:34 AM
I believe you can do this via business objects interface quite easily.
Dawn
Re: Writing back to the ODBC Source in a VI import job
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-04-2010 10:34 AM
Thanks for the reply Dawn.
Is BOI available directly in MAS or do I need to contact a business partner?
Re: Writing back to the ODBC Source in a VI import job
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-04-2010 12:56 PM
If you are on version 4.30 or higher, it's built right into the product. If you are on version 4.40, then the object reference is built right into the file layouts guide.
Dawn
Re: Writing back to the ODBC Source in a VI import job
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-04-2010 01:00 PM
Oh ok. We're on v4.05, so we'll have to wait until we upgrade.
Thanks!
Re: Writing back to the ODBC Source in a VI import job
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
08-04-2010 02:26 PM
There use to be a way to do this. The legandry Slade use to have this posted on a web page. Maybe one of the old timers on here saved the info and can help out.
--------------------------------------------------------------------------
You have enemies? Good. That means you've stood up for something in your life.


