Skip to main content

Fulltext predicate references columns from two different tables or indexed views

Fulltext predicate references columns from two different tables or indexed views



SELECT     dbo.CustomerMap.DisplayCategoryId, dbo.Customer.CompanyName, dbo.Customer.website, dbo.CustomerMap.Description,
                      dbo.Country.Country, dbo.Customer.phoneNo, dbo.Customer.Mobile, dbo.Customer.FaxNo, dbo.Customer.Address, dbo.Customer.AboutUsUrl,
                      dbo.Customer.ProductUrl, dbo.Customer.EnqiryUrl,dbo.Customer.email
         FROM         dbo.CustomerMap INNER JOIN
                      dbo.Customer ON dbo.CustomerMap.CustomerId = dbo.Customer.CustomerCode INNER JOIN
                      dbo.Country ON dbo.Customer.Country = dbo.Country.Id
         where freetext((CompanyName, Description),@CODE)

gives the following error.

Msg 7646, Level 16, State 1, Procedure sp_readALLCustomerBySearch, Line 11


Fulltext predicate references columns from two different tables or indexed views 'dbo.Customer' and 'dbo.CustomerMap' which is not allowed.


solution for this is use both columns in or condition in highlighted lines



SELECT     dbo.CustomerMap.DisplayCategoryId, dbo.Customer.CompanyName, dbo.Customer.website, dbo.CustomerMap.Description,
                      dbo.Country.Country, dbo.Customer.phoneNo, dbo.Customer.Mobile, dbo.Customer.FaxNo, dbo.Customer.Address, dbo.Customer.AboutUsUrl,
                      dbo.Customer.ProductUrl, dbo.Customer.EnqiryUrl,dbo.Customer.email
         FROM         dbo.CustomerMap INNER JOIN
                      dbo.Customer ON dbo.CustomerMap.CustomerId = dbo.Customer.CustomerCode INNER JOIN
                      dbo.Country ON dbo.Customer.Country = dbo.Country.Id
         where freetext(CompanyName,@CODE) or freetext(Description,@CODE)

Labels:

Comments

Post a Comment

Popular posts from this blog

UP TET 2011 Exam Application,UPTET 2011 Result | UPTET 2011 Revised Result

UPTET 2011 Result | UPTET 2011 Revised Result | UPTET 2011 Updated Result |Board of High School and Intermediate Education Uttar Pradesh, Allahabad UP TET Advertisement 2011 and Exam Detail/Admit Card/Call Letter Download UP TET 2011 FORM & DETAILS  GET LATEST DETAIL ABOUT 72825 Primary Teacher Merit List UP TET 2011 Application form submission last date is 18-Oct-2011.Forms will be distributed from PNB bank all over UP.According to latest news Appearing B.Ed student also eligible for TET exam 2011 so they can also submit their forms to concern District.There is no requirement for Rojgar Registration No and Bank receipt within the application form.UP TET 2011 exam results will be avail on http://www.uptet2011.com . Now you can easily get Application from from the P.N.B bank Branches. UPTET 2011 Result | UPTET 2011 Revised Result | UPTET 2011 Updated Result |  Board of High School and Intermediate Education Uttar Pradesh, Al...
86 comments
Read more

DataView Rowfilter With Like % in C#.Net

DataView RowFilter Syntax in C#,ASP.Net Example This example describes syntax of DataView.RowFilter expression. It shows how to correctly build expression string (without "SQL injection" ) using methods to escape values. Column names If a column name contains any of these special characters ~ ( ) # \ / = > < + – * % & | ^ ' " [ ], you must enclose the column name within square brackets [ ]. If a column namecontains right bracket ] or backslash \, escape it with backslash (\] or \\). [C#] dataView.RowFilter = "id = 10″; // no special character in column name " id " dataView.RowFilter = "$id = 10″; // no special character in column name " $id " dataView.RowFilter = "[#id] = 10″; // special character " #" in column name "#id" dataView.RowFilter = "[[id\]] = 10″; // special characters in column name " [id] " Literals String values are enclosed within single qu...
Post a Comment
Read more

UP Primary Teacher Recruitment 2011 – 72825 vacancy filled by jan 2012,Up Basic Education Primary Teacher Result, Up Basic Education Primary Teachers DIET wise Merit List, Primary Teachers Vacancy ,Teachers Vacancy in UP

Uttar Pradesh Government will recruit 72,825 Primary Teachers in schools of Basic Education council. This decision has been approved in the cabinet of UP. There are total 3,86,726 posts of teachers in the state out of which 2,84,391 posts have already been created. Currently only 1,87,155 teachers are working. There are 1,99,571 vacant posts of primary teachers  and the Government is planning to fill up 72,825 posts. Details of eligibility and application process are following: Eligibility : Educational Qualification –  Minimum 50% in Graduation ( BA / B.Sc /B.Com) with B.Ed degree Have to qualify Teacher Eligibility Test ( UP TET) Age  should be 18 to 35 years ( as on 1 st  July,2011  Applicaton fee  – Rs. 500 for General Candidates, Rs. 200 for SC, ST . There is no application fee for PH candidates. Interested candidates who are living in UP for last five years can apply from five districts of their...
12 comments
Read more