SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
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)
    Total Downloaded
    0

    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)
    Total Downloaded
    0

    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)
    Total Downloaded
    0

    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
  •  
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 06:07 PM.

Copyright BetaSoft Inc.