SPONSORS:






User Tag List

Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Jul 2000
    Location
    sanjose,ca,usa
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Reading data from database table

    Hi
    I am retrieving data from ORACLE database,from a table which has field of type BLOB,i have this code
    HANDLE hDB
    HANDLE hSQL
    STRING CONTENT
    //CONTENT is of type BLOB(Huge Content) in database PRODUCT table
    HDB=DB_Connect(“dsn=challe;UID=sindu;pwd=yes345”)
    STRING sSQL=”Select CONTENT from PRODUCT where ID=’100’ “
    HSQL=DB_Execute(hDB,sSQL)
    While DB_FetchNext(hSQL,CONTENT)
    Print(CONTENT)
    DB_FinishSQL(hSQL)
    DB_Disconnect(hDB)
    I want to know is there any keyword BLOB in silk,can anyone give me the solution
    Thanks
    sri


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

  2. #2
    Senior Member
    Join Date
    Jul 2001
    Location
    Elizabeth, CO, USA
    Posts
    653
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reading data from database table

    What shows up in your print statement as is? Nothing?

    I know that there's a way, in your SQL statement, to have the data converted to a datatype you're happier with. CAST? I've done it to convert large integers to strings so that SilkTest can deal with them. Just can't recall how to do it right now.

    According to my SQL reference, it is possible to CAST from Binary (a BLOB is a Binary Large OBject) to a STRING.

    What are you planning on doing with this binary data if/when you get it back from the database? Are you sure you need it?

    Got an Oracle guru around there you can pester?

    - Dave


    ------------------
    Amelior Technology
    dreed@ameliortech.com

    [This message has been edited by dcreed (edited 12-04-2001).]
    WaltzingRhino.com
    A concerned Borland customer, a fly in the ointment, a wrench in the works.

  3. #3
    Member
    Join Date
    Jul 2000
    Location
    sanjose,ca,usa
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Reading data from database table

    Hi dcreed
    The flow is
    1)I should insert a huge content into the database(.txt file)
    2)Some processes takes place in the backend
    3)After processes i should call this content from the database and compare with original which have send
    Can you give me a plan how to proceed..any alternate method
    Thanks
    sri




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

 

 

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 12:44 PM.

Copyright BetaSoft Inc.