Forum Forum Fortifications of the World
A web site about fortifications and freeware programs : Fortifications of the World
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Filter and Suggestions

 
Post new topic   Reply to topic    Forum Fortifications of the World Forum Index -> SmartDB
View previous topic :: View next topic  
Author Message
KawaiiStar



Joined: 02 Aug 2007
Posts: 4
Location: Florida

PostPosted: Fri Aug 03, 2007 6:41 pm    Post subject: Filter and Suggestions Reply with quote

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
Smile
Back to top
View user's profile Send private message
ale
Site Admin


Joined: 12 Apr 2005
Posts: 499
Location: Versailles, France

PostPosted: Sun Aug 05, 2007 9:08 pm    Post subject: Reply with quote

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
View user's profile Send private message
KawaiiStar



Joined: 02 Aug 2007
Posts: 4
Location: Florida

PostPosted: Tue Aug 07, 2007 1:56 am    Post subject: Reply with quote

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 Smile Again I really appreciate this program. I haven't found any other quite like it.
Back to top
View user's profile Send private message
ale
Site Admin


Joined: 12 Apr 2005
Posts: 499
Location: Versailles, France

PostPosted: Tue Aug 07, 2007 6:09 am    Post subject: Reply with quote

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
Wink
Back to top
View user's profile Send private message
KawaiiStar



Joined: 02 Aug 2007
Posts: 4
Location: Florida

PostPosted: Tue Aug 07, 2007 2:08 pm    Post subject: Reply with quote

Thanks so much for breaking it down for me. Smile Will help a lot.

-sarah
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Forum Fortifications of the World Forum Index -> SmartDB All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group