Author: Eurico Chagas Filho
Posted: 2012-02-01 at 13:47:56
Yes and no. The table has two fields, code and text( C 250), if code is an integer field u
use multiple tables. But if code is a composite key, say table name and primary key, it could
be just one table.
E.
So you require multiple tables to store memo data?
>
>Michael Oke, II
>661-349-6221
>
>Contents of this and all messages are intended for their designated recipient.
>
>On Feb 1, 2012, at 6:14 AM, Eurico Chagas Filho <e28chagas@yahoo.com.br> wrote:
>
>> That's the thing i created a system of .dbf files that store in 255 characters fields all
>> the text. It's like a chain. I got some routines to save and to restore, the rest is the
>> same as if u had a memo.
>>
>> E.
>>
>>
>> Where do you put things like biographies or recipes... descriptions etc...
>>>
>>> -----Original Message-----
>>> From: Eurico Chagas Filho [mailto:e28chagas@yahoo.com.br]
>>> Sent: Tuesday, January 31, 2012 1:47 PM
>>> To: ProFox Email List
>>> Subject: Re: deleting a general field
>>>
>>> Now u r ready for the next fase, where u don't use memo fields anymore...
>>>
>>> E.
>>>
>>>
>>>
>>>
>>>> ________________________________
>>>> From: Gary Jeurink <g.jeurink@charter.net>
>>>> To: profox@leafe.com
>>>> Sent: Tuesday, January 31, 2012 5:40 PM
>>>> Subject: deleting a general field
>>>>
>>>> The saga of a rookie fixing early mistakes continues. With this forum's
>>>> advice, I no longer put photo's into a general field. I added one integer
>>>> field that stores a file-No that will locate the picture. The extra field
>>>> allows multiple records to share a photo in appropriate cases. Now I am
>>>> ready to delete the field that contained the photos. This will make a huge
>>>> difference on the size of this table.
>>>>
>>>>
>>>>
>>>> I have edited all views or connected tables to no longer use this field but
>>>> am I still looking at rebuilding every form that uses this table just
>>>> because the table record field list will change? Even if so, it will be
>>>> worth it as the storing pictures in general fields was unreliable as they
>>>> would occasionally swap photos with other records.
>>>>
>>>>
>>>>
>>>> Gary Jeurink
>>>>
>>>>
>>>>
>>>> --- StripMime Report -- processed MIME parts ---
>>>> multipart/alternative
>>>> text/plain (text body -- kept)
>[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/02E2FE69-A88F-4CD0-96B5-30AE283BC45B@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.
>
>
>
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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/1328122076.95359.YahooMailNeo@web160802.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.