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

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

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

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