RE: [U2] Universe/UniObjects and Visual Studio
I downloaded the tutorial and I like it so far but it seems to refer to the Wychwood Audio Books demonstration database. Where could I find this database? I can't seem to find it on www.mvopen.org/cms. Thanks, -Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe/UniObjects and Visual Studio Anthony there is a tutorial on using UniObjects with VB Express on the U2UG Knowledge Base. Check out : www.mvopen.org/cms and click the Knowledge Base link. Regards, Brian Hi guys, I am messing with Visual Basic Express edition. I was hoping to use UniObjects against my Universe Database. The examples in the UniObjects Developers Guide are a little outdated. How do I get the UniObjects to appear in the toolbar (if you can do this) ? They refer to Sub Form_Load, which I have seen in older versions of VB, but not VB 2005. Basically what I am looking for is a 'quick fix' for the 5 minute program example in the Developers Guide that has already taken me beyond that time frame. Thanks Anthony -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/UniObjects and Visual Studio
IMHO, You rock, Brian!! That did the trick. Now off to play with other new toys.. thanks so much -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, March 15, 2007 3:28 PM To: u2-users@listserver.u2ug.org Subject: Spam:RE: Spam:RE: [U2] Universe/UniObjects and Visual Studio Leslie HTH I did some poking around earlier and found that the GenerateXML actually seems to call down to a subroutine named GETXMLSUB held in the BP file of the uv account. On some 10.1 versions it is present, but not cataloged: I found when I added it to global catalog as *GETXMLSUB it worked fine for me, though I guess it's not officially supported at that release. It might be worth giving it a try. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of leslie chamberlin Sent: 15 March 2007 19:12 To: u2-users@listserver.u2ug.org Subject: RE: Spam:RE: [U2] Universe/UniObjects and Visual Studio Hello all, I worked through Brian's tutorial he mentions below and found it MUCH more helpful than anything else I have found so far. I am having one issue that I will work through shortly. The cmd.GenerateXML is not working with my test system according to the error due to my version of Universe (10.1.12). I am setting up a test environment on my laptop with 10.2 and will see if that helps. I was, however, able to create a VB program that accessed my Universe database and updated it. Success!!! Made it through page 19 of 24 and updated data with no issues and full understanding. Thanks, Brian, for shedding light on the subject. I am going to go through the knowledge base and see if there are more toys with which to play. Thanks to all who contribute to the list and the website!! -Leslie Chamberlin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/UniObjects and Visual Studio
Thanks This link was very helpful. I did finally figure it out and the examples list exactly what I ended up doing. The tutorial was excellent and put me in the right direction. This is also what I was looking for in respect to java programming. I was hoping to find a very simple data entry program to get me going. Thanks Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe/UniObjects and Visual Studio Anthony there is a tutorial on using UniObjects with VB Express on the U2UG Knowledge Base. Check out : www.mvopen.org/cms and click the Knowledge Base link. Regards, Brian Hi guys, I am messing with Visual Basic Express edition. I was hoping to use UniObjects against my Universe Database. The examples in the UniObjects Developers Guide are a little outdated. How do I get the UniObjects to appear in the toolbar (if you can do this) ? They refer to Sub Form_Load, which I have seen in older versions of VB, but not VB 2005. Basically what I am looking for is a 'quick fix' for the 5 minute program example in the Developers Guide that has already taken me beyond that time frame. Thanks Anthony -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.10/720 - Release Date: 3/12/2007 7:19 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/UniObjects and Visual Studio
Anthony there is a tutorial on using UniObjects with VB Express on the U2UG Knowledge Base. Check out : www.mvopen.org/cms and click the Knowledge Base link. Regards, Brian Hi guys, I am messing with Visual Basic Express edition. I was hoping to use UniObjects against my Universe Database. The examples in the UniObjects Developers Guide are a little outdated. How do I get the UniObjects to appear in the toolbar (if you can do this) ? They refer to Sub Form_Load, which I have seen in older versions of VB, but not VB 2005. Basically what I am looking for is a 'quick fix' for the 5 minute program example in the Developers Guide that has already taken me beyond that time frame. Thanks Anthony -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/UniObjects and Visual Studio
Hi Anthony Whilst UniObjects works with .Net, it is a COM assembly and needs to be loads as a Comm Component. IBM does provide a .Net assembly for U2, and it would be better to use that. You can add the Com or .Net attributes through the Add references in the Solution Explorer. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe/UniObjects and Visual Studio
Anthony, Here is a class I created for VB6 to retrieve line item information for a given order. I don't know about using any toolbox items but I do add the resources to the project then create the object. This class is actually used at my company to create a label that is affixed to a product. I hope you find some useful information here. Jeff On Sun, 2007-03-11 at 19:07 -0400, Anthony Dzikiewicz wrote: Hi guys, I am messing with Visual Basic Express edition. I was hoping to use UniObjects against my Universe Database. The examples in the UniObjects Developers Guide are a little outdated. How do I get the UniObjects to appear in the toolbar (if you can do this) ? They refer to Sub Form_Load, which I have seen in older versions of VB, but not VB 2005. Basically what I am looking for is a 'quick fix' for the 5 minute program example in the Developers Guide that has already taken me beyond that time frame. Thanks Anthony VERSION 1.0 CLASS BEGIN MultiUse = -1 'True Persistable = 0 'NotPersistable DataBindingBehavior = 0 'vbNone DataSourceBehavior = 0 'vbNone MTSTransactionMode = 0 'NotAnMTSObject END Attribute VB_Name = ud-access Attribute VB_GlobalNameSpace = False Attribute VB_Creatable = True Attribute VB_PredeclaredId = False Attribute VB_Exposed = False Dim Uni As Object Dim selList As UniSelectList Dim dynArray As UniDynArray Dim dynRec As Object Dim ordFile As UniFile Dim ordLineFile As UniFile Dim relLineFile As UniFile Dim custFile As UniFile Dim catFile As UniFile Dim prodFile As UniFile Dim rs() As CLabelRecord Public Sub GetRecords(stRefNum, Text1 As TextBox) 'On Error GoTo ErrorHandler Set Uni = CreateObject(UV_SESSION_OBJECT) Uni.AccountPath = /ud/YOUR-LIVE-ACCOUNT Uni.HostName = ud-server Uni.UserName = user Uni.Password = password ' UniSession.DataBaseType = 2 iRecCount = 0 iReleaseMode = 0 ' new flogic for scanner ' TUA7$PT$F$1/2 iStringEnd = InStr(1, stRefNum, $) If iStringEnd 0 Then stRefNum = Mid(stRefNum, 1, iStringEnd - 1) Text1.Text = stRefNum Text1.Refresh End If If Uni.Connect = True Then 'If Staging.Value = 1 Then If InStr(1, stRefNum, -) = 0 Then strSql = SELECT ORDER.LINE WITH ORD.NUM= UCase(stRefNum)BY ZONE.IPS BY SEQ.NUM TO 1 Else strSql = SELECT RELEASE.LINE WITH RELEASE.NUM= UCase(stRefNum)BY ZONE.IPS BY SEQ.NUM TO 1 iReleaseMode = 1 End If If Uni.IsActive Then Set ordFile = Uni.OpenFile(ORDER) If ordFile Is Nothing Then MsgBox ORDER not open Set ordLineFile = Uni.OpenFile(ORDER.LINE) If ordLineFile Is Nothing Then MsgBox ORDER.LINE not open Set relLineFile = Uni.OpenFile(RELEASE.LINE) If relLineFile Is Nothing Then MsgBox RELEASE.LINE not open Set custFile = Uni.OpenFile(CUSTOMER) If custFile Is Nothing Then MsgBox CUSTOMER not open Set catFile = Uni.OpenFile(CATEGORY) If catFile Is Nothing Then MsgBox CATEGORY not open Set prodFile = Uni.OpenFile(PRODUCT) If prodFile Is Nothing Then MsgBox PRODUCT not open 'DoMsg Looking up + UCase(Text1.Text) Uni.Command.Text = strSql Uni.Command.Exec ' Build the recordset from records received Set selList = Uni.SelectList(1) Set dynArray = selList.ReadList ' List of records ReDim rs(dynArray.Count) For iLineItemLoop = 1 To dynArray.Count Set rs(iLineItemLoop) = New CLabelRecord LineKey = dynArray.Value(iLineItemLoop, 0) OrderKey = Mid(LineKey, 1, 11) OrderNum = Mid(LineKey, 4, 8) If iReleaseMode = 1 Then relLineFile.RecordId = LineKey relLineFile.Read LineKey = relLineFile.Record.Value(2, 0) End If ordLineFile.RecordId = LineKey ordLineFile.Read ordFile.RecordId = OrderKey ordFile.Read ' Get information from the Order Header rs(iLineItemLoop).CustPoNum = ordFile.Record.Value(12, 0) ' Customer PO Number rs(iLineItemLoop).JobNum = ordFile.Record.Value(133, 0) ' Customer Job Number rs(iLineItemLoop).OrderNum = OrderNum rs(iLineItemLoop).RelNum = stRefNum rs(iLineItemLoop).CustLnNum = ordLineFile.Record.Value(92, 0) rs(iLineItemLoop).CustProdNum = ordLineFile.Record.Value(153, 0) rs(iLineItemLoop).PckQty = ordLineFile.Record.Value(38, 0) rs(iLineItemLoop).UnMeas = ordLineFile.Record.Value(103, 0) rs(iLineItemLoop).ProdNum = ordLineFile.Record.Value(27, 0)
RE: [U2] Universe/UniObjects and Visual Studio
Dave, I was able to get the COM assembly in the solution explorer. I am now looking at the .Net. How do I go about getting the .Net assembly in the 'game'. What I have tried is to go into the control panel on the PC and go under admin, .Net framework and config, and tried to add. I pointed to the c:\ibm\unidk\uonet\bin\uodotnet.dll. Of course Im just winging it here. It seemed that this made sense. However, it does not appear in the solutions explorer when I try yo add a .Net reference. So, I tried but no cigar. What is the right way to do this ? Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Sunday, March 11, 2007 8:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe/UniObjects and Visual Studio Hi Anthony Whilst UniObjects works with .Net, it is a COM assembly and needs to be loads as a Comm Component. IBM does provide a .Net assembly for U2, and it would be better to use that. You can add the Com or .Net attributes through the Add references in the Solution Explorer. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/UniObjects and Visual Studio
You'll have to do two things. In Visual Studio, in the Solution Explorer, right click on your project, and choose Add Reference from the context menu. When the Add Reference dialog displays, choose the Browse tab. Use that to navigate to where ever your UODOTNET.dll file is located. Second step is to add a compiler directive in your source code like this, Using UODOTNET; (assuming c#) or Imports UODOTNET (using VB). hth Victor St. Clair Jenkon Sr. Analyst [EMAIL PROTECTED] 360-256-4400 Phone 360-256-9623 Fax www.jenkon.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Sunday, March 11, 2007 6:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe/UniObjects and Visual Studio Dave, I was able to get the COM assembly in the solution explorer. I am now looking at the .Net. How do I go about getting the .Net assembly in the 'game'. What I have tried is to go into the control panel on the PC and go under admin, .Net framework and config, and tried to add. I pointed to the c:\ibm\unidk\uonet\bin\uodotnet.dll. Of course Im just winging it here. It seemed that this made sense. However, it does not appear in the solutions explorer when I try yo add a .Net reference. So, I tried but no cigar. What is the right way to do this ? Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Sunday, March 11, 2007 8:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe/UniObjects and Visual Studio Hi Anthony Whilst UniObjects works with .Net, it is a COM assembly and needs to be loads as a Comm Component. IBM does provide a .Net assembly for U2, and it would be better to use that. You can add the Com or .Net attributes through the Add references in the Solution Explorer. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.8/716 - Release Date: 3/9/2007 6:53 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/