Accessing FM7 odbc data source From within FM7

[silver_surfer]

Hi

How can I get a FM7 client data source to appear as a DNS source within FM7 execute sql script step on a mac. I've tested the odbc connection outside FM7 using odbctest and it works fine. I don't seem to have a problem with it on a pc. I've tried removing the DataDirect sql client as stated on the FM site but that just left me with no odbc support within FM at all.

Thanks

[Wim Decorte]

Why would you use ODBC to transfer data from a FM file to another FM file? You can import/export or use Set Fields.

That being said, there are reports of people making this work on Windows but not on Mac. There could a hard-coded block preventing this.

[silver_surfer]

Basically I want to be able to build dynamic queries on the fly, that can be used to build reports. I could do the same thing with calculations but an sql string seems like a very simple and flexable way to do it.

[Dan-A]

What you may want to test for, is if errors get passed back to FM when you

generate your reports...

I tried an UPDATE sql statement only to find out that if there is no match

and therefore no update is done...no error is sent back to FM!!

So you may end up creating an empty report on the fly!!

Dan