Author: MB Software Solutions, LLC
Posted: 2011-10-25 11:53:57 Link
Using my n-tier design approach and incorporating Paul McNett's
MakeUpdatable.prg, I show you a simple demo app that connects to a MySQL
web database from my VFP9 app framework. It's designed to be simple and
straight-forward for the pure ease of illustration/example. Special
thanks to Paul McNett for offering his web database for access with
this. In the zip download, you'll find all of the project files, plus
the MySQL ODBC Setup.exe file. Let me know if you have any questions or
if I missed anything. Thanks, --Mike Author: Michael J. Babcock, MCP
Freeware 2.5MB Last updated: 2011.10.24
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4EA6DB95.40205@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Eurico Chagas Filho
Posted: 2011-10-25 14:35:15 Link
Thanks Mike, may Jesus be w you.
>________________________________
>From: "MB Software Solutions, LLC" <mbsoftwaresolutions@mbsoftwaresolutions.com>
>To: ProFox Email List <profox@leafe.com>
>Sent: Tuesday, October 25, 2011 1:53 PM
>Subject: VFP2MySQL demo app posted on ProFox downloads site
>
>
>Using my n-tier design approach and incorporating Paul McNett's
>MakeUpdatable.prg, I show you a simple demo app that connects to a MySQL
>web database from my VFP9 app framework. It's designed to be simple and
>straight-forward for the pure ease of illustration/example. Special
>thanks to Paul McNett for offering his web database for access with
>this. In the zip download, you'll find all of the project files, plus
>the MySQL ODBC Setup.exe file. Let me know if you have any questions or
>if I missed anything. Thanks, --Mike Author: Michael J. Babcock, MCP
>Freeware 2.5MB Last updated: 2011.10.24
>
>
>
>
>--
>Mike Babcock, MCP
>MB Software Solutions, LLC
>President, Chief Software Architect
>http://mbsoftwaresolutions.com
>http://twitter.com/mbabcock16
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1319567715.30287.YahooMailNeo@web160820.mail.bf1.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Allen
Posted: 2011-10-25 14:40:23 Link
I'm in France.
-----Original Message-----
Thanks Mike, may Jesus be w you.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/008101cc9345$8f1fbc70$ad5f3550$@com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: MB Software Solutions, LLC
Posted: 2011-10-25 15:15:26 Link
On 10/25/2011 2:35 PM, Eurico Chagas Filho wrote:
> Thanks Mike, may Jesus be w you.
lol...thanks! He always is! :-)
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4EA70ACE.4020100@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Andrew Stirling
Posted: 2011-10-26 04:19:15 Link
Hi Mike
I can't find 'mslc.h' which is required in the 'frmusers.scx'.
Any ideas?
Kind regards
Andrew Stirling
On 25/10/2011 16:53, MB Software Solutions, LLC wrote:
>
> Using my n-tier design approach and incorporating Paul McNett's
> MakeUpdatable.prg, I show you a simple demo app that connects to a MySQL
> web database from my VFP9 app framework. It's designed to be simple and
> straight-forward for the pure ease of illustration/example. Special
> thanks to Paul McNett for offering his web database for access with
> this. In the zip download, you'll find all of the project files, plus
> the MySQL ODBC Setup.exe file. Let me know if you have any questions or
> if I missed anything. Thanks, --Mike Author: Michael J. Babcock, MCP
> Freeware 2.5MB Last updated: 2011.10.24
>
>
>
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4EA7C283.8040605@calcpay.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: MB Software Solutions, LLC
Posted: 2011-10-26 15:16:12 Link
On 10/26/2011 4:19 AM, Andrew Stirling wrote:
> Hi Mike
>
> I can't find 'mslc.h' which is required in the 'frmusers.scx'.
> Any ideas?
That shouldn't be needed for anything. Just make an empty file and let
me know how that turns out. The IDE here had that set as the default
include file in the Options. It's not needed.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4EA85C7C.2010109@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Ajit Abraham
Posted: 2011-10-27 09:32:42 Link
Hi Mike,
I had to the following to run it from the project.
1. Right at the top of main.prg, I had to set a "SET DEFAULT TO......"
the current location of the project file
2. Had to hard code the path of registry.h for the include statement at
the top of main.prg
3. In the InstallMySQL fuction, changed
lcFile =".\MyODBC\setup.exe"
to
lcFile =".\setup.exe"
4. In the same function changed
loShell = NEWOBJECT("_ShellExecute","_Environ.vcx")
to
loShell = NEWOBJECT("_ShellExecute",HOME(1)+"Ffc\_Environ.vcx")
Maybe I had to do the above due to some existing settings in my VFP
environment.
Thanks once again for sharing your code.
Sincerely,
_Ajit Abraham
On 26/10/2011 22:16, MB Software Solutions, LLC wrote:
> On 10/26/2011 4:19 AM, Andrew Stirling wrote:
>> Hi Mike
>>
>> I can't find 'mslc.h' which is required in the 'frmusers.scx'.
>> Any ideas?
>
>
> That shouldn't be needed for anything. Just make an empty file and let
> me know how that turns out. The IDE here had that set as the default
> include file in the Options. It's not needed.
>
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4EA95D7A.8070902@ua-group.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: MB Software Solutions, LLC
Posted: 2011-10-27 14:22:53 Link
On 10/27/2011 9:32 AM, Ajit Abraham wrote:
> Hi Mike,
>
> I had to the following to run it from the project.
>
> 1. Right at the top of main.prg, I had to set a "SET DEFAULT TO......"
> the current location of the project file
>
> 2. Had to hard code the path of registry.h for the include statement at
> the top of main.prg
>
> 3. In the InstallMySQL fuction, changed
> lcFile =".\MyODBC\setup.exe"
> to
> lcFile =".\setup.exe"
>
> 4. In the same function changed
> loShell = NEWOBJECT("_ShellExecute","_Environ.vcx")
> to
> loShell = NEWOBJECT("_ShellExecute",HOME(1)+"Ffc\_Environ.vcx")
>
> Maybe I had to do the above due to some existing settings in my VFP
> environment.
>
> Thanks once again for sharing your code.
>
> Sincerely,
>
> _Ajit Abraham
Many thanks for this. I wanted the feedback to know what to cleanup so
the rest of the community could benefit. I'll take care of these
changes and update the ProFox site later.
Please keep comments/changes/suggestions coming for the benefit of all.
Thanks!
--Mike
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4EA9A17D.2000106@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.