Results 1 to 3 of 3

Thread: MS Data control

  1. #1

    Thread Starter
    Hyperactive Member badgers's Avatar
    Join Date
    Sep 1999
    Location
    Madison, WI USA
    Posts
    444

    Post

    I am using the control that has a tool tip "Data"
    I am trying to get information from a table.
    the table name is "Job List" this name has a space in it.there are fields that have spaces in there names as well.
    It is giving me problems. is the space causeing problems? how do I get around this. I can NOT change the database table name or field names.
    thank you for your time and have a good day

    ------------------
    I am so skeptacle, I can hardly believe it!

  2. #2
    Member
    Join Date
    Feb 1999
    Location
    Lexington,kentucky,USA
    Posts
    61

    Post

    No doubt Space is causing problems.
    I think of only one thing without changing the database.Using Square brackets[ ]

    Use the table names in Square brackets
    eg:
    Select * from [job List]

    You should do the same with the field names too. It cannot recognize whether it is a keyword or tablename or variable name.

    If it doesn't work, then there is no possible way except to change the database.


    Good luck,
    krishna

  3. #3

    Thread Starter
    Hyperactive Member badgers's Avatar
    Join Date
    Sep 1999
    Location
    Madison, WI USA
    Posts
    444

    Post

    you da man!!!! :

    ------------------
    I am so skeptacle, I can hardly believe it!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width