WHEN YOU RETRIEVE it, how do you know when you have all f it?

-----Original Message-----

From: Eurico Chagas Filho [mailto:e28chagas@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 <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/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.