Alberto E. Godoy 20.Aug.14 04:54 PM a Web browser LC LSXAll ReleasesAll Platforms
I'm changing my connectors OO4O (Oracle) to LC LSX and I need to make a selection of records using bind variables.
This is part of the original code OO4O:
Dim concob As Integer
Dim fecha_aux As Variant
Dim con_array As Integer
Dim swHayCob As Variant
dim key as string
If Not AbreOO4O Then
Msgbox "He did not connect on database"
Exit Sub
End If
key = "A"
On Error Resume Next
OraDatabase.Parameters.Remove "var1"
OraDatabase.Parameters.Add "var1", key
Instruccion = |SELECT MyField1, MyField2 FROM MyTable WHERE (MyKey = :var1)|
Return to top
Print this page
