OBDC question

[patriciag]

I have two questions re OBDC link to Filemaker Pro:

1. We are using SQL calls to write info into a database, and then importing the info into Filemaker Pro. Is there any way to write direct into Filemaker Pro via OBDC? If so, how?

2. Is it possible to do the above importing a graphic file into a container?

Thanks, patriciag

[jeander]

I'm wondering the exact same thing, but from the research I've done it seems as though FM only supports inserting (or updating) text into container fields. I was hoping there was some way to transfer binary data but the more I look the more it appears as though that isn't a standard functionality...

[jeander]

Oh! I forgot to answer question 1 - duh...

FM supports basic ODBC standards so as long as your queries aren't too beastly they should be usable for FM. There are a few hoops to jump through to get it working properly, but http://www.filemaker.com/developers/resources/odbc.html has a fair amount of info on the setup.