Does Paradox 10 have a switch to turn on Quary 2

[elevator]

Is there a query on and off switch in Paradox?
I have tried to quary a table for the last two weeks,
and I have not been able to.

method pushButton(var eventinfo Event)
Var
Q Var
endVar

Q = Query

:work:mov.db |Warehouse |
|check |

endQuery

q.executeQBE("priv:answer.db&quot

endMethod

 

[JoeNg]

Try This:

Var
Q Var
endVar

Q = Query

:work:mov.db |Warehouse |
|check |

endQuery

If Not q.executeQBE() Then
ErrorShow()
EndIf

endMethod

By default, the results go to the RIV:Answer.db table.
So, you don't have to include it in q.executeQBE().

If the query is failed, you will see the system error message.

 

[Langley]

Try changing Q to a 'query' variable type. Right now it shows to be a VAR variable, which I don't believe is possible in this context.
Mac

"Strange women lying in ponds and distributing swords is no basis for a system of government" - Dennis, age 37

mailto:langley_mckelvy@cd4.co.harris.tx.us

 

[JoeNg]

Ooops! Mac is right.

It should look like this:

Var
Q Query
endVar

Q = Query

:work:mov.db |Warehouse |
|check |

endQuery

If Not q.executeQBE() Then
ErrorShow()
EndIf