Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  If EditMode = MODE_ADD Then
  2. Add:
  3.       sSQL = "INSERT INTO Nut_StoriaClinica (Vis_ID, Ana_ID, VISITDATE) VALUES (" & _
  4.                   lVisID & ", " & _
  5.                   Trim$(VIS.AnagCode) & ", " & _
  6.                   Str$(VIS.DaTim) & ")"
  7.       ExecSQL ADOCnn(iDBData9).Connection, sSQL
  8.       Set rs = ADOCnn(iDBData9).Connection.Execute("SELECT @@identity")
  9.       lID = rs(0)
  10.      
  11.       sSQL = "INSERT INTO Nut_StoriaClinica_Stringhe (StoriaClinica_ID) VALUES (" & _
  12.                   lID & ")"
  13.       ExecSQL ADOCnn(iDBData9).Connection, sSQL
  14.    Else
  15.       sSQL = "SELECT TOP 1 ID From Nut_StoriaClinica WHERE Vis_ID=" & lVisID
  16.       OpenRecordset rs, sSQL, ADOCnn(iDBData9).Connection
  17.       If RSHasRecords(rs) Then
  18.          lID = rs(0)
  19.       Else
  20.          GoTo Add
  21.       End If
  22.    End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement