1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Using ODBC connections to OG Files

Discussion in 'Optigold ISP' started by OlyPenDoc, Oct 2, 2010.

0
  1. #1
    Using ODBC to query data directly from OG files, has anyone found a way to get around the problem of Field names with spaces? I have tried every practical convention I can think of: put field names in square brackets "[", put field names in double quotes, use %20 for the space, etc. nothing seems to work, so SELECT statements fail unless I do a select *.

    The problem seems to originate in the Filemaker driver that parses the select statement?
     
    OlyPenDoc, Oct 2, 2010 IP
  2. wgcom

    wgcom Peon

    Messages:
    157
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    try single quotes
     
    wgcom, Oct 2, 2010 IP
  3. OlyPenDoc

    OlyPenDoc Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Tried that too...
     
    OlyPenDoc, Oct 2, 2010 IP
  4. wgcom

    wgcom Peon

    Messages:
    157
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    sorry, cant think about other solution ATM
     
    wgcom, Oct 3, 2010 IP
  5. OlyPenDoc

    OlyPenDoc Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Thanks for the input anyway. From what I have been able to determine by reading the tech-know on FM ODBC driver, spaces in field names are not supported. The support spaces in file names (use %20), but no mention of spaces in field names. Seems rather odd that Filemaker would write a driver that doesn't support spaces in field names even though their software allows spaces in field names. How lame is that.
     
    OlyPenDoc, Oct 5, 2010 IP
  6. wgcom

    wgcom Peon

    Messages:
    157
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    yeh, sounds weird.
     
    wgcom, Oct 6, 2010 IP
  7. And43ersonD

    And43ersonD Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Seems rather odd that Filemaker would write a driver that doesn't support spaces in field names even though their software allows spaces in field names. How lame is that.
     
    And43ersonD, Oct 14, 2011 IP