ms access - Delphi 5 - SQL Functions + Microsoft.ACE.OLEDB.12.0 tmemofield -


i'm using tadoquery connected access database microsoft.ace.oledb.12.0 provider.

with request : "select trim(field_name) c table_name", c tmemofield.

if change provider microsoft.jet.oledb.4.0, field "c" tstringfield.

i've noticed when i'm using microsoft.ace, of sql functions return tmemofield !

considering amount of code, can't review of requests. there solution, using microsoft.ace provider, should able retrieve tstringfield when i'm using function in request ? parameter in connection string example ?

thanks


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -