web stats
User Defined tables... - Mirth Community

Go Back   Mirth Community > Mirth Connect > Development

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2012, 08:44 AM
lyp lyp is offline
Mirth Newb
 
Join Date: Jul 2012
Posts: 13
lyp is on a distinguished road
Default User Defined tables...

I am trying to setup a User Defined Tables type environment. Has anyone tried and had luck with this before? Thanks
Reply With Quote
  #2  
Old 07-09-2012, 09:26 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,209
cory_cole is on a distinguished road
Default

Quickest and easiest way, most SQL Databases have some type of GUI interface that will contain the table create script for any given table. Cut and paste that script into a SQL window. Then alter it to match table name/field names/ field types you need.
Reply With Quote
  #3  
Old 07-09-2012, 10:02 AM
lyp lyp is offline
Mirth Newb
 
Join Date: Jul 2012
Posts: 13
lyp is on a distinguished road
Default

Cory,

I am trying to create/populate a UDT whenever a new message is received. from the UDT, I will run stored procedures to populate several tables. I've looked online and do not see too much information on JAVA UDTs. Have you seen any attemps of this using Mirth? Thanks
Reply With Quote
  #4  
Old 07-09-2012, 10:12 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,209
cory_cole is on a distinguished road
Default

go here and put UDT in the search.

http://www.mirthcorp.com/community/fisheye/browse/Mirth
Reply With Quote
  #5  
Old 07-09-2012, 10:24 AM
lyp lyp is offline
Mirth Newb
 
Join Date: Jul 2012
Posts: 13
lyp is on a distinguished road
Default

Don't know if I am using it right but didn't find anything on UDT.
Reply With Quote
  #6  
Old 07-09-2012, 10:34 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,209
cory_cole is on a distinguished road
Default

http://www.mirthcorp.com/community/f...T&t=2&project=
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 09:52 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation