我想从数据库中取出testid下一个取值,语句如下:
select testid.nextval as tid from dual
但用rs("tid")取的时候VB报错
“Run-time error '458':
Variable uses an Automation type not supported in Visual Basic”
各位大虾,如何解决这个问题呢?
select testid.nextval as tid from dual
但用rs("tid")取的时候VB报错
“Run-time error '458':
Variable uses an Automation type not supported in Visual Basic”
各位大虾,如何解决这个问题呢?
SQL语句改为select case(testid.nextval as varchar(8)) as tid from dual