Fields QSL sent/rcvd via

Yes, sometimes it happens... Please report any bugs here
Locked
PB4FUN
Advanced Class
Posts: 78
Joined: 27 Feb 2014, 18:20
Location: JO33KC
Contact:

Fields QSL sent/rcvd via

Post by PB4FUN »

If you edit a QSO and set either the field QSL sent via or QSL received via to e.g. Via Bureau and store it, you cannot undo it to null.
PB4FUN Meindert; Rig : Icom IC-9100 / Ant: Falcon OUT-250-B @4m AGL; 144 MHz 16 el @ 4m AGL; 70 cm 23 el @ 5 m AGL
User avatar
G4POP
Log4OM Alpha Team
Posts: 10750
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Fields QSL sent/rcvd via

Post by G4POP »

I have just tried this and it worked without issue!

Please detail where and how you are setting and un-setting the QSL status
73 Terry G4POP
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Fields QSL sent/rcvd via

Post by IW3HMH »

Using drop down lists it's correct: you cannot "undo" to null.
This is because those fields are mandatory, and because they cover all possible situations. The field "received via" doesn't make sense if the QSL has not been received yet, and should be ignored.
Daniele Pistollato - IW3HMH
PB4FUN
Advanced Class
Posts: 78
Joined: 27 Feb 2014, 18:20
Location: JO33KC
Contact:

Re: Fields QSL sent/rcvd via

Post by PB4FUN »

[QslSentVia] nvarchar(50) NULL,

What is mandatory about that ?
And ofcourse it is possible to set a db field to null again when you have a cbo textvalue of ""
PB4FUN Meindert; Rig : Icom IC-9100 / Ant: Falcon OUT-250-B @4m AGL; 144 MHz 16 el @ 4m AGL; 70 cm 23 el @ 5 m AGL
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Fields QSL sent/rcvd via

Post by IW3HMH »

One thing is how the field is made, one is how the field is used by the software. When I set blank I will not set field as null.
Anyway I will check if allowing blank in this field is ok. Theoretically if the field is an enumeration it must (or, maybe, it's better) if it has a value on it... but we know ADIF has some design flaws :-)
Daniele Pistollato - IW3HMH
PB4FUN
Advanced Class
Posts: 78
Joined: 27 Feb 2014, 18:20
Location: JO33KC
Contact:

Re: Fields QSL sent/rcvd via

Post by PB4FUN »

TQSent = enum (qslNothing = 0, qslViaBurea = 2, qslViaLotW = 4, qslViaEQSl = 8, qslDirect = 16)

Using this structure you can even mark sending/receiving QSL by multiple ways.
In that case you can mark the QSL sent by 14 and received by 18

Or you can set it back to 0 :-)

If you do so you might have some issues with the date sent/received that will be dates and need more fields or a seperate table with those multiple dates.
PB4FUN Meindert; Rig : Icom IC-9100 / Ant: Falcon OUT-250-B @4m AGL; 144 MHz 16 el @ 4m AGL; 70 cm 23 el @ 5 m AGL
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Fields QSL sent/rcvd via

Post by IW3HMH »

Yes, i know the use of flags :D
The "main" limit is due to our base choice, that was (initially) to make a database based on ADIF format, and strictly related to this.

This approach was good enough for some years, but now it's a little bit too strict for our needs, and we're about to leave this strong relation.
One of our "limits" is we must keep compatibility and be able to reconstruct the whole database from an adif import. We can use "application fields" in adif export, but those fields are of limited use. Also changing the database structure it's not so easy, if you want to keep a flawless migration between different user versions :)
Daniele Pistollato - IW3HMH
PB4FUN
Advanced Class
Posts: 78
Joined: 27 Feb 2014, 18:20
Location: JO33KC
Contact:

Re: Fields QSL sent/rcvd via

Post by PB4FUN »

Sure,but with an import you have only one, and with an export you can let the user decide in the settings with a preferred sent/received by.
In that case if you have 18 as flag check in the settings what of those is most preferred, and if direct > Bureau export the Direct value to adif.
PB4FUN Meindert; Rig : Icom IC-9100 / Ant: Falcon OUT-250-B @4m AGL; 144 MHz 16 el @ 4m AGL; 70 cm 23 el @ 5 m AGL
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Fields QSL sent/rcvd via

Post by IW3HMH »

what about exporting this field only when received is YES or VERIFIED? :)

73
Daniele
Daniele Pistollato - IW3HMH
Locked