WHEN YOU RETRIEVE it, how do you know when you have all f it? -----Original Message----- From: Eurico Chagas Filho [mailto:e28cha...@yahoo.com.br] Sent: Wednesday, February 01, 2012 12:48 PM To: ProFox Email List Subject: Re: deleting a general field
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 <e28cha...@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:e28cha...@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.jeur...@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/CD6864DE309F498488A7C8529788FBD4@OwnerPC ** 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.
