OleinsertCommand.commandtext =
"INSERT INTO GCM_SORYO (MISE_CD, BUMON_CD, TEI_ZOKU," // "are a string, and the back sign indicates the string after the connection.
"Haiso_chiku_cd, mos_cart_cd, soryo, kinshi_flg, ins_ymd,"
"INS_HMS, LST_UPDTS, UPDT_KAI, LST_UPDT_YMD, LST_UPDT_HMS"
"VALUES ('" // "inside is still a complete string, and then connected to a string again
Argcsdata.csoprtityLst [0] .misecd "','" // Variable itself is a string type, no need to add "" "" "" "" directly ", the string content is ',', then continue Connect the next string
Argcsdata.csoprtityLst [0] .bumoncd "','"
Argcsdata.csoprtityLst [0] .teizoku "','"
Argcsdata.csoprtityLst [0] .haisoucd "','" // Oracle field, must add ''
Argcsdata.csoprtityLst [0] .Moscartcd ","
Argcsdata.csoprtityLst [0]. Soryo ","
Argcsdata.csoprtitylst [0] .kinshiflg ","
"To_char (sysdate, 'yyyymmdd'),"
"To_char (sysdate, 'hh24miss')," "" "
Argcsdata.csoprtityLst [0] .lstupdts ", 1,"
"To_char (sysdate, 'yyyymmdd'),"
"To_char (sysdate, 'hh24miss')"; // on string to_char (sysdate, 'hh24miss')))
