Re: [python-win32] adodbapi: paramstyle 'named' doesn't work as expected

2019-02-20 Thread Tim Roberts
Dennis Lee Bieber wrote: The loop is looking for the end of the parameter name by looking for a non-alphanumeric character. But your update command just... ends -- there is no non-alphanumeric character after the name to terminate the loop. INSERT syntax has a closing ) to terminate.

[python-win32] adodbapi: paramstyle 'named' doesn't work as expected

2019-02-20 Thread Sibylle Koczian
Hello, I'm trying to write a small application to work with a Microsoft Access database. This application will have to insert and update records, and I'd like to use paramstyle='named'. With INSERT commands this seems to work, with UPDATE I get an exception I can't explain. Example: The