ååï¼è¿ä¸ªå¾ç®åç
å¼ç¨ Microsoft ActiveX Data Objects 2.8 Library
æè
å å
¥microsoft ado data control
å®ä¹æ°æ®åºè¿æ¥
Dim Cnn As New ADODB.Connection
å®ä¹æä½è®°å½
Dim Res As New ADODB.Recordset
å¼å§ä½¿ç¨
If Res.State = 1 Then Res.Close
Res.CursorLocation = adUseClient
Res.Open "SELECT * From å票表", Cnn, adOpenDynamic, adLockReadOnly
å é¤ç¨res.Delete
æ·»å ç¨res.AddNew
res.Fields("åºå·") = Trim(Res.Fields("åºå·"))
...
res.Update
æ´æ°ç¨Res.Update "åºå·", 111
åï¼
'åå
¥äº§åä¿¡æ¯
Sub WriteFP()
'On Error Resume Next
Dim SyBaseRes As New ADODB.Recordset
PB.value = 0
Res.Open "SELECT Count(*) From ICSaleEntry INNER JOIN t_Item ON ICSaleEntry.FItemID = t_Item.FItemID INNER JOIN t_MeasureUnit ON ICSaleEntry.FUnitID = t_MeasureUnit.FMeasureUnitID", SQLServer, adOpenDynamic, adLockReadOnly
Text2.Text = "å½åå
± " & Val(Res.Fields(0)) & "æ¡æ°æ®"
PB.Max = Val(Res.Fields(0))
If Res.State = 1 Then Res.Close
Res.Open "SELECT ICSaleEntry.FDetailID AS åºå·,ICSaleEntry.FInterID AS ç©æç¼å·, t_Item.FName AS 产åå称,ICSaleEntry.FAuxPrice AS åä»·, ICSaleEntry.FAuxQty AS æ°é,ICSaleEntry.FAmount AS åå¸, ICSaleEntry.FStdAmount AS æ¬å¸,t_MeasureUnit.FName AS åä½ FROM ICSaleEntry INNER JOIN t_Item ON ICSaleEntry.FItemID = t_Item.FItemID INNER JOIN t_MeasureUnit ON ICSaleEntry.FUnitID = t_MeasureUnit.FMeasureUnitID", SQLServer, adOpenDynamic, adLockReadOnly
Do While Not Res.EOF
If SyBaseRes.State = 1 Then SyBaseRes.Close
SyBaseRes.Open "select * from ç©æ表 where åºå·='" & Res.Fields("åºå·") & "'", Cnn, adOpenDynamic, adLockOptimistic
If SyBaseRes.EOF Then
Text2.Text = Text2.Text + vbCrLf + "æ£å¨æ·»å : " & Trim(Res.Fields("åºå·"))
SyBaseRes.AddNew
SyBaseRes.Fields("åºå·") = Trim(Res.Fields("åºå·"))
SyBaseRes.Fields("产åç¼å·") = Trim(Res.Fields("ç©æç¼å·"))
SyBaseRes.Fields("产åå称") = Trim(Res.Fields("产åå称"))
SyBaseRes.Fields("åä»·") = Trim(Res.Fields("åä»·"))
SyBaseRes.Fields("æ°é") = Trim(Res.Fields("æ°é"))
SyBaseRes.Fields("åå¸") = Trim(Res.Fields("åå¸"))
SyBaseRes.Fields("æ¬å¸") = Trim(Res.Fields("æ¬å¸"))
SyBaseRes.Fields("åä½") = Trim(Res.Fields("åä½"))
SyBaseRes.Fields("æ°æ®åºå") = Trim(Text1.Text)
SyBaseRes.Update
Else
Text2.Text = Text2.Text + vbCrLf + "æ£å¨æ´æ°: " & Trim(Res.Fields("åºå·"))
SyBaseRes.Update "åºå·", Trim(Res.Fields("åºå·"))
SyBaseRes.Update "产åç¼å·", Trim(Res.Fields("ç©æç¼å·"))
SyBaseRes.Update "产åå称", Trim(Res.Fields("产åå称"))
SyBaseRes.Update "åä»·", Trim(Res.Fields("åä»·"))
SyBaseRes.Update "æ°é", Trim(Res.Fields("æ°é"))
SyBaseRes.Update "åå¸", Trim(Res.Fields("åå¸"))
SyBaseRes.Update "æ¬å¸", Trim(Res.Fields("æ¬å¸"))
SyBaseRes.Update "åä½", Trim(Res.Fields("åä½"))
SyBaseRes.Update "æ°æ®åºå", Trim(Text1.Text)
End If
PB.value = PB.value + 1
Res.MoveNext
DoEvents
Loop
If SyBaseRes.State = 1 Then SyBaseRes.Close
Set SyBaseRes = Nothing
End Sub
ç½ç»å¸æä¸è¦ç¨ACCESSç¨ASAï¼å°±æ¯sybaseé£ä¸ªå¤ªå¼ºäºï¼
温馨提示:答案为网友推荐,仅供参考