LLBLGen 4.0 LLBLGen Runtime Framework MYSQL C# Windows App.
Hi, Is there a way I write the following in LLBLGEN?
INSERT INTO tab1(col1, col2) SELECT 'hello', 'goodbye' WHERE NOT EXISTS(SELECT * FROM tab1 WHERE col1= 'hello' AND col2 = 'goodbye')
Batch insert is not supported, this is why: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18851&StartAtMessage=0𙶙
The following thread is an alternative, in case you want to give it a try: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=20981&StartAtMessage=0𜷔
daelmo wrote: Batch insert is not supported, this is why: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18851&StartAtMessage=0𙶙 The following thread is an alternative, in case you want to give it a try: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=20981&StartAtMessage=0𜷔
daelmo wrote:
Ok. Thank You