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? -- Kind regards, Willy (aka gbWilly) http://gambasshowcase.org/ http://howtogambas.org http://gambos.org ------------------------------------------------------------------------------ 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
