At 12:46 PM 2/12/2008, Robert P. Agemco wrote:
When using "Designing Search Forms Using DB Grid Control", I found
that it will not search
on a Company Name more than 1 word in lenght. If two or more words
are search upon in a
string, then Error condition 2045 is generated. (Syntax is incorrect
for the command Property)
The following code in this form:
SET VAR vSearchString = +
('PROPERTY TABLE Customer SEARCH->'+.vColumnName+'->'+.vSearchValue)
&vSearchString
where .vSearchValue is a text variable containing the Company Name.
I would like to search a column with the full Company Name.
Robert,
Change the vSearchString as following:
SET VAR vQuotes = (CVAL('QUOTES'))
SET VAR vSearchString = +
('PROPERTY TABLE
Customer'&.vQuotes+'SEARCH->'+.vColumnName+'->'+.vSearchValue+.vQuotes)
&vSearchString
That should take care of searching any text string with more than one words.
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
