Source language: Translate to:

Query using NeobookDB

Questions about NeoBook PlugIns

Moderator: Neosoft Support

Query using NeobookDB

Postby rishi » Fri Apr 06, 2007 8:39 am

Hi All

I want to know as I can do than utilizing dbfQuery
Looking for 7101 in the following list:

7101
710111
71011100
21710100
37101300
45710100

Only display as a result of the quest:

7101
710111
71011100

From now on many thanks.

Gustavo
rishi
 
Posts: 71
Joined: Wed Oct 05, 2005 1:23 pm

Postby beno » Fri Apr 06, 2007 8:58 am

Hi Gustavo,

It would be easier if you post the code you are using.

Are you using a single = sign or two ==?

Check the dbfQuery action in the NBDB help file, there is a difference in = and ==.

HTH,

beno
User avatar
beno
 
Posts: 678
Joined: Fri Apr 01, 2005 9:03 am
Location: México

Postby rishi » Fri Apr 06, 2007 3:03 pm

Hi Beno

Thank you for the answer, but I am sure that not you have tried it right now than utilizing the Query with the mentioned list, utilizing the sign:

= I get the complete list from numbers that 7101 contain

And using

= = I obtain only the first field that contains exactly 7101

I want desire obtaining all fields that start with 7101 like the second list.

Again many thanks.

Gustavo
rishi
 
Posts: 71
Joined: Wed Oct 05, 2005 1:23 pm

Postby Sam Cox » Fri Apr 06, 2007 4:01 pm

Try something like this:
Code: Select all
dbfQuery "database.dbf" "FIELDNAME*7110"

If I remember correctly, the asterisk character means "begins with."
User avatar
Sam Cox
 
Posts: 768
Joined: Fri Apr 01, 2005 7:30 am
Location: Loveland CO USA

Postby smartmedia » Fri Apr 06, 2007 4:47 pm

Hi...

Gustavo

I have create a demo pub with a workaround for you...
It can easy be adjust for database...

http://rapidshare.com/files/24699183/Search.pub

Try it and tell me if is working for you...

Thanks
User avatar
smartmedia
 
Posts: 889
Joined: Fri Apr 01, 2005 6:50 am
Location: Hellas

Postby rishi » Fri Apr 06, 2007 10:24 pm

Hi All

Again thanks

To Beno to respond so fast
To Sam to deliver me what really you fit up to my initial order, and
To Smartmedia to prepare the demo pub that also I will utilize in my application

This forum is incredible, this thanks to the people that you integrate it.

Greetings.

Gustavo
rishi
 
Posts: 71
Joined: Wed Oct 05, 2005 1:23 pm


Return to PlugIn Discussions

Who is online

Users browsing this forum: No registered users and 2 guests