#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    3
    Rep Power
    0

    UPDATETEXT and Table data type?


    Hi,

    Can anyone tell me whether UPDATETEXT works with the table data type? I've got this line of code :

    UPDATETEXT @TEMPTABLE.TEXTFIELD @PTRVAL @POS 1 'AHAHAHAHAH'

    but I get the error :

    Incorrect syntax near '@TEMPTABLE'

    It works with a 'real' temp table but I don't want the overheads, this need to be quick. Anyone done this or got any ideas of a way around it?

    Thanks.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Posts
    3
    Rep Power
    0
    I can answer this myself - table data type doesn't work in this context.

IMN logo majestic logo threadwatch logo seochat tools logo