multiple que

[Zeshan]

hi

1) in the "rs.open" v ve 4 options for the parameter 'cursortype' .
wats the diff b/w the four.
for e.g when i use 'opendynamic' n try to get the rs.recordcount, i get the value= -1
when use 'openstatic' i get the correct recordcount
WHY??

2)how do i refresh my recordset after deleting or inserting a record through sql query.
i already used , rs.updata' n 'rs.updatebatch' n 'rs.save' but nothing works.

3)is there any method or somethin dat will tell me wether a control has been clicked or not. for e.g suppose i click a button1. after dat i click button2, now how can i get to know that the button1 was clicked.

thankyou

[Memnoch1207]

1. To get the recordcount, you'll need to set the CursorType = adUseClient.

Here's an overview of the recordset cursor types.

2. It would depend on the cursor type you are using...An adOpenDynamic cursor type would show any new or updated records, so you wouldn't need to do any type of refreshing.

3. In the click event of the button, assuming you are using VB 6. Double click the button and it will open up in code view, then you can program exactly what you want to happen when the button is clicked.