Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98

    Post Unanswered: Default value for image column

    HI All,

    Does someone knows if it is possible to get a default value on a image column type!

    Cheers Wim

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by Wimmo
    HI All,

    Does someone knows if it is possible to get a default value on a image column type!

    Cheers Wim
    I don't think so it will allow. Best way is to try adding a
    default on the column.
    Last edited by harshal_in; 05-25-04 at 06:08.

  3. #3
    Join Date
    Nov 2003
    Posts
    94
    Quote Originally Posted by Wimmo
    HI All,

    Does someone knows if it is possible to get a default value on a image column type!

    Cheers Wim
    You must define the default value as a binary constant:

    create table #l
    (
    [thing] image not null default( 0x0000000001 )
    )

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by HanafiH
    You must define the default value as a binary constant:

    create table #l
    (
    [thing] image not null default( 0x0000000001 )
    )

    Oops

  5. #5
    Join Date
    Oct 2003
    Location
    Netherlands
    Posts
    98
    Thanx for your reply,

    How can i get my own image as a default?

Posting Permissions

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