View previous topic :: View next topic |
Author |
Message |
KawaiiStar
Joined: 02 Aug 2007 Posts: 4 Location: Florida
|
Posted: Fri Aug 03, 2007 6:41 pm Post subject: Filter and Suggestions |
|
|
Sorry, I only speak English. Hopefully someone can still help me.
I wanted to know if when applying a filter there's another setting or special character to make the filter EXCLUDE records that apply to it. Are there any other special characters that can be used in filtering (example, * as a wild card)
As for suggestions...
1. Better control over reconstruction of database. Be able to "insert" a field between other fields without messing up the current database. Be able to change the "type" of current field. Be able to easily rearrange field order.
2. Be able to set certain fields to have more lines viewable (or greater box height) for ones that will contain a lot of text or information.
3. Control for where and how the image attached to a record is viewed.
This is a very convenient program so thank you for it.
- Sarah
|
|
Back to top |
|
|
ale Site Admin
Joined: 12 Apr 2005 Posts: 499 Location: Versailles, France
|
Posted: Sun Aug 05, 2007 9:08 pm Post subject: |
|
|
Hi Sarah
There is no straight solution to the EXCLUDE operation.
You can use the greater than (>) and smaller than (<) operators.
For instance, if the string to be excluded is always in the same position, you can write you argument with :
Substring(F02,4,5) < 'Table' or Substring(F02,4,5) > 'Tablf'
All records with the word "Table" in position 4 to 9 will be excluded.
Thank you for you suggestions, they will be useful if there is a further version of SmartDB. |
|
Back to top |
|
|
KawaiiStar
Joined: 02 Aug 2007 Posts: 4 Location: Florida
|
Posted: Tue Aug 07, 2007 1:56 am Post subject: |
|
|
I had no idea how the argument worked, so this is new to me. What indicates which field it should refer to or what does the "position" refer to? (the 4 to 9)
Say I have one field labeled "Volumes" that is the fourth field down and I want to exclude the ones that say"One Shots," how would I put that in the argument?
Thank you very much for your response Again I really appreciate this program. I haven't found any other quite like it. |
|
Back to top |
|
|
ale Site Admin
Joined: 12 Apr 2005 Posts: 499 Location: Versailles, France
|
Posted: Tue Aug 07, 2007 6:09 am Post subject: |
|
|
If your fourth field contains only "One Shots", you can use :
F04 < 'One Shots' or F04 > 'One Shott'
If your fourth field starts with "One Shots", you can use :
Substring(F04,1,9) < 'One Shots' or Substring(F04,1,9) > 'One Shott'
F04 means : Use field 4
1 means : Compare with the character string starting at character 1
9 means : Compare a string of 9 characters long
For instance, you can use something like :
F03 IS NOT NULL and (Substring(F04,1,9) < 'One Shots' or Substring(F04,1,9) > 'One Shott')
Happy testing
|
|
Back to top |
|
|
KawaiiStar
Joined: 02 Aug 2007 Posts: 4 Location: Florida
|
Posted: Tue Aug 07, 2007 2:08 pm Post subject: |
|
|
Thanks so much for breaking it down for me. Will help a lot.
-sarah |
|
Back to top |
|
|
|