frmxhd.frm

此源码是针对配套的光学标记阅读机使用

VERSION 5.00
Begin VB.Form Form2 
   Caption         =   "Form2"
   ClientHeight    =   3495
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   6735
   LinkTopic       =   "Form2"
   ScaleHeight     =   3495
   ScaleWidth      =   6735
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "Command1"
      Height          =   735
      Left            =   4560
      TabIndex        =   0
      Top             =   1320
      Width           =   1215
   End
End
Attribute VB_Name = "Form2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub Command1_Click()
         Dim sql As String
         Dim rs As ADODB.Recordset
        sql = "select ttxx.lx,ttxx.kh,ttxx.ttxx,bdkey.jieguo from ttxx,bdkey where ttxx.lx=bdkey.lx "
        Set rs = TransactSQL(sql)
       Dim m As Integer
       m = rs.RecordCount
        Dim i As Integer
        For i = 1 To m
        Dim a, b, c As String
        a = rs(0)
        b = rs(1)
        c = rs(2)
        Print a
        Print b
        Print c
      Next i
        
End Sub