Source language: Translate to:

Query Issue

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Query Issue

Postby Pat Baner » Tue Apr 12, 2011 9:05 pm

I am having some issues with a query and would like to see if someone can shed some light.

I have a database with a table (duh right). I have 6 fields, 3 boolean and 3 integer fields. the integer fields are blank. Here is my query string:

dbpQuery "CRDB" "ClientAccounts" "CreditorAppearsOnEX = True AND EXDisputeLetter < 0"

I know that there are records that meet this combination but it keeps giving me 0 records returned when I test for it.

I have also tried <= 0 with the same results, zero records found.

Any ideas?
Pat Baner
 
Posts: 75
Joined: Tue Jan 04, 2011 9:21 am

Postby Pat Baner » Tue Apr 12, 2011 10:16 pm

Nevermind figured it out.

"Read the directions even if you don't follow them".

"IS NULL" was the solution.
Pat Baner
 
Posts: 75
Joined: Tue Jan 04, 2011 9:21 am


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 3 guests