Afternoon all;
I am running the following union query which has been working until today:
SELECT sund_main_ref AS REF,sund_main_folio AS FOLIO, "SUND" AS SUFFIX,sund_main_comment AS COMMENT
FROM tbl_sund_main
UNION ALL SELECT m_ref,m_folio,"POST" AS SUFFIX,m_declared_contents
FROM tbl_postcharge_main
UNION ALL SELECT occ_main_ref,occ_main_folio,"OCC" AS SUFFIX,occ_uk_comment
FROM tbl_OCC_main
UNION ALL SELECT rep_ref,rep_trader,"REPAY" AS SUFFIX,rep_comments
FROM tbl_repay
UNION ALL SELECT C18_ID,C18_folio,"C18" AS SUFFIX,C18_agents_ref
FROM tbl_C18
UNION ALL SELECT seq,folio,"CARS" AS SUFFIX,make&": "&model
FROM tbl_details_cars;
Unfortunately today for some reason it is showing the following error:
'The width of a Unicode text column must be an even number of bytes'
Could anyone shed some light on this error? I have already carried out a compact and repair on this database, and all the tables mentioned in the above sql query open without fault. :banghead:
Regards
Tor Fey
I am running the following union query which has been working until today:
SELECT sund_main_ref AS REF,sund_main_folio AS FOLIO, "SUND" AS SUFFIX,sund_main_comment AS COMMENT
FROM tbl_sund_main
UNION ALL SELECT m_ref,m_folio,"POST" AS SUFFIX,m_declared_contents
FROM tbl_postcharge_main
UNION ALL SELECT occ_main_ref,occ_main_folio,"OCC" AS SUFFIX,occ_uk_comment
FROM tbl_OCC_main
UNION ALL SELECT rep_ref,rep_trader,"REPAY" AS SUFFIX,rep_comments
FROM tbl_repay
UNION ALL SELECT C18_ID,C18_folio,"C18" AS SUFFIX,C18_agents_ref
FROM tbl_C18
UNION ALL SELECT seq,folio,"CARS" AS SUFFIX,make&": "&model
FROM tbl_details_cars;
Unfortunately today for some reason it is showing the following error:
'The width of a Unicode text column must be an even number of bytes'
Could anyone shed some light on this error? I have already carried out a compact and repair on this database, and all the tables mentioned in the above sql query open without fault. :banghead:
Regards
Tor Fey