pcsoft.us.windevCopyright 2026, PC SOFT13 Jun 2017 20:38:00 Z11 Jun 2017 12:09:00 ZWB20 Hi, I'm keen to use the Full Text Index facility for a project I'm working on, but it looks like it can only be used on individual data files? I always design my data tables on 3rd normal form principles to avoid duplication of data storage, but it looks like I will have to compromise on this if I want to use the FTI facility, or am I missing something? For example, I have an order table with foreign keys for elements like customer, delivery address etc, so the customer name is not available on the order table to be used in a Full Text Index. Is there a way to use FTI's on a query for example? Cheers Reg30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61293/read.awp13 Jun 2017 20:38:00 ZHi Joris, I thought that I can define a full text index for an analysis file only. How do you define the FTI for a query? …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61293/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61293/read.awpFull Text Index vs Database Designguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61291/read.awp13 Jun 2017 14:02:00 ZHi Guenter, mine works with a dictionary file, supports exact and fuzzy searches, multilingual content, can index any field o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61291/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61291/read.awpFull Text Index vs Database Designguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61288/read.awp13 Jun 2017 09:26:00 ZHi Fabrice, I did the same for small files, the user can input up to three words to search for. It's fixed on "AND" and inserts …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61288/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61288/read.awpFull Text Index vs Database Designguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61258/read.awp12 Jun 2017 14:00:00 ZHi I tried and discarded the full text index provided by pcsoft because it's just too limited. So I built my own full text…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61258/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61258/read.awpFull Text Index vs Database Designguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61253/read.awp12 Jun 2017 09:47:00 ZHi, I've decided to go about this in a different way and not use the FTI concept, but thanks for the input. Kind Regards …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61253/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61253/read.awpFull Text Index vs Database Designguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61255/read.awp12 Jun 2017 09:09:00 ZHi, It should work as you describe. Did you already try to create a query that way? I'm using FTI's in some queries and it w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61255/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61255/read.awpFull Text Index vs Database Designguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61250/read.awp11 Jun 2017 22:49:00 ZHi Reg, I cannot answer your actual question, but would like to give you a heads up on Windev's FTI in general. The full t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61250/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61242-full-text-index-database-design-61250/read.awpFull Text Index vs Database Design