I cant run the simplest queries I have build. See Example 2

[elevator]

datemethod pushButton(var eventInfo Event)
varqVar query
endVar

qVar = Query

:data:CzerMov.db |Title|
|Check|

endQuery
qvar.executeQBE("riv:answer.db"

post here also reach me at elevator@graffiti.net

 

[elevator]

I get a syntax error
a blinking cursor between .db and |Title|

 

[JoeNg]

Try the same query interactively.
If it has executed successfully, save the query.
Use Notepad to open the saved query, now you can copy and paste to where ever you want.

 

[Langley]

If that's a straight cut and paste, you need a &quot" at the end of your last statement. Also, you should try using some of the default arror trapping. It can usually identify what's wrong.

if not qvar.executeQBE(":priv:answer.db")
  then errorShow()
endif

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

 

[Bystander]

If that is a straight cut and paste then you really should try

var
qVar query
endVar

Rather than

varqVar query
endVar

If it is of any use I tried the following and it worked

method pushButton(var eventInfo Event)

var
qVar query
endVar

qVar = Query

:data:CzerMov.db |Title|
|Check|

endQuery
qvar.executeQBE("riv:answer.db&quot

EndMethod




Regards

Bystander

 

[JoeRestle]

I cant run the simplest queries I have built.

 

[footpad]

Joe,

We'll need a little more to go on. Can you tell us:

1) The query you're trying to run
2) What happens whn you run it
3) What you though should happen?
4) What version of PAradox you're working with?

That would help us troubleshoot your problem.

-- Lance