# vb6&SQL6.5:No Current row, WHY?

Posted by Ariel CY on January 24, 1998 at 19:12:42:

I use vb6 and SQL6.5, and I use RDO. Program is:
msrdc1.sql="select * from mytable"
msrdc1.datasourcename="my odbc"
msrdc1.uid="sa"
msrdc1.PWD="sa"
text1.datasource=msrdc1
text1.datafield="field1"
When I load program,and execute:
msrdc1.resultset.addnew
It's normal,but when I change the content of Text1 and execute:
msrdc1.resultset.update
It's failure,there's a prompt(NOT error!, No any error code):
No current row.
But if I execute:
msrdc1.resultset.addnew
msrdc1.resultset("field1")="aaa"
msrdc1.resultset.update
It's success.
Why?How to do?
BTW:Because I can't write in BIG5,so I have to write in English.

Follow Ups:

- 观念不对喔! 小吴 23:31:05 2/01/98 (1)
  - Re: 观念不对喔! Ariel CY 23:12:42 2/03/98 (0)