Update Database

Results 1 to 2 of 2

Thread: Update Database

  1. #1
    Join Date
    Dec 1969

    Default Update Database

    Hi, I&#039;m using Macromedia UltraDev. I built a form, and used the built in update record feature. Now i can only update a field if every field has at least one character. Can anyone help me?<BR><BR>

  2. #2
    J. Paul Schmidt Guest

    Default Blank to Null

    Perhaps try something like the following for most fields (or possibly create a similar custom function):<BR><BR>&#039; Convert blank to Null.<BR>If Len(varFld) = 0 Then varFld = Null<BR><BR>Best regards,<BR>-Paul<BR><BR>J. Paul Schmidt, MBA<BR>Databases on the Web<BR>http://www.Bullschmidt.com<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