On Thu, 2012-01-19 at 21:57 +0100, M. Cs. wrote:
> 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!
Wild guess.
Would any of your columns be of an auto increment type? IF TRUE THEN
don't update/insert that column with your data. (skip the column)
------------------------------------------------------------------------------
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
