Insert Into-- Select

Posts   
 
    
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 07-Nov-2013 18:24:58   

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')

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 08-Nov-2013 07:10:00   

Batch insert is not supported, this is why: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18851&StartAtMessage=0&#105881

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&#118228

David Elizondo | LLBLGen Support Team
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 08-Nov-2013 08:05:13   

daelmo wrote:

Batch insert is not supported, this is why: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18851&StartAtMessage=0&#105881

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&#118228

Ok. Thank You