[Gambas-user] Help! I can't find the error

[nando]

I see 10 items to SET.
I count more than 10 vars in the list of variables
??
-Fernando

---------- Original Message -----------
From: "M. Cs." <mohareve at ...626...>
To: mailing list for gambas users <gambas-user at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
------- End of Original Message -------