Hi,

 I have just started to have a look at the C# functionality of PB 2019. Does it support MySQL? I cannot generate models for any of my tables. I have created a very simple datawindow on a table without indexes or foreign keys or anything complicated. I right click on it and choose Generate C# Models. The generator opens and I choose my connection (MySQL 5.7). I now get a parsing error:

 ERROR [42000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.22-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 primary_creator from sys.sysforeignkeys where foreign_creator = t0.creator and' at line 11

 This is the datawindow.

  SELECT finance.reference_no,  
         finance.cycle,  
         finance.code,  
         finance.seq,  
         finance.date_paid,  
         finance.via,  
         finance.account,  
         finance.currency,  
         finance.invoice,  
         finance.date_due,  
         finance.paid,  
         finance.date_invoice,  
         finance.currency_paid 
    FROM finance  

This is the select taken from the datawindow syntax in the generator.

retrieve="  SELECT finance.reference_no,            finance.cycle,            finance.code,            finance.seq,            finance.date_paid,            finance.via,            finance.account,            finance.currency,            finance.invoice,            finance.date_due,            finance.paid,            finance.date_invoice,            finance.currency_paid      FROM finance   " update="finance" updatewhere=1 updatekeyinplace=no )

I get the same error for all my tables.  I must admit I have only ever worked with classic c/s so this is a bit new, although I also work with C# in Visual Studio. I just want to see what model is generated.