Search results for query: *

  1. R

    Question DBF files with apostrophes in data

    No, my code is in fact highly volatile. It explodes. Blue smoke and all. As for error messages, it's been a while since I cared about this (since the problem is now fixed as I've already mentioned), but I'm almost entirely certain the complete error message was "Near "'S": syntax error", which...
  2. R

    Question DBF files with apostrophes in data

    The apostrophes are already in the database data, put there by their existing software. When I was retrieving the data with ODBC, the Table.Load line would explode because the apostrophe made it think there was another column, when it was just one column with an apostrophe in it. Using OleDB...
  3. R

    Question DBF files with apostrophes in data

    What you see above is everything I've done regarding the DBF file minus some cookie cutter stuff (Command = Connection.CreateEtc) and the connection string, which I don't have in front of me right now but I basically just copied from ConnectionStrings.com: Driver={Microsoft dBASE Driver...
  4. R

    Question DBF files with apostrophes in data

    Strike everything I previously wrote here. I got OleDb to work finally. This can be considered solved.
  5. R

    Question DBF files with apostrophes in data

    Thanks anyway. Anyone else have suggestions? At this point I'm willing to try virtually anything to get it to work so I can put this behind me. Interestingly, I can actually work with all the data up to the first stray apostrophe; all the rows prior do load into the datatable.
  6. R

    Question DBF files with apostrophes in data

    The only thing potentially useful in that entire page are the samples with "ParameterDirection.ReturnValue", but it's not exactly specific on how that works so I'll have to play around with it. Or maybe I wasn't specific enough; I'm not the one entering any data into the database, I'm trying to...
  7. R

    Question DBF files with apostrophes in data

    Good day. I'm working on a project involving reading data from DBF files. Everything was going on just fine until I discovered the client has apostrophes in some of the columns. Due to some 15,000 records already existing, I've been asked to try to work around it rather than make them fix up...
Back
Top