Hello,
My issue is very easy to solve. I want to use the generic ODBC in memo for a specific base (monetdb here but it isn't important).
I try to ouput a flow in a MonetDB SQL database. As you can see, I only take very simple field types
However I get this error message :
Error: Output Data (3): Error creating table "exemplecomparetable.toto": [MonetDB][ODBC Driver 11.44.0][MONETDB_SAU]Type (datetime) unknown in: "create table "exemplecomparetable"."toto" ("ID" int,"Libellé" char(50),"Date d"
syntax error in: ""Prix""
CREATE TABLE "exemplecomparetable"."toto" ("ID" int,"Libellé" char(50),"Date de Maj" datetime,"Prix" float,"PMP" float)
Reminder : SQL is an ISO Norm. Default type should follow it, not the MS SQL configuration. Interoperability is key
Links to : for in-db
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-In-database-connection-please-stop-inventing-and/idi-p/359763
Issues constated : MonetDB
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-Data-date-is-now-datetime-making-my-output-crashing/m-p/977689/highlight/false#M241775
Informix: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-date-data-type-error-trying-to-create-Informix-ODBC/m-p/451730#M87338
Best regards,
Simon
