Thanks Jose.
I am attempting to create a BPM for Report Data Definitions that will automatically exclude all the fields in a table that was just added.
I was attempting to pull a row from the table to then iterate through all the columns but where I won’t know the table ahead of time, I would need this ability.
I just finished it using a SqlDataAdapter but I would like to know if this approach would work too.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:c60dc9.png@8975cf58.4cb42f0c]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 29, 2015 2:33 PM
To: Vantage
Subject: Re: [Vantage] E10: Method directive: Specify table in ErpContext at runtime
You can use Reflection for that... may I ask what you are doing?
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>
Quis custodiet ipsos custodes?
I am attempting to create a BPM for Report Data Definitions that will automatically exclude all the fields in a table that was just added.
I was attempting to pull a row from the table to then iterate through all the columns but where I won’t know the table ahead of time, I would need this ability.
I just finished it using a SqlDataAdapter but I would like to know if this approach would work too.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:c60dc9.png@8975cf58.4cb42f0c]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, April 29, 2015 2:33 PM
To: Vantage
Subject: Re: [Vantage] E10: Method directive: Specify table in ErpContext at runtime
You can use Reflection for that... may I ask what you are doing?
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>
Quis custodiet ipsos custodes?
On Wed, Apr 29, 2015 at 2:12 PM, Joe Rojas jrojas@...<mailto:jrojas@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:
Hello,
I want to be able to access a table in the database through the ErpContext, Db, at run time.
Meaning, I don’t know which table I want at the time of coding the method directive.
I tried Db[variableName] but got an error saying that indexing is not allowed on ErpContext.
Any ideas on how to do this or if this is possible?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291> | cell: 781-408-9278<tel:781-408-9278> | fax: 781-232-5191<tel:781-232-5191>
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:e84e9d.png@94edd592.4abf2f76]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
