Sibyille:
Thanks for the report and the excellent analysis. I was afraid no one
would ever use "named" paramstyle.
Dennis:
Any code suggestion would be very welcome. Would you be able to suggest a
patch?
--
Vernon Cole
On Sat, Feb 23, 2019 at 7:30 AM Sibylle Koczian
wrote:
> Am
Am 21.02.2019 um 16:26 schrieb Dennis Lee Bieber:
If I were coding something, I'd likely use the native style to reduce
the cost of conversion overhead. Relatively speaking, that name extraction
code is /slow/ -- it splits the query on :, then loops over each character
looking for
Am 20.02.2019 um 19:28 schrieb Dennis Lee Bieber:
On Wed, 20 Feb 2019 17:22:16 +0100, Sibylle Koczian
declaimed the following:
UPCMD = "UPDATE tblHaupt SET item = :item, ort = :ort_id WHERE id = :h_id"
As a total wild guess... try ending the SQL with a ; or space
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.
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