logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

indexing columns in browse form
W1DEE
#1 Posted : Monday, February 27, 2012 5:54:48 PM(UTC)
Rank: Newbie

Groups: Registered
Posts: 6
Location: Waterbury, CT

I was able to figure out how to index my band, and comment columns on the browse form in logic 8 but i can't seem to figure out how to do it again in logic 9. there are no specific instruction in the manual about indexing a column on the browse form. I want an asterisk to appear on more than the date and call columns so i can sort and index other columns in the form. How do I accomplish this?
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Tuesday, February 28, 2012 10:00:25 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,096
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)
Go to tools/advanced/index setup info. Add a new record (+ button).

For FILE enter LOG
For INDEX TAG enter BAND
for INDEX EXPRESSION enter BAND

GO to tools/database maintenance and do a REINDEX

Tnx & 73,

DH
W1DEE
#3 Posted : Tuesday, February 28, 2012 11:35:24 PM(UTC)
Rank: Newbie

Groups: Registered
Posts: 6
Location: Waterbury, CT

Originally Posted by: WN4AZY Go to Quoted Post
Go to tools/advanced/index setup info. Add a new record (+ button).

For FILE enter LOG
For INDEX TAG enter BAND
for INDEX EXPRESSION enter BAND

GO to tools/database maintenance and do a REINDEX

Tnx & 73,

DH


I was able to index band and dxcc columns using your directions but i am still unable to index my comment column.

right clicking the comment column i see "Comment_" as the name. and "logbook.comment" as the expression.

I click tools/advanced/indexsetup. I enter 'Log' and then 'comment_' in the tag. and i enter 'comment' in the expression but this does not work.

help. Joe
WN4AZY
#4 Posted : Wednesday, February 29, 2012 5:00:32 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,096
Man
Location: Auburn, GA

Thanks: 997 times
Was thanked: 497 time(s) in 412 post(s)
Please enter

LEFT(COMMENT, 128)

for the expression. There is a maximum index value length.

Tnx & 73,

Dennis WN4AZY
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.034 seconds.