Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 14 of 14 total |
A small slew of questions about full text indexing & CONTAINS |
Sat, Dec 1 2007 11:29 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>In that case, just define a text filter for 'Email' and set up a text filter >column that contains the value 'Email' for all rows. I think I may have cracked it - use a "virtual" column. I think computed but please tell me if I'm wrong. Slightly off topic. I added a computed field to a table, set its value to 'HTML', checked in the grid and there it was, seems to have worked with the text filter but I then went to open the EDBTbl file just to make sure the data wasn't being stored and I can't read it in Notepad. Whichever of the EDBTbl files I opened ranging from ones I know are empty to ones with loads of data seem to have a header and mainly not printable characters. Are tables automatically being compressed or encrypted? Roy Lambert |
Mon, Dec 3 2007 7:46 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I think I may have cracked it - use a "virtual" column. I think computed but please tell me if I'm wrong. >> Computed is fine, you can index a computed column provided that the computed column is stable, i.e. it doesn't return a different value when called a second time with the same inputs. << Slightly off topic. I added a computed field to a table, set its value to 'HTML', checked in the grid and there it was, seems to have worked with the text filter but I then went to open the EDBTbl file just to make sure the data wasn't being stored and I can't read it in Notepad. Whichever of the EDBTbl files I opened ranging from ones I know are empty to ones with loads of data seem to have a header and mainly not printable characters. Are tables automatically being compressed or encrypted? >> No. Did you have textual data in them ? A hex editor might be a better bet for checking the EDB table files - NotePad is probably just truncating the text at the first NULL. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Dec 4 2007 3:19 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>No. Did you have textual data in them ? A hex editor might be a better bet >for checking the EDB table files - NotePad is probably just truncating the >text at the first NULL. See - I told you NULLs were more trouble than they're worth Roy Lambert |
Tue, Dec 4 2007 4:32 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< See - I told you NULLs were more trouble than they're worth >> I think we're talking about different NULLs. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |