Hello.

This is a movie done on Macromedia Director that all the information comes from an access database. We're using the XtraDataGrip.

All the data are save on external casts and the records on access only have the path:
Code:
videos.CST/aseguir.mov
This code works fine to give one video:

Code:
 myDBValue = dGRSGetFieldValue("video" rsvideo) 
  str = the itemDelimiter
  the itemDelimiter = "/"
  myCast = myDBValue.item[1]
  myVideo= myDBValue.item[2] 
  the itemDelimiter = "." 
  myCast = myCast.item[1]
  myVideo = myvideo.item[1]  
  the itemDelimiter = str
  set the member of sprite 12 to member (myvideo,myCast)
Now we want the same but giving 3 images.

This is the sql query:

Code:
set sqlString="SELECT imagem FROM (gesto INNER JOIN imgpicto ON gesto.IDgesto = imgpicto.IDgesto) WHERE gesto.Designacao Like '" & pesquisa & "'"
  set rsImagem = DGCreateRecordset(sqlString, dbHandle)
And the final code:

Code:
myDBValue = dGRSGetFieldValue("imagem" rsImagem) 
  str = the itemDelimiter
  the itemDelimiter = "/"
  myCast = myDBValue.item[1]
  myImage = myDBValue.item[2] 
  the itemDelimiter = "." 
  myCast = myCast.item[1]
  myImage = myImage.item[1]  
  the itemDelimiter = str
  set the member of sprite 18 to member (myImage,myCast)
  set the member of sprite 19 to member (myImage,myCast)
  set the member of sprite 20 to member (myImage,myCast)
This code gives 3 images but the same one. How can we tell lingo to retrives the 3 different images that are on DB?



Thank you.