Fields QSL sent/rcvd via
Fields QSL sent/rcvd via
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
- G4POP
- Log4OM Alpha Team
- Posts: 10822
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: Fields QSL sent/rcvd via
I have just tried this and it worked without issue!
Please detail where and how you are setting and un-setting the QSL status
Please detail where and how you are setting and un-setting the QSL status
73 Terry G4POP
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: Fields QSL sent/rcvd via
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.
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
Re: Fields QSL sent/rcvd via
[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 ""
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
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: Fields QSL sent/rcvd via
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
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
Re: Fields QSL sent/rcvd via
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.
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
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: Fields QSL sent/rcvd via
Yes, i know the use of flags
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
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
Re: Fields QSL sent/rcvd via
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.
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
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: Fields QSL sent/rcvd via
what about exporting this field only when received is YES or VERIFIED?
73
Daniele
73
Daniele
Daniele Pistollato - IW3HMH