Bom dia1!!
Caro José,
eu sei muito bem o que vc está passando!!!
vou mandar um codigo que criei que consegui utilizar o CursorAdapter, espero que te ajude,
Abraços,
Luis Ribeiro
Código fonte:
PUBLIC loClientes as CursorAdapter
PUBLIC curCliente as Cursor
PUBLIC loConnDataSource as String
PUBLIC oconn as "ADODB.Connection"
PUBLIC oRS as "ADODB.RecordSet"
loClientes = CREATEOBJECT("CursorAdapter")
loClientes.DataSourceType="ADO"
loClientes.Alias="curCliente"
loClientes.SelectCmd="select * from Customers"
loConnDataSource = [Provider=SQLOLEDB.1;Password=enterprise;Persist Security Info=True;User ID] + ;
[=sa;Initial Catalog=Northwind;Data Source=lua;]
oConn = createobject('ADODB.Connection')
oConn.Open(loConnDataSource)
oRS = CREATEOBJECT("ADODB.RecordSet")
oRs.CursorLocation= 3 && adUseClient
ors.ActiveConnection = oConn
loClientes.DataSource=oRS
loclientes.CursorFill()
SELECT curCliente
thisform.grid1.RecordSource="curcliente"
thisform.grid.refresh()
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only