SPONSORS:






User Tag List

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)

    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)

    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
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 10:53 PM.

Copyright BetaSoft Inc.