ADODC Recordcount 1

[SQLScholar]

Hey all,

Got abit of an issue that is really being a dog to solve.

On close of the form, the record is moved from a table it is temp into another table. Sometimes it seems that the record is not being populated into the second table.

On the save routine i have put a message box onto our BETA version that pops up giving the results of datagrid.approxcount and ADODC.recordset.recordcount. When it errors both come up with 0, yet i can see on the screenshot someone sent me that the Datagrid does have data in it. I have also poped in a ADODC refresh if the recordcount is 0, but that still makes no difference.

If it also makes any difference the form name is defined in a variable that gets set in the function (as the function is used by multiple forms).

Also to compound the fact, although the end users have the problem quite oftern, i cant replicate it via running in VB6. It seems that the main problem is happening on 2k machines not the XP ones.

Any ideas?

TIA

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
No D, just plank - and its not my fault

 

[Scoty]

Plank,
I am not super fimilar with ADODC's but you can set the cursor location. I have found in order to get an accurate ADO record count I would have to set the CursorLocation = asUseClient. Give that a try and see if it helps.

Thanks
Scoty :

Learn from others' mistakes. You could not live long enough to make them all yourself
-- Hyman George Rickover (1900-86)

 

[BobRodes]

For more information, see faq222-3670

Bob