-
MS Access ODBC error - need help badly
Hi,
I'm having a huge problem I can't solve. I hope some of u got the answer to my "riddle".
I'm trying to link from a template-file to a ms-access-database. The reason for that is, that I want to generate a flash-file with the template. The template looks somewhat like that:
DATABASE {
DRIVER "ODBC"
NAME "bildertest"
}
SET dbim "'1'"
SET dbph DBQ "select image from bildertest where id=" + $dbim
DEFINE IMAGE "im" -quality 100 -size 745,504 $dbph
There should be nothing wrong with that, at least not in my opinion. The database it self looks like that:
ID-------images--------------- comment
1 -------c:imagesdlux.png----d-lux
...
now when running the applet I get the following error-msg. The msg is translated from german, so maybe not correct, but I hope you will get the meaning: The msg is:
[Microsoft][Microsoft access odbc-driver]datatype in criteria-expression invalid
What the heck is wrong with my sql-statement or with my database.
Help would be highly appreciated.
Thanks alot
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|