Jump to content

Simple SQL/FMPro ?'s


JPaul
 Share

This topic is 7450 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi Justine,

forget inner /outer joins in the FMPro files: FileMaker does not support SQL statements in .fp5 files; for plug ins accomplishing (evenctually) this job take a look at www.profdata.nl or at the plug ins section on FileMaker official site.

If you clarify your concern i may provide you some help.

Bye & greetings from Holy Lands.

Link to comment
Share on other sites

Hello,

I have been gettting some mixed answers in my search to find out if (like Access) there is a way to directly query FM Pro 5 DB's using SQL statements. I heard there is a plug-in that will allow this but have yet to come across it.

I am also having trouble manipulating find requests (there are two) to show the two resulting records (both from the same DB) at the same time (as if the values were in the same record). This seems to work using a SQL inner join that joins the DB I am querying to itself in Access, but...the question arises about if I could use SQL in FMPro 5. If not, is there some other way to do this by using a Script or something?

Thanks in advance,

J -

Link to comment
Share on other sites

This topic is 7450 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.