Where do the results of a SQL Select go?

[Skeeve Stevens]

(Excuse the crosspost - I didn't put the original in the correct forum)

OK

I am new to SQL... and I think I am doing pretty well. I have a mySQL server running on Linux with a database setup and the myODBC working happily.

I wrote a script which can do a insert of data from Filemaker over to the mySQL server... and it works great.

Now... I can execute a SQL query - such as a SELECT blah from blah; and the SQL statement is working fine on the server... and the server is giving back to Filemaker the result... but.. what is Filemaker DOING with that result?

How do I do a select and get that data into a field of a record? It is driving me nuts!

If anyone can help... PLEASE PLEASE do... (email copy and post here please)

...Skeeve

[email protected]

[mattley]

I think FileMaker is broken in this respect. :?

Putting the SQL into a script, If I use the query builder then I can use the Specify Import order Dialog to map the field import order and it works fine. But the where clause gives me no option to use a value from my own database which seems a ridiculous ommission to me.

It wouldn't be so bad if I could use a calculated import query but then it seems not to see any of the fields in the import order dialog.

I need to find an answer or workaround for this quite urgently, I'm hoping just a stupid syntax issue.

[mattley]

Ha

I copied the built query into a calc, catted my fild into the where clause and it worked. The Maps are still blank, but FM seems to have remebered whats going on.