I'm trying to import some audio to my movie (Director 8.5) from a DB Access. The sound are saved on external casts. This is the line on DB:
audioname.CST/micro.wav
"audioname.CST" is the name of the external cast and "micro.wav" the name of the wav file.
What I am looking for is that when u choose some word (from a scroll list of objects) the sound of the word choosen is listenning.
This is the code:
global search
on EnterFrame me
-- QUERY AUDIO
set sqlString="SELECT audionome FROM gesto WHERE Designacao Like '" & search & "'"
set rsAudioName = DGCreateRecordset(sqlString, dbHandle)
-- RECORDSET AUDIO NAME if rsAudioName = "#ERROR#" then alert "Error" & GetLastDGError() alert "Quit quit end if
-- AUDIO NAME
myDBValue = dGRSGetFieldValue("audioname" rsAudioName)
str = the itemDelimiter
the itemDelimiter = "/"
myCast = myDBValue.item[1]
myAudio = myDBValue.item[2]
the itemDelimiter = "."
myCast = myCast.item[1]
myAudio = myAudio.item[1]
the itemDelimiter = str
DGRSImportResource(member 120,"audioname", rsAudioName)
puppetSound member 120
erase member 120
-- dont' even ask me why I write this because I simply don't know. I read something about sound and I --- am trying to do something that could work.
DGRSClose(rsAudioName)
rsAudioName=0
sqlString=0
end
Well.... someone could help me? Because this is not working. Thank you all. Rico.
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
[To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
