Hi all FOX MANS
I have DBF for costumer data. one of that is address. some of address can very long about 250 character. and [highlight #FCE94F]everyday append about 50 new records to that.[/highlight]
In my application sometimes need to search address. I want to know which method is the best? MEMO or character?
If I used a fixed lenth character, maybe have a big DBF and larger everyday, and if I used MEMO field , HOW can search within memo that also enough speed. Also which way is the best?
1- sele * from dbf where ...
2- index on address for ...
3- set filter to at(address,xxx) > 0
and so on...
[highlight #FCE94F]Did this functions work in MEMO?[/highlight]
Can you refer me some data about this problem?
thanks alot for your good idea
FARZAD
I have DBF for costumer data. one of that is address. some of address can very long about 250 character. and [highlight #FCE94F]everyday append about 50 new records to that.[/highlight]
In my application sometimes need to search address. I want to know which method is the best? MEMO or character?
If I used a fixed lenth character, maybe have a big DBF and larger everyday, and if I used MEMO field , HOW can search within memo that also enough speed. Also which way is the best?
1- sele * from dbf where ...
2- index on address for ...
3- set filter to at(address,xxx) > 0
and so on...
[highlight #FCE94F]Did this functions work in MEMO?[/highlight]
Can you refer me some data about this problem?
thanks alot for your good idea
FARZAD