请看一下我写的SQL语句,有什么问题吗?
我在VB里写的SQL语句,我觉得没有毛病,但是它一直报错,说语法错误,请各位高手指教!
insert into HUMANDATA(NAME,NUMBER,SEXID,AGE,BIRTHDAY,RUNDEGREEID,SPORTITEMID,PLACEID,IDCARD) " _
& " values " _
& "('" & Trim(Txt(0).Text) & "'," _
& " '" & Trim(Txt(1).Text) & "'," _
& " " & 0 & "," _
& " " & DateDiff("yyyy", DTPker.Value, Now()) & "," _
& " # " & DTPker.Value & " #," _
& " " & Rid & " ," _
& " " & Sid & " ," _
& " " & Pid & " ," _
& " '" & Trim(Txt(2).Text) & "')"