ADO and Datagrid

[deva1]

Hi All,

I am just attaching the code.I do not know the exact problem.It gives an error message while running.

The error is

Run_time error '7004'
The rowset is not bookmarkable.

I am attaching the code.

Dim Currinv_Rec As New ADODB.Recordset


Private Sub Form_Load()
Set Currinv_Rec = New ADODB.Recordset
Currinv_Rec.Open "select * from sys_current_invoice", "Provider=SQLOLEDB.1;Password=test;Persist Security Info=True;User ID=sa;Initial Catalog=testpubtest;Data Source=TEST\NKTEST", adOpenDynamic, adLockOptimistic, adcmdtxt


Set DataGrid1.DataSource = Currinv_Rec

end sub




The file "sys_current_invoice" does not have any records.Is that the problem?


Thanks alot for help.
Dev

 

[CCLINT]

Change adOpenDynamic to adOpenKeySet

And, you need to respond to the other threads which you have started.

See: faq222-2244