Results 1 to 3 of 3

Thread: Odbc

  1. Nov 7th, 2001, 07:57 AM #1
    Cenobite
    Cenobite is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2000
    Location
    Bristol, UK
    Posts
    86

    Odbc

    When connecting to a database in code using the ODBC popup to specify a data source, I am encountering a problem when the source table has field names with spaces in them. For SQL Server, these fields need square brackets around them but for other data sources ( Oracle etc ) a different delimiter is needed. Is there anyway of knowing what the delimiter should be for any selected data source?


    Cheers
    Cenobite
    Reply With Quote Reply With Quote
  2. Nov 7th, 2001, 08:03 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    The only way to know what the delimiter is (that I know of anyway) would be to check the individual Db documentation.
    Reply With Quote Reply With Quote
  3. Nov 7th, 2001, 08:21 AM #3
    Cenobite
    Cenobite is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2000
    Location
    Bristol, UK
    Posts
    86
    What I mean is, that in the code when the user has selected a data source ( eg SQL Server, Oracle ), I need a generic way to find out in the code at run time what the delimiter would be.


    Cen
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width