sql Update語¾ä錯誤
sql Update語¾ä錯誤
´ú碼ÈçÏ£º
Dim rs As ADODB.Recordset
Dim sql2 As String
If Trim(BarCode.Text = "") Then '掃Ãè條碼¿ò為' ',Ìáʾ
MsgBox "ûÓÐ掃Ãè條碼£¬ÇëÖØÐÂ掃Ã裡", vbOKOnly + vbExclamation, "¾¯¸æ"
BarCode.SetFocus
ElseIf Trim(Len(BarCode.Text) <> 16) Then '掃Ãè條碼長¶È²»ÊÇ16個×Ö·û,Ìáʾ"掃Ãè條碼長¶È錯誤£¬請ÖØÐÂ掃Ãè條碼£¡"
MsgBox "掃Ãè條碼長¶È錯誤£¬請ÖØÐÂ掃Ãè條碼£¡", vbOKOnly + vbExclamation, "¾¯¸æ"
BarCode.SetFocus
BarCode.Text = "" '"Barcode"Çå¿Õ
Exit Sub
Else
&nbs
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......