When performing a FullTextSQLQuery against my SharePoint site's document library and retrieving field 'Path', I occasionally get the likes of "Forms/DispForm.aspx?ID=45" returned at the end of a record's Path field. Instead of this - I want the url of the file (deemac.pdf for example). What field do I instead to refer to?
SharePoint Search will return the url to the document in Path when it thinks a file is a document (isDocument == 1), but if the file isn't a recognized file type SharePoint will treat it as a list item and return the url of the display form in Path.
You can add support for more file types by adding IFilters (see here for PDF: How to configure PDF iFilter for SharePoint Server 2010 or Search Server 2010) or just add the file type as described in How to add a file type to the content index in SharePoint 2010
You should also consider using KeywordQuery instead of FullTextSQLQuery as this isn't supported when using FAST search or in SharePoint 2013
What you are looking at IS the URL needed. Forms/DispForm.aspx?ID=45 Let's break that URL down. "Forms/" It's a form. "DispForm.aspx" That's the form used to display results; which is what the search spider used. But with out an ID entry, you won't get any form results, just the form. "?ID=45" that's the particular form results to pull up and display.
So simply put, what you got IS the URL needed to display the results. What is being shown is the result of a form submission.