Hi All Im struggling to understand why many of my mySQL statements work 100% on windows and suddenly havoc occurs when i port to suse.
A number of things that i have found with serious breakages and some workarounds, specifically with the MySqlCommandBuilder: 1) For some strange reason i have to call a .ToString() once instantiated or it wont recognised a SelectCommand exists and hence InsertCommands fail. 2) GetUpdateCommand() crashes sometimes and sometimes not with a cast exception - cannot cast from one type to another - i dont have more information on this and i cannot fix it. 3) When updating 2 tables with a PK FK relationship in a sql transaction, using 2 command builders and manually assigning the PK from one record to another, after running commit() it crashes as the primary key is updated in the first table but not transfered to the child table FK...- this does however work 100% on windows. Is anyone else having these kinds of problems? Piotr _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
