Re: odbc, foxplus and office desktops apps
- From: "Dan Freeman" <spam@xxxxxxxxxxxxx>
- Date: Fri, 7 Sep 2007 08:28:00 -0700
The most I'll commit to is "your mileage may vary".
It depends on the feature and what you're expecting. I wouldn't expect
DBCEvents to work, so I certainly wouldn't expect them to serve their
intended purpose. <g>
I know that I can wreak havoc by accidentally changing a char field to
char(binary) -- the phone immediately starts to ring because external
reporting apps can no longer get to the data. (It's an amazingly easy thing
to do without realizing it -- just bump the keyboard with the MODI STRU
dialog open.)
Dan
Lew wrote:
Hey Dan:
Are you sure the "unusable" glitch applies? I think I remember from
last year that I tested this idea by creating a dbc trigger that
would prevent a test table from being opened at all, under any
circumstances. This "worked" fine in VFP9, but I believe that excel
and word were able to access the table just fine. I don't remember
whether or not I was able to write to the table, however.
"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:OBnSnBM8HHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
Foxplus is probably safest since it's the last version that was truly
dbase-compatible so any lingering code in the Office apps that saw
dbf as "dBase" will still work.
As you know, the VFP ODBC driver hasn't been updated since VFP 6 so
any table using any of the database features added since then will
be unusable to *any* app trying to come in via ODBC.
Dan
Lew wrote:
When I create a standalone table via copy to ... type foxplus/fox2x,
do all other office apps still use odbc to view the table or do some
of them use old style direct file io? I ask because I'm rewriting an
older app & the previous developer believes that the foxplus/fox2x
tables can always be opened by other office apps regardless of odbc
version/install issues. I find this difficult to believe. Anyone
know for sure? -Lew
.
- References:
- Re: odbc, foxplus and office desktops apps
- From: Dan Freeman
- Re: odbc, foxplus and office desktops apps
- From: Lew
- Re: odbc, foxplus and office desktops apps
- Prev by Date: Re: Printing labels?
- Next by Date: Re: Printing labels?
- Previous by thread: Re: odbc, foxplus and office desktops apps
- Next by thread: Re: odbc, foxplus and office desktops apps
- Index(es):
Relevant Pages
|
