Veroland
asked on
RDO thingy, problem, hasell .......
I've asked this question before, but with no avail. I would really like to know why I seem to be the only person getting this problem. My system is in production now with 250 users connected so I dont like having uncertainties in the program. So I would appreciate it if anybody can tell me whats going on.
Okay – I use a SQL server 6.5 db. I access the database through RDO.
Everything works fine (Almost)
I get a couple of records that when I access them (Look at their values) it works fine. When I try do it the second time I find the record has turned to NULL. Ie.
If I do this:
Debug.print RS!Record
Debug.print RS!Record
I will get this "Hello World" the first time and a null value the second.
Even if the statements are exactly after each other. I also use the default cursor.
Has anybody an Idea why I get this.
It was fairly easy work around the problem but I still would like to know why it happens and why only on two fields (Both is text (16)) .
Thnx in advance.
Acually I found it on some more tables now .....
I amolost think it has something to do with SQL .....
Okay – I use a SQL server 6.5 db. I access the database through RDO.
Everything works fine (Almost)
I get a couple of records that when I access them (Look at their values) it works fine. When I try do it the second time I find the record has turned to NULL. Ie.
If I do this:
Debug.print RS!Record
Debug.print RS!Record
I will get this "Hello World" the first time and a null value the second.
Even if the statements are exactly after each other. I also use the default cursor.
Has anybody an Idea why I get this.
It was fairly easy work around the problem but I still would like to know why it happens and why only on two fields (Both is text (16)) .
Thnx in advance.
Acually I found it on some more tables now .....
I amolost think it has something to do with SQL .....
ASKER
Its only null the second time I access the record.
If i say isnull(rs!Record) 2 times I will get False then True
If i say isnull(rs!Record) 2 times I will get False then True
Post your code, Veroland.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What I really would like to know is why this happes.
But Hey, thanks - This question was posted on a lot of places for quite some time.
But Hey, thanks - This question was posted on a lot of places for quite some time.
I don't know for sure, but my best guess would be pointer related. If you look at the GetChunk method, it has an offset property. I think when you do a rs!pr_info, it retrieves from 0 to ?. The next time it retrieves from ? to ?. You'll also notice, that if you move off the record, then back to it, you'll be able to retrieve the field again.
IF ISNUL (Data.Recordset.Field("Fel