On 10/05/2013 11:44 PM, Willy Raets wrote: > On Sat, 2013-10-05 at 10:33 -0400, nando wrote: >> This isn't really a Gambas issue. >> The table is poorly created without a primary key with auto-increment. >> If you wanted to delete one row with values 347 200, then which row would it >> be? >> Without the primary key, you're asking MySQL to guess, and it wont. >> Whatever your 'row pointer' is in Gambas, MySQL knows nothing of it. > > So, in other words, if in Gambas I open a table for edit, issue > a .MoveNext in a loop, until I find the needed record, next do a .Delete > and .Update, MySql has no idea what record to delete? > > > IIRC, ms access had the concept of a record number (for JET dbs) which it would/could use independently of a pkey. Maybe your application was relying on it. MySQL does not have this concept, therefore it needs a criteria that uniquely identifies a record if you want to delete a single record.
Fernando ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
