I am trying to extract my logs in the proper cabrillo QSO: format for the IARU contest, using the following SQL statement:
SELECT 'QSO:', freq, 'PH', qsodate, time_on, 'AB1KW 59 08', call, remarks FROM cqrlog_main WHERE qsodate > '2010-07-10' ORDER BY qsodate,time_on
However, this results in the following error message:
SQL error:Duplicate name 'CONSTANT' in TFieldDefs
Would it be an idea to give each constant field a number (CONSTANT1, CONSTANT2, etc) so firebird does not error out?
Or is the fix in the firebird code itself?
On a related note, I wonder if cqrlog needs two exchange fields for a contest, so those can be automatically exported in contests where eg. a serial number is required.
Exporting of cabrillo QSO: lines could be achieved by storing appropriate SQL macros - no need to add programming for that.