fp and .net

[Richard Kreiss]

Rick,

Have you looked at Fp 5.7 with its integration with MySQL?  That may be a solution. 

Richard
Sent from my iPhone

On Jul 20, 2012, at 9:15 AM, Richard Hane <yoresoft at sbcglobal.net> wrote:

> [ top posted ]
>  
> Walter,
>  
> Thanks for the feed back.  I raised the question because I was trying to find an less time consuming way to get quality GUI / web screens for use with fp.  The version of our new ERP system is totally .net framework and I really like the way it looks and feels.
>  
> I also like the 'grids' functions.  I would love to be able to incorporate that in to filePro processing for my plant mgt software.
>  
> However, the use of SQL (MySQL or Microsoft SQL server) really defeats the purpose (IMHO).  I don't want to use another data base as a bridge only because fp has not progressed over the past 15 years, again IMHO.  
>  
> I really like fp programming and don't want to relearn the wheel, as it where, of a new database with vba, etc.  At this point I'll just stick to using html screens.
>  
> Again thanks for the reply,
>  
> Rick Hane
> Controller
> Deluxe Stitching Company Inc
> ISP Stitching Products
> http://www.deluxestitcher.com/
>  
>  
>  
> 
> 
> ________________________________
> From: Walter Vaughan <wvaughan at steelerubber.com>
> To: filePro <filepro-list at lists.celestial.com> 
> Sent: Thursday, July 19, 2012 4:05 PM
> Subject: Re: fp and .net
> 
> Richard Hane wrote:
> 
>> I'd like to start a new thread.  May be short if not possible but let's see.
>> 
>> This would be mainly for those running fp on Windows.
>>   
>> 
> okay
> 
>> 
>> Has anyone tried to use Microsoft's .net screens and grids with filePro?
>>   
>> 
> I have data that has been created/managed with filepro and now is used 
> differently with a .net app
> 
>> 
>> Where you able to do so without using a SQL program?
>>   
>> 
> No.
> 
>> What success did you have?
>>   
>> 
> I just export/import as needed into SQL Server 2005
> 
> On the otherhand, you can use the filePro mySQL interface 
> http://www.fptech.com/Products/Docs/fpmanhtm/filepro_mysql/mysql_interface.htm
> and use mySQL as the data store. You can't use LinQ (I think), but from 
> an application standpoint its just a different connection string...
> 
> This looks exactly how I would do a connection to SQL Server 2005, 'cept 
> below is for mySQL
> 
> // Get the MySQL connection string stored in the Web.config
> string cnnString = ConfigurationSettings.AppSettings["ConnectionString"];
> 
> // Create a connection object and data adapter
> MySqlConnection cnx = new MySqlConnection(cnnString);
> MySqlDataAdapter adapter = new MySqlDataAdapter();
> 
> // Create a SQL command object
> string cmdText = "usp_Verse_GetList";
> MySqlCommand cmd = new MySqlCommand(cmdText, cnx);
> 
> // Set the command type to StoredProcedure
> cmd.CommandType = CommandType.StoredProcedure;
> 
> // Create and fill a DataSet
> DataSet ds = new DataSet();
> adapter.SelectCommand = cmd;
> adapter.Fill(ds);
> 
>> 
>> If using .net as input screens how was the speed and flow with filePro?
>> 
>>   
>> 
> Well a poorly written web page will be mangintudes harder and slower for 
> an end user.
> Well a poorly written filepro screen will be magnitudes harder and 
> slower for an end user
> 
> I don't understand the question.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120719/936e7e8a/attachment.html 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120720/05f34bc3/attachment.html 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list