SPONSORS:






User Tag List

Results 1 to 3 of 3
  1. #1
    Senior Member
    Join Date
    May 2001
    Location
    Lahore, Punjab, Pakistan
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DB_Tables() Whats Wrong this 2 lines code?

    []hstmnt = DB_Tables (hdbc, "s1","s2", "t%","table")
    [-]while (DB_FetchNext (hstmnt,s3,s3,s4,s3,s5)==TRUE)
    [ ]print ("TC1:{s3} TC2:{s4} TC3:{s5}")
    -----------------------------------------
    Note hdbc is handle to DB_Connect and its working fine with other DB functions.hstmnt is of type HSQL.In short this piece is working with the other DB functions.
    there are more than 20 tables begining with letter t, so no problem with t%.
    s1,s2,s3,s4,s5 are declared as string
    ___________________________________________
    What could be wrong with the above code?
    The script run successfully but returns no result.

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

  2. #2
    Senior Member
    Join Date
    Aug 1999
    Location
    Cambridge, UK
    Posts
    470
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_Tables() Whats Wrong this 2 lines code?

    I haven't any experience with using DB_Tables, but the way you are submitting parameter s3 multiple times to DB_FetchNext sounds dubious. Parameters passed to this function are passed by reference, and so each should be expected to be modified independently; I expect the results of passing one variable in in several places, are undefined.

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

  3. #3
    Senior Member
    Join Date
    May 2001
    Location
    Lahore, Punjab, Pakistan
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: DB_Tables() Whats Wrong this 2 lines code?

    Thanks vince!
    I tried with different parameters but could not succeed.


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

 

 

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:38 PM.

Copyright BetaSoft Inc.