vb insert access时间错在哪

来源:百度知道 编辑:UC知道 时间:2024/06/30 15:49:01
lsql = ""
lsql = lsql & "Insert into"
lsql = lsql & " T_日报"
lsql = lsql & " ("
lsql = lsql & " T_日报.日付"
lsql = lsql & " ,T_日报.时间"
lsql = lsql & " ,T_日报.场所"
lsql = lsql & " ,M_社员.名前"
lsql = lsql & " ,T_日报.内容"
lsql = lsql & " )"
lsql = lsql & " values"
lsql = lsql & " ("
lsql = lsql & " #"
lsql = lsql & TxtDate.Text
lsql = lsql & "#"
lsql = lsql & " ,#"
lsql = lsql & TxtTime.Text
lsql = lsql & "#"
lsql = lsql & " ,"""
lsql = lsql & TxtAdress.Text
lsql = lsql & """"
lsql = lsql & " ,"""
lsql = lsql & ComName.Text
lsql = lsql & &

“M_社员.名前” 这是其他表的列,是不能通过对“T_日报”的操作完成的。和你输入的时间没什么关系的,ADO会自动转换时间格式地。我忘记如何多表插入操作了,建议你分开俩个语句进行操作。