director and access 1

[magazine]

Hello.

First doubt: (Acess)

How to put a video (.mov)?
I’m inserting it by OLE Objects – Create from file

How to put an image (.jpg)?
I’m inserting by OLE Objects – Create new from Bitmap Image


Second doubt: (Director)

set sqlString= "SELECT video FROM videogesto WHERE IDgesto = 1"

erase member 53

DGRSImportResource(member 53, "video", rsHandle)

Note1:
This is the function to import the image and the video.
Note2:
Instead of just giving the image for IDgesto 1, we can see the same image for all IDgestos.



Third doubt: (Director)

It is possible to put on the same code several sqlString?

set sqlString= "SELECT designacao FROM gesto WHERE designacao = '" & pesquisa & "'"

set sqlString= "SELECT video FROM videogesto WHERE IDgesto = 1"

We want to retrieve text, video and images at the same frame on different casts members.
It is possible?

Thank you.

 

[binbin]

We have an xtra exactly fit your needs.
Still in test, see screen shot:

http://www.xtra-ucd.com/pages/screen.php?language=en&pdid=20

introduction:

http://www.xtra-ucd.com/pages/page.php?product=xtra#XTinyADODB

download:

http://www.xtra-ucd.com/pages/download.php?product=XTinyadoDB#XTinyadoDB

 

[binbin]

It's not a good idea to put large files like video to a database. you can store path and filename in database and stroe video file externel.

 

[magazine]

Hi.

I've found the answer for all.
Thank you.

 

[qazs]

Hi magazine,
I'm also trying to access a database.
Is it possible to use SQL in Director?
If so, how?
Anyone who has work with the query language in Director, please help me out.
Thanks.

 

[magazine]

Hello qazs.

I use sql querys to retrieve data from a access database.
But you have to use a xtra, in my case, we are using datagrip.

Datagrip is an extension Xtra for Macromedia Director and Authorware that provides a powerful and simple interface to Microsoft Access-format databases .

It's easy.

 

[qazs]

Thanks magazine, I'll try that.