Const SelectListino = "SELECT RIGHT(FCANPCS0.PCS_MGLST,3) , FCANPCS0.PCS_REPID, FCANPCS0.PCS_PC1PZ/1000, FCANPCS0.PCS_PC2PZ/1000, FCANPCS0.PCS_PC3PZ/1000, FCANPCS0.PCS_PC1DT, iif(FCANPCS0.PCS_PC2PZ<>0,FCANPCS0.PCS_PC2DT,Null) , iif(FCANPCS0.PCS_PC3PZ<>0,#01/01/1980#,Null), '0' & Left([PCS_REFID],1) AS Espr1, '0' & Mid([PCS_REFID],2,1) AS Espr2, '0' & Mid([PCS_REFID],3,2) AS Espr3, '0' & Right([PCS_REFID],2) AS Espr4, FCANPCS0.PCS_REFID FROM FCANPCS0"

io voglio settare FCANPCS0.PCS_PC1DT e FCANPCS0.PCS_PC2DT come dd/mm/yyyy

x' poi ho:
Const InsertListino = "CD_AFFL, CD_REPR, VL_PREZ_CESS, VL_PREZ_CES1, VL_PREZ_CES2, DT_PREZ_VARN, DT_PREZ_VAR1, DT_PREZ_VAR2, CD_LINE, CD_CATG, CD_ARTC, CD_VARN, CD_REFR"

poi, in una funzione che inserisce dati, viene creata la query d'inserimento