[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

Getting value from a blank field of a database

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.

e.g.:
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?
0
wpkay
Asked:
wpkay
1 Solution
 
Ryan ChongCommented:
then to ensure all the fields in Table E filled in, you must make sure all fields that fill in to Table E (fields from either Table A, B, C or D) are compulsory too (Set their Allow Zero Length and Required Property to True)

In addition, you can also check to ensure all the data insert into Table E is not empty/null. > Do a Select Statement to check whether fields are empty/null.

Cheers
0
 
DanRollinsCommented:
Hi wpkay,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept ryancys's comment(s) as an answer.

wpkay, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now