Jump to content
Sign in to follow this  
JPaul

Simple SQL/FMPro ?'s

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.

Share this post


Link to post
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 -

Share this post


Link to post
Share on other sites

JPaul,

The website you referred is a great resource! It's just the info I was looking for.

Thanks,

J-

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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