You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
je rencontre l'erreur suivante lorsque je réalise un import EDIGEO + MAJIC 2021 via une base spatialite:
- Traitement:
Erreur rencontrée pour la requête:
-- Traitement: INSERT INTO pevlissage ( pevlissage, annee, ccodep, ccodir, ccocom, invar, dnupev, mlbcom, mlbsyn, mlbcu , mlbdep, mlbts1, mlbts2, mlbtas, mlbgem, mlbtom, tbfpas, mlbtfc, pev, lot ) SELECT DISTINCT REPLACE(SUBSTR(tmp,1,3)||SUBSTR(tmp,7,10)||SUBSTR(tmp,28,3),' ', '0') AS pevlissage, '2021', SUBSTR(tmp,1,2) AS ccodep, SUBSTR(tmp,3,1) AS ccodir, SUBSTR(tmp,4,3) AS ccocom, SUBSTR(tmp,7,10) AS invar, SUBSTR(tmp,28,3) AS dnupev, CASE WHEN trim(SUBSTR(tmp,36,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,36,11) AS float) END AS mlbcom, CASE WHEN trim(SUBSTR(tmp,48,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,48,11) AS float) END AS mlbsyn, CASE WHEN trim(SUBSTR(tmp,60,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,60,11) AS float) END AS mlbcu, CASE WHEN trim(SUBSTR(tmp,72,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,72,11) AS float) END AS mlbdep, CASE WHEN trim(SUBSTR(tmp,84,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,84,11) AS float) END AS mlbts1, CASE WHEN trim(SUBSTR(tmp,96,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,96,11) AS float) END AS mlbts2, CASE WHEN trim(SUBSTR(tmp,108,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,108,11) AS float) END AS mlbtas, CASE WHEN trim(SUBSTR(tmp,120,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,120,11) AS float) END AS mlbgem, CASE WHEN trim(SUBSTR(tmp,132,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,132,11) AS float) END AS mlbtom, CASE WHEN trim(SUBSTR(tmp,144,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,144,11) AS float) END AS tbfpas, CASE WHEN trim(SUBSTR(tmp,168,11))='' THEN NULL ELSE CAST(SUBSTR(tmp,168,11) AS float) END AS mlbtfc, REPLACE(SUBSTR(tmp,1,3)||SUBSTR(tmp,7,10)||SUBSTR(tmp,28,3),' ', '0') AS pev, '71' AS lot FROM bati WHERE SUBSTR(tmp,31,2) ='52'
Erreur
table pevlissage has no column named mlbtfc
FINALISATION
J'imagine que mon paramétrage n'est pas bon mais je ne sais pas identifier ou est mon erreur au vu de ce message.
Si quelqu'un peut m'aiguiller...
Merci d'avance !
Thomas
The text was updated successfully, but these errors were encountered:
Bonjour,
je rencontre l'erreur suivante lorsque je réalise un import EDIGEO + MAJIC 2021 via une base spatialite:
J'imagine que mon paramétrage n'est pas bon mais je ne sais pas identifier ou est mon erreur au vu de ce message.
Si quelqu'un peut m'aiguiller...
Merci d'avance !
Thomas
The text was updated successfully, but these errors were encountered: