mahak_f
سه شنبه 21 آذر 1385, 17:41 عصر
ممکنه طولانی بودن یه دستور باعث شه که اون دستور اجرا نشه؟ این دستور توی برنامم اجرا نمیشه در حالیکه تمام فیلدهاش مقدار دارن و فقط وقتی دستور رو کوچک میکنم اجرا میشه!
Dim rst As New ADODB.Recordset
Dim cnn As New ADODB.Connection
sqlee = "insert into eventtick(codem,codeoto,coderan,time,valid,lon,ns, lat,ew,speed,cource,date,header,overspeed,shetab,e nheraf,khab,tormoz,dooree) values ('" + codem + "','" + codeoto + "','" + coderan + "','" + gtime + "','" + valid + "','" + lon + "','" + ns + "','" + lat + "','" + ew + "','" + speednum + "','" + course + "','" + gdate + "','$EE','" + Val(overspeed) + "','" + Val(shetab) + "','" + Val(enheraf) + "','" + Val(khab) + "','" + Val(tormoz) + "','" + newdoor + "');"
Set rst = cnnee.Execute(sql)
Dim rst As New ADODB.Recordset
Dim cnn As New ADODB.Connection
sqlee = "insert into eventtick(codem,codeoto,coderan,time,valid,lon,ns, lat,ew,speed,cource,date,header,overspeed,shetab,e nheraf,khab,tormoz,dooree) values ('" + codem + "','" + codeoto + "','" + coderan + "','" + gtime + "','" + valid + "','" + lon + "','" + ns + "','" + lat + "','" + ew + "','" + speednum + "','" + course + "','" + gdate + "','$EE','" + Val(overspeed) + "','" + Val(shetab) + "','" + Val(enheraf) + "','" + Val(khab) + "','" + Val(tormoz) + "','" + newdoor + "');"
Set rst = cnnee.Execute(sql)