Update empty field

Results 1 to 3 of 3

Thread: Update empty field

  1. #1
    Join Date
    Dec 1969

    Default Update empty field

    I have a list of updates to send to a sql table, one field of which is empty. Of course, it doesn&#039;t particularly work too well. How do I circumvent this error message? Do I need to do some conditional statement? How do I handle empty values when updating a field?<BR>By the way, I&#039;ll be encountering this same problem when I&#039;ll start my Insert New page, so any feedback on that would be welcome, too.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default This might shock you BUT....

    ...we are NOT mind readers.<BR><BR>PLEASE post the error message and the code you thing is causing the error<BR><BR>

  3. #3
    J. Paul Schmidt Guest

    Default Just Shooting From the Hip...

    Just shooting from the hip, but maybe this will help for helping to get a possibly empty text variable into a database:<BR><BR>If Len(MyTextVariable) = 0 Then MyTextVariable = Null<BR><BR>Best regards,<BR>-Paul<BR><BR>J. Paul Schmidt, MBA<BR>Databases on the Web<BR>http://www.Bullschmidt.com<BR><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