New Software Announcement - SIXTH SENSE

[tcorbin16]

ben i looked on the 6th sense forums to look for a guide on how to filter out the CAP games on ftp, but the thread was garbage....

can you tell me what i have to do to filter them out?

[SixthSense]

[ QUOTE ]
ben i looked on the 6th sense forums to look for a guide on how to filter out the CAP games on ftp, but the thread was garbage....

can you tell me what i have to do to filter them out?

[/ QUOTE ]

Using the "Filter Table" popup menu on the table list, add a filter like:

Upper(TableName) not like '%[CAP]%'

-Ben

[tcorbin16]

so i would type....

Upper(CAP) and then it filters out all of them?

[SixthSense]

[ QUOTE ]
so i would type....

Upper(CAP) and then it filters out all of them?

[/ QUOTE ]

No, you would type it exactly as I put it:

Upper(TableName) not like '%[CAP]%'

It will then filter out all tables that have "[Cap]" in the tablename.

[tcorbin16]

i just copy/pasted what you put and i get some error sayin

Tables: Field 'TableName' not found....

now i just copied/pasted Upper(TableName) not like '%[CAP]%'

that into the filter.

[SixthSense]

[ QUOTE ]
i just copy/pasted what you put and i get some error sayin

Tables: Field 'TableName' not found....

now i just copied/pasted Upper(TableName) not like '%[CAP]%'

that into the filter.

[/ QUOTE ]

Change TableName to Table, see if that works.

[tcorbin16]

"Filter expression incorrectly terminated"

when i change tablename to table.

[Echelon]

same here

[SixthSense]

[ QUOTE ]
"Filter expression incorrectly terminated"

when i change tablename to table.

[/ QUOTE ]

This exact string below works for me:

not upper(table) like '%[CAP]%'

Note the parenthesis, tick marks, brackets, and percent signs must all be correct.

One more thing, this goes into the "Filter Table" menu, CTRL-R

[Echelon]

working thanks