SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Jun 2000
    Location
    san francisco, ca
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Need Help bad - DB_FetchNext w/ uniqueidentifier

    Hi guys,

    I am trying to run DB_FetchNext on a table and it is failing because of the following error...

    *** Error: SQL_TYPE (-11) in column (rowguid) not supported

    I am guessing it is due to the column being a type uniqueidentifier.

    Any idea I can work around this? I am pulling my hair out here again.

    Thanks, Tony



    ------------------

  2. #2
    Member
    Join Date
    Nov 2000
    Location
    Shelton, CT, USA
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Need Help bad - DB_FetchNext w/ uniqueidentifier

    I think you're right about SilkTest with dealing with guids. I experienced the same problem. I couldn't use the Select * FROM table. I ended up having to list out all of the columns in the Select statement, excluding the offending column. Then it worked fine. Luckily I didn't need this column so I could ignore it. If you need this column - I read in a prevous posting about an idea that may work for you, try casting the guid to a string and bring the guid out as a string. Read the link: http://www.qaforums.com/Forum1/HTML/001739.html. If it works, thank vincebowdren for the idea.

    ------------------


    [This message has been edited by mvpl (edited 04-13-2001).]

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.40 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.7.1 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.3.0 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 11:18 AM.

Copyright BetaSoft Inc.