共5 条记录, 每页显示 10 条, 页签:
[1]
[浏览完整版]
标题：插入数据报错
1楼
lds 发表于：2024/5/16 18:10:00For Each dr As DataRow In DataTables("批发价").DataRows
Dim rqi As Date = cmd.CommandText = " insert into {init_LKY_AMBNBJYJ}(INIT_INDEX,adate) values (" & dr("INIT_INDEX") & "," & Format(dr("日期"), "yyyy-mm-dd") & " )"
cmd.ExecuteNonQuery()
Next
转换日期类型报错
转换日期类型报错2楼
lds 发表于：2024/5/16 18:18:00oracle 数据库 
3楼
lds 发表于：2024/5/16 18:23:00Dim rqi As Date = cmd.CommandText = " insert into {init_LKY_AMBNBJYJ}(INIT_INDEX,adate) values (" & dr("INIT_INDEX") & ",'" & dr("日期") & "' )"
转文本也报错
转文本也报错4楼
有点蓝 发表于：2024/5/16 20:20:00https://www.baidu.com/s?wd=orale%20insert%20into%20%E6%97%A5%E6%9C%9F
Dim rqi As Date = cmd.CommandText = " insert into {init_LKY_AMBNBJYJ}(INIT_INDEX,adate) values (" & dr("INIT_INDEX") & ",TO_DATE('" & Format(dr("日期"), "yyyy-MM-dd") & "', 'YYYY-MM-DD'))"
Dim rqi As Date = cmd.CommandText = " insert into {init_LKY_AMBNBJYJ}(INIT_INDEX,adate) values (" & dr("INIT_INDEX") & ",TO_DATE('" & Format(dr("日期"), "yyyy-MM-dd") & "', 'YYYY-MM-DD'))"
5楼
lds 发表于：2024/5/17 11:34:00收到谢谢
共5 条记录, 每页显示 10 条, 页签:
[1]