PureBasic Forums - English

Does anybody know the escape character for the MS Access ODBC driver?

Also, does it support transactions? If so what are the statements for BeginTransaction, Commit and RollBack?

Thanks

Weave

Hi the.weavster,

Regarding transactions, I think it can be done, here's a link to a site with some VB code using access/transaction server.

http://www.softlookup.com/tutorial/data ... #Heading20

Also aXend did some useful preliminary work that may help you with this vis purebasic (he uses com to access msAccess). This thread:

viewtopic.php?t=14214&highlight=


Not sure what you mean by an ODBC escape sequence.

Thanks Tension.

The escape character is necessary if the text you are storing to a database contains a quotation character.

In MySQL it is \, so if you wanted to store 'don't respond' to a database you would have to format it as 'don\'t respond' in the SQL statement you sent to the server.

I have actually found what it is with the access driver, it is another quote.
e.g. 'don''t respond'

Weave

the.weavster wrote:it is another quote. e.g. 'don''t respond'Weave

"To quote a guy a I asked on this: ""yep"""