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

Notification

Icon
Error

Database commands
AK3E
#1 Posted : Sunday, January 11, 2015 5:32:02 PM(UTC)
Rank: Newbie

Groups: Registered
Posts: 8

For some reason I'm not able to post in the bulk data change and database commands section so asking here. I have many qso's with QSL sent=R and QSL received=R and LOTW received=F. I want to change QSL sent and received to blank when LOTW received=F.
In the advanced database area I'm not sure what to put in the replace this field with to change it to blank. I think it should be "".
Thanks for any help with this.
Rick AK3E
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 : Monday, January 12, 2015 7:59:56 PM(UTC)
admin

Rank: Administration

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

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
Hi Rick:

If I follow you, this is what you want:

Quote:
USE LOG

REPLACE QSL_SENT WITH " " FOR LOTW_RCVD="F"

REPLACE QSL_RCVD WITH " " FOR LOTW_RCVD="F"


Make a backup first just to be safe!

Tnx/73,

Dennis WN4AZY
Users browsing this topic
Guest (2)
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.018 seconds.