Page 1 of 1

a search engine with a suggestion list

PostPosted: Tue Jul 17, 2007 1:03 pm
by thopok
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]

PostPosted: Wed Jul 18, 2007 11:29 am
by Neosoft Support
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.

PostPosted: Wed Jul 18, 2007 2:33 pm
by thopok
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

PostPosted: Wed Jul 18, 2007 2:36 pm
by thopok
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

PostPosted: Wed Jul 18, 2007 5:23 pm
by Neosoft Support
...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

PostPosted: Wed Jul 18, 2007 7:24 pm
by David de Argentina
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

PostPosted: Thu Jul 19, 2007 2:56 pm
by thopok
Thank you !!!!!

:D

I RESOLVE SOMTHING LIKE THIS

PostPosted: Tue Aug 07, 2007 8:55 pm
by virger
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...