»¹ÊÇVBºÍSQLµÄÎÊÌâ
ÎÒÓÃVB¶ÁÈ¡WinCCµÄ¹ý³Ì±äÁ¿A£¨¶þ½øÖÆ£©µ½text16 ÖÐ £¬Ö»Òªtext6ÖÐΪ1£¬¾ÍÏòSQLÊý¾Ý¿â×öÒ»Ìõ¼Ç¼¡£
ÏÂÃæµÄ´úÂëÊǵ±Ìõ¼þÂú×ãʱ£¬Óð´Å¥command1Ìí¼Ó¼Ç¼µÄ£¨Õâ¸öÒѾʵÏÖ£©¡£
Private Sub command1_click()
If Text16.Text = "1" Then
Adodc1.Recordset.MoveLast
Adodc1.Recordset.AddNew
Text1.Text = Text19.Text ¡®SQL×Ö¶Î1
Text2.Text = Text5.Text ¡®SQL×Ö¶Î2
Text3.Text = Text17.Text ¡®SQL×Ö¶Î3
Text20.Text = Date ¡®SQL×Ö¶Î4
Text4.Text = Time ¡®SQL×Ö¶Î5
Adodc1.Recordset.UpdateBatch
Else
End If
End Sub
ÎÒµÄÎÊÌâÊÇ£¬ÔõÑùд£¬¿ÉÒÔÈÃVB¸ù¾Ý±äÁ¿AΪ1ʱ×Ô¶¯×öÒ»Ìõ¼Ç¼¡£ÉÏÃæµÄÌõ¼þÓï¾ä·Åµ½Ê²Ã´ÑùµÄ¹ý³Ì»ò·½·¨ÖÐÈ¥£¿
Ìí¼Ótimer¿Ø¼þ£¬È»ºóÈçÏ£º
VB code:
Private Sub Form_Load()
Timer1.Enabled = 1000
End Sub
Private Sub Timer1_Timer()
Timer1.Enabled = False
If Text16.Text = "1" Then
Adodc1.Recordset.MoveLast
Adodc1.Recordset.AddNew
Text1.Text = Text19.Text 'SQL×Ö¶Î1
Text2.Text = Text5.Text 'SQL×Ö¶Î2
Text3.Text = Text17.Text 'SQL×Ö¶Î3
Text20.Text = Date 'SQL×Ö¶Î4
Text4.Text = Time 'SQL×Ö¶Î5
Adodc1.Recordset.UpdateBatch
Else
End If
Timer1.Enabled = True
E
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
±ÈÈç½ø³Ì¼ÓÔØÐµijÌÐò¡£
ÔÚÆäÔËÐÐ֮ǰ×èÖ¹¡£
È»ºóÔÊÐíºó·ÅÐС£
±ÈÈç³ÌÐòÖ÷Îļþ·¾¶ÊÇc:\test\test.exe£¬½¨Á¢ÄÚÈÝÈÎÒâµÄÎļþc:\test\test.exe.manifest¡£
¾ÍÊDz»ÖªµÀ³ÌÐòÎļþ·¾¶¡£
ÉèÖ ......
ÏëÔÚwarcraft3Àï½øÐÐдÆÁ²Ù×÷¡¾Èç¶Ôսƽ̨ÖеÄʤ¸ºÌáʾÐÅÏ¢¡¿£¬Ð§¹û¾ÍÏñÓÎϷƽ̨ÖÐÒ»Ñù£¬ÎÒÊÔ¹ýÔÚÒ»´°¿ÚÖÐдÈëÎÄ×Ö£¬È»ºóÒ»Ö±Èô°¿ÚÇ¿ÖÆ×îǰ£¬ËäÈ»ÄÜʵÏÖÎÄ×ÖÏÔʾ£¬µ«ÊÇÎÄ×ֻ᲻¶ÏÉÁ˸£¬¶øÇÒÓв»È·¶¨BUG£¬Í¨¹ýÂÛ̳ËÑ ......