I am looking to move away from a VFP/FoxWeb solution for new (and maybe
old) web pages projects.
I am looking for suggestions for converting existing VFP tables to some
flavor of SQL and a quick learn language to support presenting the data to
an HTML page.
Any suggestions?
George
--
Success builds confidence. Failure builds knowledge.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hXwqhHvAyAiHXW2hnMSp0opwNt5So24GCd029+NZFPZcw@mail.gmail.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.
I've heard FoxInCloud is essentially HTML webpages - AFAIK - although I
could be wrong. And, the creator is here on the list.
Also, I've had some luck in converting VFP to MS SQL using the Wizard -
and you can use the SQLExpress version to try it out for free. Although,
I didn't go much farther than just trying to convert a single DBF - and
didn't at the time continue on w/SQL...
-K-
On 12/7/2012 5:43 PM, G Gambill wrote:
> I am looking to move away from a VFP/FoxWeb solution for new (and maybe
> old) web pages projects.
>
> I am looking for suggestions for converting existing VFP tables to some
> flavor of SQL and a quick learn language to support presenting the data to
> an HTML page.
>
> Any suggestions?
>
> George
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/50C2735E.3000207@optonline.net
** 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.
I would use MySQL (or Postgre) and PHP on the server. Of course that
presumes that you're on a server that you have access/control of and can
install MySQL + PHP (or use a company that provides such services.)
Also, there's going to be a slight difference depending on whether the
server is Windoze or Linux...my preference is Linux. I'm guessing that
if you've been running FoxWeb, you're on a Windows server (and PHP will
install and run on a Windows box.)
Anyway, PHP is not that hard to learn and way powerful, very well
supported.
I'm sure others on the list would recommend Python, and I would join
them in that recommendation, but I have no experience (yet) with Python.
Regardless of where you go and what you do, moving away from the DBF
file storage is a wise decision.
Mike
-------- Original Message --------
Subject: (NF) for HTML
From: G Gambill <gwgambill@gmail.com>
To: profoxtech@leafe.com
Date: 12/7/2012 4:43 PM
> I am looking to move away from a VFP/FoxWeb solution for new (and maybe
> old) web pages projects.
>
> I am looking for suggestions for converting existing VFP tables to some
> flavor of SQL and a quick learn language to support presenting the data to
> an HTML page.
>
> Any suggestions?
>
> George
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/50C2741B.9000103@ggisoft.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.
Hello George,
I really like PostgreSQL as my SQL Server of choice, both for working in
VFP and Real Studio. You can upsize your structures by using this utility:
http://leafe.com/download/stru2postgreSQL.PRG
I'm really like the Real Studio Web Edition for the ease of translating
your VFP skills over into a "cousin" language to VFP.
http://www.realsoftware.com/web/
... and ...
http://www.realsoftware.com/web/video.php
-Kevin
On 12/07/2012 05:43 PM, G Gambill wrote:
> I am looking to move away from a VFP/FoxWeb solution for new (and maybe
> old) web pages projects.
>
> I am looking for suggestions for converting existing VFP tables to some
> flavor of SQL and a quick learn language to support presenting the data to
> an HTML page.
>
> Any suggestions?
>
> George
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/50C27998.80105@cullytechnologies.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.
On Fri, Dec 7, 2012 at 5:43 PM, G Gambill <gwgambill@gmail.com> wrote:
> I am looking to move away from a VFP/FoxWeb solution for new (and maybe
> old) web pages projects.
>
> I am looking for suggestions for converting existing VFP tables to some
> flavor of SQL and a quick learn language to support presenting the data to
> an HTML page.
>
Everybody hosting an app on the internet ought to know enough Linux OS,
MySQL and PHP to get by.
If you're serious about developing complex apps and support them long-term,
you'll likely want to check out Python or Ruby.
> --
Ted Roche
Ted Roche & Associates, LLC
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CACW6n4uRwQqckiwuxc20Mf6=+PtexkB5zx+8ikq8FZuWeF-=rg@mail.gmail.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.
Thanks, do you know if FoxInClouds requires Windows? I'm hoping to get away
from finding a provider that offers Windows.
On Fri, Dec 7, 2012 at 3:53 PM, Kurt @ VR-FX <vrfx@optonline.net> wrote:
> I've heard FoxInCloud is essentially HTML webpages - AFAIK - although I
> could be wrong. And, the creator is here on the list.
>
> Also, I've had some luck in converting VFP to MS SQL using the Wizard -
> and you can use the SQLExpress version to try it out for free. Although, I
> didn't go much farther than just trying to convert a single DBF - and
> didn't at the time continue on w/SQL...
>
> -K-
>
>
>
> On 12/7/2012 5:43 PM, G Gambill wrote:
>
>> I am looking to move away from a VFP/FoxWeb solution for new (and maybe
>> old) web pages projects.
>>
>> I am looking for suggestions for converting existing VFP tables to some
>> flavor of SQL and a quick learn language to support presenting the data to
>> an HTML page.
>>
>> Any suggestions?
>>
>> George
>>
>
>
> ______________________________**_________________
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance: http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox>
> OT-free version of this list: http://mail.leafe.com/mailman/**
> listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech>
> Searchable Archive: http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox>
> This message: http://leafe.com/archives/**byMID/profox/50C2735E.3000207@**
> optonline.net<http://leafe.com/archives/byMID/profox/50C2735E.3000207@optonline.net>
> ** 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.
>
> Report [OT] Abuse: http://leafe.com/reportAbuse/**
> 50C2735E.3000207@optonline.net<http://leafe.com/reportAbuse/50C2735E.3000207@optonline.net>
>
--
Success builds confidence. Failure builds knowledge.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hUMoFgtxO-cozqC+B+YwcfxrYuE7yXRAhEgE5q07FZ23g@mail.gmail.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.
As I mentioned in an earlier response, I hope to get away from a Windows
server. I have had some experience with Postger and a bit less with MySQL
and understand that there are tools to convert DBFs to SQL.
Thanks for the suggestions on PHP and Python. This is
the recommendations I am hunting for.
On Fri, Dec 7, 2012 at 3:56 PM, Mike Copeland <mike@ggisoft.com> wrote:
> I would use MySQL (or Postgre) and PHP on the server. Of course that
> presumes that you're on a server that you have access/control of and can
> install MySQL + PHP (or use a company that provides such services.) Also,
> there's going to be a slight difference depending on whether the server is
> Windoze or Linux...my preference is Linux. I'm guessing that if you've been
> running FoxWeb, you're on a Windows server (and PHP will install and run on
> a Windows box.)
>
> Anyway, PHP is not that hard to learn and way powerful, very well
> supported.
>
> I'm sure others on the list would recommend Python, and I would join them
> in that recommendation, but I have no experience (yet) with Python.
>
> Regardless of where you go and what you do, moving away from the DBF file
> storage is a wise decision.
>
> Mike
>
>
> -------- Original Message --------
> Subject: (NF) for HTML
> From: G Gambill <gwgambill@gmail.com>
> To: profoxtech@leafe.com
> Date: 12/7/2012 4:43 PM
>
>> I am looking to move away from a VFP/FoxWeb solution for new (and maybe
>> old) web pages projects.
>>
>> I am looking for suggestions for converting existing VFP tables to some
>> flavor of SQL and a quick learn language to support presenting the data to
>> an HTML page.
>>
>> Any suggestions?
>>
>> George
>>
>
>
> ______________________________**_________________
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance: http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox>
> OT-free version of this list: http://mail.leafe.com/mailman/**
> listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech>
> Searchable Archive: http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox>
> This message: http://leafe.com/archives/**byMID/profox/50C2741B.9000103@**
> ggisoft.com<http://leafe.com/archives/byMID/profox/50C2741B.9000103@ggisoft.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.
>
> Report [OT] Abuse: http://leafe.com/reportAbuse/**
> 50C2741B.9000103@ggisoft.com<http://leafe.com/reportAbuse/50C2741B.9000103@ggisoft.com>
>
--
Success builds confidence. Failure builds knowledge.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hXQ6u9VLzTkeQivAuF3gC2jiwhA0YgQsK4FW+GLkO29jw@mail.gmail.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.
On Dec 7, 2012, at 8:20 PM, G Gambill <gwgambill@gmail.com> wrote:
> Thanks, do you know if FoxInClouds requires Windows? I'm hoping to get away
> from finding a provider that offers Windows.
If you are looking to get away from Windows, then I think that that pretty much rules out all Fox-based approaches.
I have found Python to be the language which most closely resembles Fox. No, the syntax isn't similar, but the approach is. Both are dynamic languages which are strongly-typed. PHP is dynamic but weakly-typed, and that causes a lot of problems when transitioning. Python also has a much stronger object model than PHP; it's much more similar to VFP in that regard.
The other intangible with Python is the awesome community. People ask me why I still support the Fox community when I haven't worked with Fox in nearly 5 years, and I always tell them that it has an amazing community of extremely helpful people. That's exactly what I've found the Python community to be like, so if you're thinking of not just doing a one-off project, but instead looking toward the next phase of your development career, Python is certainly an excellent choice for many reasons.
Oh, yeah - there's Dabo, too. I hear it's pretty cool. ;-)
-- Ed Leafe
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/E5B09F34-E4D1-42DA-9CD4-4A3BBBC82D22@rackspace.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.
Thanks Kevin, PostgreSQL is most likely my SQL of choice assuming the
company of choice to provide the Web service supports it.
On Fri, Dec 7, 2012 at 4:19 PM, Kevin Cully <kcully@cullytechnologies.com>wrote:
> Hello George,
>
> I really like PostgreSQL as my SQL Server of choice, both for working in
> VFP and Real Studio. You can upsize your structures by using this utility:
> http://leafe.com/download/**stru2postgreSQL.PRG<http://leafe.com/download/stru2postgreSQL.PRG>
>
> I'm really like the Real Studio Web Edition for the ease of translating
> your VFP skills over into a "cousin" language to VFP.
> http://www.realsoftware.com/**web/ <http://www.realsoftware.com/web/>
> ... and ...
> http://www.realsoftware.com/**web/video.php<http://www.realsoftware.com/web/video.php>
>
> -Kevin
>
>
>
> On 12/07/2012 05:43 PM, G Gambill wrote:
>
>> I am looking to move away from a VFP/FoxWeb solution for new (and maybe
>> old) web pages projects.
>>
>> I am looking for suggestions for converting existing VFP tables to some
>> flavor of SQL and a quick learn language to support presenting the data to
>> an HTML page.
>>
>> Any suggestions?
>>
>> George
>>
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
>
> ______________________________**_________________
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance: http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox>
> OT-free version of this list: http://mail.leafe.com/mailman/**
> listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech>
> Searchable Archive: http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox>
> This message: http://leafe.com/archives/**byMID/profox/50C27998.80105@**
> cullytechnologies.com<http://leafe.com/archives/byMID/profox/50C27998.80105@cullytechnologies.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.
>
> Report [OT] Abuse: http://leafe.com/reportAbuse/**50C27998.80105@**
> cullytechnologies.com<http://leafe.com/reportAbuse/50C27998.80105@cullytechnologies.com>
>
--
Success builds confidence. Failure builds knowledge.
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hWpOTjVse15KNGsvX8URhvj3CZrngcS+N6m0+iW54pHLA@mail.gmail.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.
Ted, at this point I don't see anything very complex. But, then, YHou know
how that goes.
Thanks
On Fri, Dec 7, 2012 at 6:42 PM, Ted Roche <tedroche@gmail.com> wrote:
> On Fri, Dec 7, 2012 at 5:43 PM, G Gambill <gwgambill@gmail.com> wrote:
>
> > I am looking to move away from a VFP/FoxWeb solution for new (and maybe
> > old) web pages projects.
> >
> > I am looking for suggestions for converting existing VFP tables to some
> > flavor of SQL and a quick learn language to support presenting the data
> to
> > an HTML page.
> >
>
> Everybody hosting an app on the internet ought to know enough Linux OS,
> MySQL and PHP to get by.
>
> If you're serious about developing complex apps and support them long-term,
> you'll likely want to check out Python or Ruby.
>
>
> > --
>
> Ted Roche
> Ted Roche & Associates, LLC
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAPpp0hXy4hUdU4RbhWAaQpcK1MOvjJ_9+38-cL0H8LQRLarGsg@mail.gmail.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.