SPONSORS:






User Tag List

Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Aug 2000
    Location
    sanjose
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query from data base

    I store values in a particular column of MS access data base of the type text item like "abcd...", when i query the data in silk its returning the value as "abcd|" string with a pipe instead of "abcd...".

    But i need to get it same like with string and dots how to get this one done??

    Thanks/Ram

    ------------------
    ram
    ram

  2. #2
    Member
    Join Date
    Jan 2001
    Location
    Westborough, mA, USa
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Query from data base

    Even i got it the same way. What i did was i used the IsAlpha(), IsDigit() methods to rewrite the string i got from the database. In your case if all the .. characters are replaced by a | character u can search for a char which is not a alpha(if u dont have a number in ur string) and replace that by ..
    Hope this helps.
    Let me know

  3. #3
    Member
    Join Date
    Aug 2000
    Location
    sanjose
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Query from data base


    MSAccess setting must be changed to get be able to use
    "...". The procedure is:

    1. Open MSAccess
    2. Select Menu Tools->AutoCorrect...
    3. Find "..." in the list.
    4. Select "..." from the list.
    5. Notice that both fields "Replace:" and "With:" are
    populated w/ "...".
    6. In the "With:" field delete the "..." and type "..." period by period. Do not copy and paste.
    7 Select the 'OK' button and the issue is resolved.

    ram

 

 

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 05:55 PM.

Copyright BetaSoft Inc.