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

M. Cs. mohareve at ...626...
Thu Jan 19 21:57:53 CET 2012


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!




More information about the User mailing list