以前提过但没解决的问题,急!
我建了一张表
CREATE TABLE T_XiaoLingTongClinetUsr(
UsrID CHAR (3) NOT NULL ,
UsrName VARCHAR(10) NOT NULL ,
Pwd VARCHAR(10) NOT NULL ,
PRIMARY KEY ( UsrID )
);
然后插入一条纪录:
insert into T_XIAOLINGTONGCLINETUSR values ('1',' ',' ');
usrname和pwd字段是长度为5空格,用"Select count(*) From T_XiaoLingTongClinetUsr where UsrName=' '"可以得出有一条记录,但是我用
Public OraSession As OraSession
Public OraDatabase As OraDatabase
Public OraRst As OraDynaset
Set OraSession = CreateObject("OracleInprocServer.XoraSession")
Set OraDatabase = OraSession.OpenDatabase(..., gOracleAccessStatusDefault)
set OraRst= OraDatabase.CreateDynaset("Select * From T_XiaoLingTongClinetUsr", gOracleAccessStatusDefault)
把记录取出来后OraRst("UsrName")却不是长度为5空格,而是一个长度为0的空字符串,为什么?而我怎么才能正确地取出来?
急!急!急!请各位帮帮忙!