.t. in query.filter not working

[martinwcole]

I recall someone else mentioning this, but I can't find the thread.

if I use .t. in a query filter I get the error field not found or similar

[Tom Cone Jr]

Why use .t. in filter expression?

Martin,

I don't use or need it for logical fields.

Here's an example, using the logical "ship_same" field in the Customers table in AlphaSports:

tbl = table.open("customer")
query.options = "M"
query.order = ""
query.filter = "Ship_same"
qry = tbl.query_create()
?qry.records_get()
= 52

qry.drop()
?tbl.records_get()
= 60

And, for false, I'd use ".NOT. Ship_Same"

-- t

[martinwcole]

my post was misleading, Tom. Sorry. I wasn't meaning like
query.filter="somefield=.t."

I meant
query.filter=".t."

I first saw this approach used by Alpha in V5. And it works in V5 and V6, but not in V7.

I'm using it in a scnaio like this

if such and such is so
var->gpc="client_id='21'"
elseif such and such is so
var->gpc="client_id='22'"
else
var->gpc=".t."
end if
query.filter=gpc + " .and. city='boston'"

I will have no problem programming around this - I'm just trying to confirm that I cannot use .t. in a filter, anymore.

[JerryBrightbill]

I just ran a variation of your script in Alpha Sports in V7 and it worked as expected

if 1= 1
	var->gpc=".t."
else
	var->gpc = "Bill_State_Region = \"MA\""
end if
query.filter=gpc + " .and. Bill_City='boston'"
query.order = "lastname"

tbl = table.open("customer")
qdx = tbl.query_create()
if qdx.records_get() = 0
	ui_msg_box("","No records")
	end
end if 
msg = ""
tbl.fetch_first()
for i =  1 to qdx.records_get()
	msg = msg + tbl.lastname + crlf()
	tbl.fetch_next()
next
	
ui_msg_box("",msg)

If I replace the 1=1 with 1=2, it also works as expected. However, I would typically use different syntax for the variable definition. Either dim the variable first or just implicitly define it in the script. For example, this would be one option.

delete gpc
dim gpc as c

if 1= 1
	gpc=".t."
else
	gpc = "Bill_State_Region = \"MA\""
end if
query.filter=gpc + " .and. Bill_City='boston'"

or I could just be lazy and implicitly define it.

if 1= 1
	gpc=".t."
else
	gpc = "Bill_State_Region = \"MA\""
end if
query.filter=gpc + " .and. Bill_City='boston'"

I don't think you need var-> in an implicit assignment.

[martinwcole]

took me a few minutes to figure this out, but as it turns out, the use of ".t." is not the issue.

the issue is that the global variable [gpc] is losing its value
I disabled all scripts except onkey
I went to the interactive window and typed gpc="xxx"
'gpc is a global vaiable
and verified its value
in the onkey event of the form i put
msgbox("","" + gpc)
end
and it returned a value of "" (nothing)

then, in oninit I added
gpx="xxx"

but got the same results

[Selwyn Rabins]

I can't duplicate the problem, but if you can send me files that allow us to duplicate the problem, we will investigate.

[Scott Emerick]

Martin,

Just a thought. Check to make sure you are not declaring "gpc" someplace else as a local or shared variable. I have seen this result when this is the case.

Scott

[martinwcole]

thank's Scott - no I was also declaring it in the onint event

I found the problem. I have an embedded browse on the form
at the canarrive event of the form, I say
var->gpc=parentform.filter_get()
this is resetting it to ""

in the oninit event, I say
gpc=".t."
t=table.current() 'form based on one table
query.filter=".t."
query.order="labnum"
t.query_create()
t.fetch_first()
browse1.refresh()

and until I click in the embedded browse, it holds
apparently, in V7, although the parent table is querried, the form's filter is still = ""
I'm going to send it to Selwyn anyway, in case he sees any value to it.