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:
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 .....