Consulta
Publicado por ana (15 intervenciones) el 19/11/2008 23:14:12
Option Explicit
Dim cn As New rdoConnection
Dim rs As rdoResultset
Dim SQL As String
___________________________________________
Private Sub Form_Load()
cn.Connect = "SourceType=DBF;" _
& "SourceDB=D:X estDATA;" _
& "Driver={Microsoft Visual FoxPro Driver}"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection "rdDriverNoPrompt"
'where folio like '" & Text1.Text & "'"""
SQL = "select * from cel_data"
Set rs = cn.OpenResultset(SQL, rdOpenKeyset, rdConcurRowVer)
rs.MoveFirst
'Text1.Text = rs(0)
Text2.Text = rs(7)
Text3.Text = rs(8)
Text4.Text = rs(9)
end sub
Dim cn As New rdoConnection
Dim rs As rdoResultset
Dim SQL As String
___________________________________________
Private Sub Form_Load()
cn.Connect = "SourceType=DBF;" _
& "SourceDB=D:X estDATA;" _
& "Driver={Microsoft Visual FoxPro Driver}"
cn.CursorDriver = rdUseOdbc
cn.EstablishConnection "rdDriverNoPrompt"
'where folio like '" & Text1.Text & "'"""
SQL = "select * from cel_data"
Set rs = cn.OpenResultset(SQL, rdOpenKeyset, rdConcurRowVer)
rs.MoveFirst
'Text1.Text = rs(0)
Text2.Text = rs(7)
Text3.Text = rs(8)
Text4.Text = rs(9)
end sub
Valora esta pregunta


0