LOGic Forum
»
LOGic Support
»
Logbook of The World
»
LOTW SENT Field Database command question
Rank: Newbie
Groups: Registered
Posts: 2
Location: Ontario
|
I am unable to post this question in the Database Command section so I thought this might be an appropriate place to ask.
I am using Logic 8.0.104 and as I am no longer able to upload LOTW info automatically I have been doing it manually. However I have a bunch of contacts uploaded and would like to change the LOTW_SENT field to Y for all of them at once.
I have tried following the directions in the help files and cannot seem to get the database modification commands right.
Here is one of my command sequence attempts:
use log
replace LOTW_SENT with LOTW_SENT ='T' for
BETWEEN(QSO_DATE,{^2014-11-01},{^2014-11-03})
I get an error message "Operator/operand type mismatch"
I believe the error is in the syntax of the first line and have tried some substitutions but cannot get it to work.
Can someone please point me in the right direction.
73
Rick VE3MM
|
|
|
|
|
|
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
|
|
|
Rank: Administration
Groups: Administrators, Beta Testers Posts: 3,097  Location: Auburn, GA Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
|
Try this:
USE LOG
REPLACE LOTW_SENT WITH .T. FOR BETWEEN(QSO_DATE,{^2014-11-01},{^2014-11-03})
I would just keep it simple and change them all:
REPLACE ALL LOTW_SENT WITH .T.
Tnx & 73,
DH WN4AZY
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 2
Location: Ontario
|
That worked fine. Thanks for the correction.
73
Rick VE3MM
|
|
|
|
|
|
LOGic Forum
»
LOGic Support
»
Logbook of The World
»
LOTW SENT Field Database command question
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.
