1. Helge Tjelta
  2. Valentina Database ADK
  3. 月, 2月 23 2015, 05:00 PM
  4.  メールで購読
Hi, I want to make a more google like search.

What ever is in input text I want it to search in all fields in my cursor. But I don't want to write all the fields in my WHERE LIKE.

So how do I do:

Select field1, field2, .... field12
In Tbl1
WHERE * LIKE Something

Or is this more quiker to do in Xojo API directly ?

Right now I'm using search control from einhugur, and start search whenever the textfield is more than 3 characters.
But I don't want to add all the fields manualy in the WHERE part...
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Well, John uses in his "Bookend" app for this task a Table Method, which is defined as concat() of f1 .. f59.

This Table Method creates index of such strings. So when you do
WHERE fldTextAll LIKE Something

you will get exactly what you want.
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories