When using something like Web Connection, is it better to use free
tables rather than a DBC? Without the DBC you have more flexibility
when changing file formats and I am not using any views on the web
programming.
TIA
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
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/549435D0.5020307@san-dc.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.
You lose the long field names facility. That may or may not be a factor in your decision. Personally I always use DBC's as it means that table maintenance is easier. People like Al just do not like them but I have always found them to be very reliable.
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Jeff Johnson
Sent: 19 December 2014 14:27
To: profox@leafe.com
Subject: Free Tables vs. DBC on Web Site
When using something like Web Connection, is it better to use free tables rather than a DBC? Without the DBC you have more flexibility when changing file formats and I am not using any views on the web programming.
TIA
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
[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/18725B8CD2D5D247873A2BAF401D4AB246863ADE@EX2010-A-FPL.FPL.LOCAL
** 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.
No I hate them. Nothing but trouble.
I have users that move tables. It's not possible to do that with DBC's
Al
-----Original Message-----
You lose the long field names facility. That may or may not be a factor in
your decision. Personally I always use DBC's as it means that table
maintenance is easier. People like Al just do not like them but I have
always found them to be very reliable.
---
This email is free from viruses and malware because avast! Antivirus protection is active.
_______________________________________________
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/00a801d01b9c$1ff03b30$5fd0b190$@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.
Dave: I use them all the time in my applications, but adding a table or
changing a table structure is a pain on a remote machine that I have no
access to with a DBC.
On 12/19/2014 7:51 AM, Dave Crozier wrote:
> You lose the long field names facility. That may or may not be a factor in your decision. Personally I always use DBC's as it means that table maintenance is easier. People like Al just do not like them but I have always found them to be very reliable.
>
> Dave
>
> -----Original Message-----
> From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Jeff Johnson
> Sent: 19 December 2014 14:27
> To: profox@leafe.com
> Subject: Free Tables vs. DBC on Web Site
>
> When using something like Web Connection, is it better to use free tables rather than a DBC? Without the DBC you have more flexibility when changing file formats and I am not using any views on the web programming.
>
> TIA
>
> --
> Jeff
>
> Jeff Johnson
> jeff@san-dc.com
> SanDC, Inc.
> (623) 582-0323
> SMS (602) 717-5476
> Fax 623-869-0675
>
> www.san-dc.com
> www.cremationtracker.com
> www.agentrelationshipmanager.com
>
>
>
[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/54943DD9.6030604@san-dc.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.
There are a lot of ways to get access to a remote machine, as we keep
discussing here. You're going to need access to update and debug and
troubleshoot anyway.
Rick says WebConnect will work either way:
http://www.west-wind.com/wwThreads/default_frames.asp?Thread=3ZB14MOLH&MsgId=3ZC0F45AM
I'd suggest you use the framework and tools you're familiar with. If those
require a DBC, then remote access becomes a requirement for the
application, not the other way around.
I always use a DBC. And a framework. But that's just me. I support clients
who have everything from ported FoxBASE apps to every framework you've ever
heard of (except FoxExpress, strangely) and home-grown 'frameworks.' The
home-grown ones are more expensive to the client, hands-down.
Let's talk "tabs versus spaces" next. We haven't done that go-round in a
long time :) Or which server is "best." :)
Happy Friday, folks!
On Fri, Dec 19, 2014 at 10:01 AM, Jeff Johnson <jeff@san-dc.com> wrote:
>
> Dave: I use them all the time in my applications, but adding a table or
> changing a table structure is a pain on a remote machine that I have no
> access to with a DBC.
>
> On 12/19/2014 7:51 AM, Dave Crozier wrote:
>
>> You lose the long field names facility. That may or may not be a factor
>> in your decision. Personally I always use DBC's as it means that table
>> maintenance is easier. People like Al just do not like them but I have
>> always found them to be very reliable.
>>
>> Dave
>>
>> -----Original Message-----
>> From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Jeff Johnson
>> Sent: 19 December 2014 14:27
>> To: profox@leafe.com
>> Subject: Free Tables vs. DBC on Web Site
>>
>> When using something like Web Connection, is it better to use free tables
>> rather than a DBC? Without the DBC you have more flexibility when changing
>> file formats and I am not using any views on the web programming.
>>
>> TIA
>>
>> --
>> Jeff
>>
>> Jeff Johnson
>> jeff@san-dc.com
>> SanDC, Inc.
>> (623) 582-0323
>> SMS (602) 717-5476
>> Fax 623-869-0675
>>
>> www.san-dc.com
>> www.cremationtracker.com
>> www.agentrelationshipmanager.com
>>
>>
[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/CACW6n4vJbzp_qLRH0vBWOoJnsmZ+ayEGvmSJKbmgoCpVZEer5w@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 Fri, 19 Dec 2014, at 03:01 PM, Jeff Johnson wrote:
> Dave: I use them all the time in my applications, but adding a table or
> changing a table structure is a pain on a remote machine that I have no
> access to with a DBC.
I don't understand why it would be any more difficult than doing it with
free tables.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
_______________________________________________
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/1419004647.2273538.204895505.5A4C4985@webmail.messagingengine.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 12/19/2014 8:57 AM, Alan Bourke wrote:
> On Fri, 19 Dec 2014, at 03:01 PM, Jeff Johnson wrote:
>> Dave: I use them all the time in my applications, but adding a table or
>> changing a table structure is a pain on a remote machine that I have no
>> access to with a DBC.
> I don't understand why it would be any more difficult than doing it with
> free tables.
>
>
I have no access to the web site at all. I have to send everything to
an IT person with instructions. I have a table update program using
Stonefield, but I have not automated it. I still have to fill in the
blanks.
--
Jeff
Jeff Johnson
jeff@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
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/54944F78.7000107@san-dc.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.
Gotcha.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
_______________________________________________
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/1419007888.2284686.204916841.3BD36C87@webmail.messagingengine.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.
We just installed a FoxInCloud application with this feature ...
Web site: upon startup, web app runs a program (ipData.prg) that adjust
the database and tables structure if needed (including views and stored
procs)
Local: a small VFP exe (ipMigrator.exe) doing this:
1- downloads ipData.prg from the web site, compiles and execute
(ensures that both sides have the very same database structure)
2- imports data from existing reference tables into the DB
(until other desktop apps have migrated to the new structure)
3- synchronizes data between local and the web site databases
(using a class supplied by FoxInCloud, 3 lines of code)
Here is the database diagram:
ftp://foxincloud.com/Screenshots/MCTG/ip.dbc.png
I can give you any other details you would like, including source code,
just let me know
Thierry Nivelet
FoxInCloud
Give your VFP app a second life in the cloud
Le 19/12/2014 15:27, Jeff Johnson a écrit :
> When using something like Web Connection, is it better to use free
> tables rather than a DBC? Without the DBC you have more flexibility
> when changing file formats and I am not using any views on the web
> programming.
>
> TIA
>
_______________________________________________
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/54954E0A.7080803@foxincloud.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.
Terry: Thanks for that. Two questions, is there any overhead on the
web app running ipData.prg? For example, Stonefield's checking to see
if tables need updating has overhead if the database and tables are
large. Second is do your memo fields merge or overwrite? Many of my
memo fields have time stamped notes and overwriting would not be an
option. If someone on the web enters a note and someone on the local
computer enters a note, we need both of them.
Thanks!
On 12/20/2014 3:23 AM, Thierry Nivelet wrote:
> We just installed a FoxInCloud application with this feature ...
>
> Web site: upon startup, web app runs a program (ipData.prg) that
> adjust the database and tables structure if needed (including views
> and stored procs)
>
> Local: a small VFP exe (ipMigrator.exe) doing this:
>
> 1- downloads ipData.prg from the web site, compiles and execute
> (ensures that both sides have the very same database structure)
> 2- imports data from existing reference tables into the DB
> (until other desktop apps have migrated to the new structure)
> 3- synchronizes data between local and the web site databases
> (using a class supplied by FoxInCloud, 3 lines of code)
>
> Here is the database diagram:
> ftp://foxincloud.com/Screenshots/MCTG/ip.dbc.png
>
> I can give you any other details you would like, including source
> code, just let me know
>
> Thierry Nivelet
> FoxInCloud
> Give your VFP app a second life in the cloud
>
> Le 19/12/2014 15:27, Jeff Johnson a écrit :
>> When using something like Web Connection, is it better to use free
>> tables rather than a DBC? Without the DBC you have more flexibility
>> when changing file formats and I am not using any views on the web
>> programming.
>>
>> TIA
>>
>
>
[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/54957FC7.4090408@san-dc.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.