I am facing this problem. This is the insert statement. The error seems to be with the column "ST4_1_ErroreDatamatrixInleggibile" that is 33 characters long . I am importing records from an automatic testing device and columns are named that way. Really the name of a column must be shorter than 33 characters? The database is SqlServer and doing that insert with Management Studio or other software, all is ok. With TD or SqlTalk not. Really? 32 characters?
Any solution? Thank you.
Code: Select all
Error: 00910 PRS ITL Identifier too long
Reason: An identifier exceeds 36 characters.
Remedy: Correct the identifier that exceeds 36 characters.
insert into aaa (c_stabilimento, Id,DataOraInizioBindello,Bindello,CodiceRosa,NomeArticolo,DatamatrixPezzo,DataOraLavorazionePezzo,EsclusioneDataMatrixViaRulli2,
EsclusioneStazione0,EsclusioneStazione1_1,EsclusioneStazione2_1,EsclusioneStazione3_1,EsclusioneStazione4_1,EsclusioneConfocale4_1,EsclusioneTelecamera4_1
,EsclusioneDatamatrix4_1,EsclusioneStazione5_1,EsclusioneStazione6_1,EsclusioneStazioneATEQ,ST4_1_SetIntensita,ST4_1_SetTolleranzaIntensita,
ST4_1_MemoIntensita,ST4_1_SelezioneTest1_2,ST4_1_SelezioneTest2_3,ST4_1_SelezioneTest1_3,ST4_1_Set_Layer1,ST4_1_Set_Layer2,ST4_1_Set_Layer3,
ST4_1_SetDelta1_2,ST4_1_SetDelta2_3,ST4_1_SetDelta1_3,ST4_1_SetTolleranza_Misura,ST4_1_Memo_Delta1_2,ST4_1_Memo_Delta2_3,ST4_1_Memo_Delta1_3,
ST4_1_SetTolleranza1_2Positiva,ST4_1_SetTolleranza1_2Negativa,ST4_1_SetTolleranza2_3Positiva,ST4_1_SetTolleranza2_3Negativa,
ST4_1_SetTolleranza1_3Positiva,ST4_1_SetTolleranza1_3Negativa,ST6_1_SetRotazione,ST6_1_SetTempoTotale,ST6_1_SetImpulsiR80,ST6_1_SetImpulsiR100,
ST6_1_SetImpulsiR160,EsitoGlobale,ST0_Scarto,ST0_ErroreChiusura,ST0_ErroreCoordinate,ST3_1_Scarto,ST4_1_Scarto,ST4_1_ErroreDatamatrixDoppio,
[b]ST4_1_ErroreDatamatrixInleggibile[/b], ST4_1_ErroreMagnete_TLC,ST4_1_ErroreAltezzaHotFoil,ST4_1_ErroreAssenzaHotFoil,ST5_1_Scarto,
ST5_1_ErroreAllineamentoLancetta,ST5_1_ErroreIngranaggi,ST5_1_ErroreColore,ST5_1_ErroreDiametroPignoni,ST5_1_ErroreHotFoilIncompleto,
ST5_1_ErroreAssenzaHotFoil,ST6_1_Scarto,ST6_1_EsitoR80,ST6_1_EsitoR100,ST6_1_EsitoR160,ST3_2_MemoPerdita,ST3_2_MemoPressione,ST3_2_Scarto,
ST3_2_SetProgrammaATEQ,EsclusioneDatamatrix6_1,EsclusioneSerialNumber6_1,SerialNumberPezzo)
values
('PRC','971214', '2022-11-30 18:17:34.3625650 +01:00', '', '', '1901', '1901000000021580', '2022-11-30 18:17:34.3625650 +01:00', '0', '0', '0', '0', '1', '1', '1', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0,8954986', '0,5751812', '1,478508', '0', '0', '0', '0', '0', '0', '300', '4000', '73', '73', '73', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0','0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-13', '90,7', '0', '1', '0', '0', '29A89D041600140000000000'
);