|
Home > Archive > Programming with dBASE > February 2006 > memo/binary fields
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
memo/binary fields
|
|
| Paul Van House 2006-02-20, 11:23 am |
| If I have a table with a couple of "memo" fields,and a "binary" field,
is all the field data stored in the same BLOB file...is there a way to
specify multiple BLOB files for one DBF??
Thanks Again.
--
Paul Van House
remove ".removeme" for e-mail replies
Radio/TV Software and Baseball Stat Software:
http://www.binxsoftware.com
Family Home Page: http://vanhouse.binxsoftware.com
Church Home Page: http://www.ashfordumc.org
| |
| *Lysander* 2006-02-20, 1:23 pm |
| Paul Van House schrieb:
> If I have a table with a couple of "memo" fields,and a "binary" field,
> is all the field data stored in the same BLOB file...is there a way to
> specify multiple BLOB files for one DBF??
no.
If you desperately need it, you can create a link-structure
yourself, which basically works like this:
table_a.field_bin not holding the binary-field itself, but an ID
which points to a record in an extra "binary-table", let's say
table_b.field_id.
This table again only consists of the field "field_id" and the
binary-field.
That way you have the BLOBs separated in different *.dbt, but you
would have to ensure data-integrity of IDs and pointers to the extra
tables yourself.
ciao,
André
| |
| Paul Van House 2006-02-20, 8:23 pm |
| In article <WG1JFSkNGHA.2292@news-server>, nobody@nowhere.com says...
> Paul Van House schrieb:
>
> no.
>
> If you desperately need it, you can create a link-structure
> yourself, which basically works like this:
>
>
Too much work. <G>. Easier to create a child table for the other
BLOBS.
Have you had problems with multiple memo/Binary fields in the same BLOB
file. A post on the other newsgroup indicated it was not a good idea.
I've only had very rare problems with memo fields over the years but
can't recall off hand if I've mixed "binary" and "memo" in the same
BLOB.
--
Paul Van House
remove ".removeme" for e-mail replies
Radio/TV Software and Baseball Stat Software:
http://www.binxsoftware.com
Family Home Page: http://vanhouse.binxsoftware.com
Church Home Page: http://www.ashfordumc.org
| |
| Ken Mayer [dBVIPS] 2006-02-20, 8:23 pm |
| Paul Van House wrote:
> In article <WG1JFSkNGHA.2292@news-server>, nobody@nowhere.com says...
>
>
>
> Too much work. <G>. Easier to create a child table for the other
> BLOBS.
>
> Have you had problems with multiple memo/Binary fields in the same BLOB
> file. A post on the other newsgroup indicated it was not a good idea.
> I've only had very rare problems with memo fields over the years but
> can't recall off hand if I've mixed "binary" and "memo" in the same
> BLOB.
I disagree with the folk who claim there's an issue. I haven't heard of
memo (or BLOB) corruption in a long time. I think this used to occur
more in the dBASE/DOS and 16-bit versions. But the 32-bit BDE has not
been giving these issues for some time. That's not to say it never
happens, but it's a lot more rare ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
|
|
|