Source language: Translate to:

a search engine with a suggestion list

NeoBook tips, tricks, code samples and more...

Moderator: Neosoft Support

a search engine with a suggestion list

Postby thopok » Tue Jul 17, 2007 1:03 pm

Hello to every bodies
sorry for my english
I want to realize with dB, a search engine with a suggestion list which recovers up to date for every change in the cell (exactly as what you can find on Internet with "Internet explorer" with the search engine of google). the problem is to make the list of suggestion as well as a list of words which start with the letters writed in the cell
ex: vi = victim, victory
and non
invincible
by advance thank you

:oops: [/b]
thopok
 
Posts: 10
Joined: Wed May 17, 2006 12:14 am
Location: Yvelines

Postby Neosoft Support » Wed Jul 18, 2007 11:29 am

I'm sorry, I don't understand exactly what you are looking for, but there are several database plug-ins available at the NeoBook Resource Center:

http://www.neosoftware.com/neobook/

Maybe one of these plug-ins can be adapted to do what you want.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5605
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby thopok » Wed Jul 18, 2007 2:33 pm

I'm really sorry for my english ...

for my search engin

i search with dbfquery in my data base
"vi"
and it show
"vi"ctime, "vi"ctory
and
in"vi"ncible

i just want it show : "vi"ctime and "vi"ctory
in fact : every words that bigine with "vi"
an no each word which contains "vi"

thank
thopok
 
Posts: 10
Joined: Wed May 17, 2006 12:14 am
Location: Yvelines

Postby thopok » Wed Jul 18, 2007 2:36 pm

I'm really sorry for my english ...

for my search engin

i search with dbfquery in my data base
"vi"
and it show
"vi"ctime, "vi"ctory
and
in"vi"ncible

i just want it show : "vi"ctime and "vi"ctory
in fact : each word which starts with "VI"
an no each word which contains "vi"

thank
thopok
 
Posts: 10
Joined: Wed May 17, 2006 12:14 am
Location: Yvelines

Postby Neosoft Support » Wed Jul 18, 2007 5:23 pm

...i just want it show : "vi"ctime and "vi"ctory
in fact : every words that bigine with "vi"
an no each word which contains "vi"


Unfortunately, you can't do that kind of search with NeoBookDB. However, you can do it with NeoBookDBPro. For example:

dbpQuery "Database" "Table" "field LIKE vi%"

will find only words that begin with "vi" like

victim
victory
vitamin
viceroy
...

You can find NeoBookDBPro at the following web site:

http://www.neosoftware.com/neobook/modules/plugins/singlefile.php?cid=2&lid=75
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5605
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby David de Argentina » Wed Jul 18, 2007 7:24 pm

Neosoft Support wrote:dbpQuery "Database" "Table" "field LIKE vi%"


Try this Query:

dbpQuery "Database" "Table" "field LIKE %vi%"

In theory, %vi% search in any place of the string

Greetings from Buenos Aires,
David de Argentina
User avatar
David de Argentina
 
Posts: 1562
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Postby thopok » Thu Jul 19, 2007 2:56 pm

Thank you !!!!!

:D
thopok
 
Posts: 10
Joined: Wed May 17, 2006 12:14 am
Location: Yvelines

I RESOLVE SOMTHING LIKE THIS

Postby virger » Tue Aug 07, 2007 8:55 pm

TRY THIS.

.CREATE A DBFSORT
dbfSort "Base" "Index.ndx" "field" "Ascending"

[vPala]....WORD TO SEARCH


if "[vpala]" "<>" ""
dbfFind "Base" "field" "[vpala]"
if "[dbferror]" "=" ""
strlen "[vpala]" "[ln]"
dbfQuery "Base" "field = [vpala]"
setvar "[numqr]" "[dbfqueryresult]"
dbffirst "Base"
ListBoxDeleteItem "DIC" "All"
loop "1" "[numqr]" "[n]"
substr "[Base.field]" "1" "[ln]" "[bs]"
if "[bs]" "=" "[vpala]"
ListBoxAddItem "DIC" "0" "[Base.field]"
endif
dbfnext "Base"
endloop
endif
endif

FROM COSTA RICA, "PURA VIDA"
GDO...
User avatar
virger
 
Posts: 524
Joined: Mon Sep 18, 2006 12:21 pm
Location: Costa Rica, America Central


Return to NeoBook Knowledgebase

Who is online

Users browsing this forum: No registered users and 3 guests

cron