by wolfram.brod » Sun Apr 05, 2015 5:17 pm
I'm writing a script to get some information out of the songs table, but it's a bit confusing. This is the code:
ff = "SELECT * FROM Songs where ID=" & f1
set song = MM.Database.OpenSQL(ff)
for x = 0 to 99
text = song.stringbyindex(x)
next x
The values I get for x=0 to 6 are correct. However: the song title, which ist in the description shown as field no.7 is shown with x=11. The song path is shown with x=12, but with x=13 I get "mp3", which is defenitely not the year!! And so on.
Where my I get a description of the songs table with the field-explanation in the correct sequence?
I'm writing a script to get some information out of the songs table, but it's a bit confusing. This is the code:
ff = "SELECT * FROM Songs where ID=" & f1
set song = MM.Database.OpenSQL(ff)
for x = 0 to 99
text = song.stringbyindex(x)
next x
The values I get for x=0 to 6 are correct. However: the song title, which ist in the description shown as field no.7 is shown with x=11. The song path is shown with x=12, but with x=13 I get "mp3", which is defenitely not the year!! And so on.
Where my I get a description of the songs table with the field-explanation in the correct sequence?