I see 10 items to SET. I count more than 10 vars in the list of variables ?? -Fernando
---------- Original Message ----------- From: "M. Cs." <mohar...@gmail.com> To: mailing list for gambas users <gambas-user@lists.sourceforge.net> Sent: Thu, 19 Jan 2012 21:57:53 +0100 Subject: [Gambas-user] Help! I can't find the error > querry = "SELECT * FROM MP3;" > tablak = DBconX.Exec(querry) > DBconX.Begin() > For Each tablak > a1 = Trans(tablak!file) > a2 = Trans(tablak!path) > a3 = Trans(tablak!Volume) > a4 = Trans(tablak!title) > a5 = Trans(tablak!artist) > a6 = Trans(tablak!album) > a7 = Trans(tablak!genre) > a8 = Trans(tablak!year) > a9 = tablak!lenght > a10 = Trans(tablak!lyric) > DBconX.Exec("UPDATE MP3 SET > file=&1,path=&2,Volume=&3,title=&4,artist=&5,album=&6,genre=&7,year=&8,lenght=&9, > lyric=&10 WHERE file=&11 AND path=&12 AND Volume=&13 AND title=&14 AND > artist=&15 AND album=&16 AND genre=&17 AND year=&18 AND lenght=&19 AND > lyric=&20", a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, tablak!file, > tablak!path, > tablak!Volume, tablak!title, tablak!artist, tablak!album, tablak!genre, > tablak!year, tablak!lenght, tablak!lyric) Next DBconX.Commit() > > Every variable is defined, the connection is opened the results are > retrieved, yet at UPDATE it tells me error. I can't see why. > > Thanks! > > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user ------- End of Original Message ------- ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user