节日快乐 SqlStmt = "INSERT INTO Record (R_ID,R_Name,R_ProPrice,R_Number,R_Total,R_Time) VALUES ( '" & R_ID & "','" & R_Name & "'," & R_ProPrice & "," & R_Number & "," & R_Total & ",'" & R_Time & "')"那里错了??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 '定义Public R_ID As StringPublic R_Name As StringPublic R_ProPrice As DoublePublic R_Number As IntegerPublic R_Total As DoublePublic R_Time As Date'调用With MyRecord.R_ID = Trim(Text1.Text).R_Name = CurStore.S_Name.R_ProPrice = CurStore.S_Each_Price.R_Number = Val(Text2.Text).R_Total = CurStore.S_Each_Price * Val(Text2.Text).R_Time = Format(Now, "yyyy-mm-dd").insert '添加销售记录 ,错处 end with'函数Public Sub insert()DB_ConnectSqlStmt = "insert into Record values ( '" & R_ID & "','" & R_Name & "'," & R_ProPrice & "," & R_Number & "," & R_Total & ",'" & R_Time & "')"OdbcExt (SqlStmt)Rc = SQLFreeStmt(Hstmt, SQL_DROP)DBapi_DisconnectEnd Sub在调用的时候出错,为什么?我老是找不到 怎么让["&这几个符号作为字符出现? vsFlexGrid的问题,显示数据不正确. 请教一个URL的问题 新手提问,关于数据库浏览、插入图片的问题[急急急] 怎么样能在VB程序中播放动态的GIF? 很简单的问题,进来看看,有分! 如何读取机器CPU型号 如何保留 Single 型数据的小数位数 为什么listbox不能显示单片机通过wifi模块发送来的信息 紧急求救,高手救命啊 SendMessage Handle, WM_USER + 18, 0, 0具体什么作用 如何创建一个特殊圆矩形区域?(顶端两个角为圆弧形,底端两个角为90度角)
'定义
Public R_ID As String
Public R_Name As String
Public R_ProPrice As Double
Public R_Number As Integer
Public R_Total As Double
Public R_Time As Date'调用
With MyRecord
.R_ID = Trim(Text1.Text)
.R_Name = CurStore.S_Name
.R_ProPrice = CurStore.S_Each_Price
.R_Number = Val(Text2.Text)
.R_Total = CurStore.S_Each_Price * Val(Text2.Text)
.R_Time = Format(Now, "yyyy-mm-dd")
.insert '添加销售记录 ,错处
end with'函数
Public Sub insert()
DB_Connect
SqlStmt = "insert into Record values ( '" & R_ID & "','" & R_Name & "'," & R_ProPrice & "," & R_Number & "," & R_Total & ",'" & R_Time & "')"
OdbcExt (SqlStmt)
Rc = SQLFreeStmt(Hstmt, SQL_DROP)
DBapi_Disconnect
End Sub在调用的时候出错,为什么?我老是找不到