pcsoft.us.windevCopyright 2026, PC SOFT4 Sep 2015 18:46:03 Z4 Jun 2015 22:31:00 ZI'm attempting to execute multiple insert statements via one SQL statement like so: INSERT INTO ExampleTable(DATE,Activity,ItemID,EmployeeID) VALUES ('20150604',"Example statement.",5820,1), ('20150604',"Example statement.",9264,1), ('20150604',"Example statement.",9265,1), ('20150604',"Example statement.",5838,1), ('20150604',"Example statement.",5858,1), ('20150604',"Example statement.",5818,1), ('20150604',"Example statement.",19798,1), ('20150604',"Example statement.",5827,1), ('20150604',"Example statement.",5819,1), ('20150604',"Example statement.",150,1), ('20150604'," Example statement.",9261,1)30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)t.tranpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-53887/read.awp4 Sep 2015 18:46:03 ZWe have three WinDev (Ver 20) in house developers, who tested the query and found out that it only works on HFSQL Classic file a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-53887/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-53887/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52605/read.awp8 Jun 2015 20:39:00 ZThank you everyone for your help! I was able to find a way to work around my problems using insertation via select statement:…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52605/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52605/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52604/read.awp8 Jun 2015 20:26:00 Zhi Pls see as below (works as a charm): sSql is string sConn is string = "Hi" trace (HOpenConnection(sConn, myUserName, …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52604/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52604/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52603/read.awp8 Jun 2015 20:00:00 ZHi James, the only difference I can think of is that YOU may have one of the field set as automatic ID in your record, and ar…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52603/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52603/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52602/read.awp8 Jun 2015 19:56:00 ZHi I used wdSql (32-bit) (v19-hfSQL20) to submit INSERT INTO myName (NAME, description) VALUES('hello4','desc4'), ('hell…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52602/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52602/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52601/read.awp8 Jun 2015 19:10:00 ZJames Sounds like it is the INSERT function it does not like. If you are running with HFSQL v20 Control Centre then try drop…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52601/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52601/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52599/read.awp8 Jun 2015 17:44:00 ZThank you for your reply Derek! Unfortunately that does not work for me even when I have copied word-for-word. Does anyone know …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52599/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52599/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52598/read.awp8 Jun 2015 16:17:00 ZJames The following test worked for me...... MyQuery is Data Source sqltest is string = [ INSERT INTO ItemHistory(DATE,Activit…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52598/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52598/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52596/read.awp8 Jun 2015 15:03:00 ZThanks for the reply Viggo! Unfortunately no, I still get the same error.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52596/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52596/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52573/read.awp6 Jun 2015 11:12:00 ZHi James Just a thought: Could you try without single quotes on itemID and EmployeeID ? INSERT INTO ItemHistory(DATE,Act…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52573/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52573/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52572/read.awp6 Jun 2015 00:01:00 ZThanks to all who've replied so far! Unfortunately the Insertion query still isn't working well with me. Here's the code I tr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52572/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52572/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52571/read.awp5 Jun 2015 18:32:00 ZJames Just tested this - it is working in WD20 US pre-release. It will not handle automatic identifiers - you will need to…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52571/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52571/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52570/read.awp5 Jun 2015 16:41:00 ZHi James, I don't know if this feature is included in the pre-release.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52570/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52570/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52569/read.awp5 Jun 2015 16:33:00 ZI see, thank you very much Stefan! This code isn't for our setup of Windev 20, is this feature not included in the pre-release?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52569/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52569/read.awpMultiple insert statements via one HFSQL statementguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52566/read.awp5 Jun 2015 12:02:00 ZHi James, afaik this works from WinDev Version 20, not in earlier versions.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52566/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52558-multiple-insert-statements-via-one-hfsql-statement-52566/read.awpMultiple insert statements via one HFSQL statement