[Logic] QSL=F problem

aluscre [email protected]
Tue, 25 Jun 2002 13:17:35 -0400


Dennis
We spoke on Tuesday morning about problem I was having, I have solved it 
but here is information.

1. I had run the attached report "qsl card k8zt_multip.REP"
2. It printed QSL cards for all stations worked with multiple QSO's only 
(not those with single QSO)
3. When it marked QSL_SENT as "F" it marked all QSO's in the log as "F" 
including single QSO's stations

I was able to solve the problem by doing the following:
1. I removed all "F" from QSL _SENT using mass replace from Database 
Command Screen
2. I ran the "qsl card k8zt_multip.REP" again, _but chose to print it to 
a text file_
3. I  opened resulting text file, copied all then pasted data into Excel 
spread sheet
4. Using Excel's sort function I isolated the callsigns only and removed 
all the extraneous text
5. I then used Excel's Concatenate function to create following 
statement for each callsign:
replace qsl_sent with "F" for CALL='3B8FG'
replace qsl_sent with "F" for CALL='3G0Y'
replace qsl_sent with "F" for CALL='3V8BB'
etc. for entire list
6. I then created text file with first two lines:
SET EXCLUSIVE ON
USE ("C:\LOGic6\Logdata\LOG.DBF")
7. I then copied and pasted the column of replace qsl_sent with "F" for 
CALL='XXXX' statements into text file and saved file as f_multi.prg
7. I then ran COMPILE F_MULTI.PRG from Database Command  screen
8. I then ran the COMPILE F_MULTI.FXP from misc. commands
9. All calls with multi QSO's were marked with QSL_SENT= "F" and single 
QSO's were blank.

If you could look at the attached reports and fix them so they print 
both multi QSO cards and single QSO cards that would be great for future 
QSL card printings.

Thanks
Anthony


-- 
|--------------------------|
     Anthony A. Luscre    
            K8ZT      
        Stow, Ohio	  
|--------------------------|
    Visit My Website at
  http://www.qsl.net/k8zt
|--------------------------|




--- StripMime Report -- processed MIME parts ---
multipart/mixed
  multipart/alternative
    text/plain (text body -- kept)
    text/html
  application/octet-stream
  application/octet-stream
The reason this message is shown is because the post was in HTML
or had an attachment. Attachments are not allowed.
Please post in Plain-Text only.---