Null Value does not work

Results 1 to 2 of 2

Thread: Null Value does not work

  1. #1
    Jason Guest

    Default Null Value does not work

    I am trying to use a null value to determine when a field in a database is blank. Here is the code:<BR><BR>&#060;%Count = 1<BR>Check = rstPCO("Part#"&Count)<BR>DO UNTIL ISNULL(Check) = True<BR>Count = Count + 1<BR>Check = rstPCO("Part#"&Count)<BR>LOOP%&#062;<BR><BR>When it hits a blank field it is supposed to put me out of the loop, but the ISNULL() always gives me a false. Is there a setting or something that has to happen with the database?? <BR><BR>Thanks<BR>

  2. #2
    Jason Miller Guest

    Default RE: Null Value does not work

    Guess 1: It doesn&#039t understand the #<BR>Guess 2: Setting check = another value means that it can&#039t be null (but it might be empty)<BR><BR>Wouldn&#039t it be more efficient (and I know it&#039s more accurate) to run<BR><BR>do until isNull(rstPCO("part"&count))<BR> count = count + 1<BR>loop<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts