Re: ASNA Visual RPG

[Mike Wills <mike@xxxxxxxxxxxx>]

I am with Richard. I have never used VRPG. I would see how to do it
ANSA's way first.

Otherwise, I have an open-source class that makes DB connections easy.
Take look at https://github.com/MikeWills/IBM-i-.NET-Interface. I
haven't gotten too advanced yet in the methods, but makes DB logic
easy.

--
Mike Wills
http://mikewills.me

Sent from my mobile phone

On Dec 17, 2011, at 12:25 PM, Richard Schoen <richard@xxxxxxxxxxxxxxx> wrote:

> Mark,
>
> My understanding is that the VRPG software has its own data layer.
>
> Are you planning to use the ASNA's  RPG or write something custom in VB.Net/C# ?
>
> If they are using full-on VRPG I would see what they offer in their stuff first.
>
> Also, what type of app ?
>
> In .Net you would typically use SQL to update records in the database in .Net depending on your apps functionality.
>
> VRPG probably has some functionality similar to CHAIN/READ/WRITE/UPDATE already built in to its language.
>
> Where it probably gets a little fuzzy is they compile the VRPG code to .Net.
>
> I would suggest maybe contacting ASNA for a little input and training if possible.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
> ----------------------------------------------------------------------
>
> message: 1
> date: Fri, 16 Dec 2011 14:37:02 -0500
> from: Mark Walter <mwalter@xxxxxxxxxxxxxxx>
> subject: [SystemiDotNet] ASNA Visual RPG
>
> Hello all,
>
> I'm at a client that is using ASNA VRPG for .Net. I have been tasked to create a data access layer over their database in order to streamline some of their web development.
>
> My question to you is how would you implement the Add/Update functions of a data class. I thought about passing a .Net datatable back to the procedure and write/update from that, but I was wondering if anyone has any more elegant solutions.
>
> Thanks,
>
> Mark
>
> Mark Walter
> Business to Business Data Integration Specialist Certified IBM System i Specialist Paragon Consulting Services, Inc.
> mwalter@xxxxxxxxxxxxxxx
> 717-764-7909 ext. 126
>
>
> --
> This is the .net use with the System i (SystemiDotNet) mailing list
> To post a message email: SystemiDotNet@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
> or email: SystemiDotNet-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/systemidotnet.