Getting value from a blank field of a database
Posted on 2002-06-09
my task is to get a value from several table let say table A, table B, table C and table D to a single table name table E.the problem that im facing now is that from these seperate table i need specific field from each of them and insert it into table E.i cant insert a blank/null value (field) from table A,B,C,D to a field in table E.the field that need in table E,must be fill up and cant be left blank/null or else error will occur.
Set rs1 = adoconn.Execute("SELECT PrinOut FROM Provision WHERE MasterAcNo in (SELECT MasterAcNo FROM account_Holder WHERE CustNo = '" & Trim(rs!CustNo) & "')")
rs1!PrinOut = Null
error prompt out:
the table cannot be zero-length.
due to this program is a data checking program, i cant make modification on the table on the field cos' all the fields in the table E is compulsory.
wat is the method or way that can help me solve this problem?