Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 22nd, 2024, 6:49 pm

All times are UTC [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Database Prob
PostPosted: May 15th, 2006, 9:26 am 
Offline

Joined: April 27th, 2006, 1:34 pm
Posts: 37
Location: Belfast
Opus: 9.03
OS: Win 7
System: i5 - 6gig RAM
Hi Folks
Been working on my first database connection and have got most things working but cant get it to update the records. Also is it possible to pull a photo from access to opus. I have attached a small project.
Mant thx
Paul


You do not have the required permissions to view the files attached to this post.


Top
 Profile  
 
 Post subject:
PostPosted: May 15th, 2006, 9:28 am 
Offline

Joined: April 27th, 2006, 1:34 pm
Posts: 37
Location: Belfast
Opus: 9.03
OS: Win 7
System: i5 - 6gig RAM
Sorry was not allowed to post database db1(ms access) or photo(bmp).


Top
 Profile  
 
 Post subject:
PostPosted: May 15th, 2006, 10:19 am 
Offline

Joined: October 26th, 2004, 10:23 am
Posts: 666
Location: Digital Workshop
When attaching items to posts it is best to ZIP them first - this decreases the size and is one of the file types allowed to be posted.

It is not possible to read binary data (e.g. pictures) from a database. However it is much simpler to include a field in the database which contains the filename (rather than the file itself) and then reference the files by making a full path using variables - for example, something like:

Code:
ImageName = SYSTEM_PUBLICATION_DIR + "Images\\" + FilenameDatabaseField

_________________
ddww Opus Developer


Top
 Profile Visit website  
 
 Post subject:
PostPosted: May 15th, 2006, 11:45 am 
Offline

Joined: April 27th, 2006, 1:34 pm
Posts: 37
Location: Belfast
Opus: 9.03
OS: Win 7
System: i5 - 6gig RAM
Thx for the info Duncan. Attached is the zipped version. Hope someone can help.


You do not have the required permissions to view the files attached to this post.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 63 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group