Recordsets resetting to NULL in Visual Basic 6.0
Hello, I am experiencing problems with recordsets in VB, where they are losing there values, i ran through the program in break mode, if i hover my mouse over, for instance GRS!name or whatever, it pop up the correct value, but then if i move the mouse away and then return it, to refresh the pop up, having no lines of code executed in the mean-time, it pops up null, i have no idea why this is happening, the database i'm connecting to is Access, this problem has only started recently, snippets of code that worked previously are now failing due to this strange occurance, does anyone have any idea what is going on? Any help would be appreciated, thankyou.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 12, 2005 1:28 PM
UPDATED:
May 17, 2005 1:03 PM
Answer Wiki:
Put a message box and check the value
To see all answers submitted to the Answer Wiki: View Answer History.
It’s been about 14 months since I ran across that one the last time. But if memory serves, I believe it stems from a variable typecasting artifact in ADO – specifically dealing with “pointer-type” fields (e.g. text, ntext or image).
I’d start with a double-check of your variable types in the embedded call vs. the field declarations within the tables… and check for any existing stored procedures/macros that might explicitly typecast as well.
That was a few clients ago, but I’ll fish my archives to see if I can extract a sample and/or verify my memory skills.