Home > Archive > Whish List > April 2005 > datamodule.onDesignOpen









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author datamodule.onDesignOpen
Rick Gearardo

2005-03-31, 8:04 pm

If you are using a variable in a where clause it generates a dQuery error.

Rick


Danita Brooks

2005-04-09, 8:25 pm

Rick,

> If you are using a variable in a where clause it generates a dQuery error.


Could you please provide a test case?

Thanks,
Danita Brooks
dBI


Rick Gearardo

2005-04-09, 8:25 pm

Hi Danita,

During design _app.third_f1 is not defined so dQuery generates an error. If
you assign a value to it in the command window before opening it it works
fine.

Rick

this.SERCALL1 = new QUERY()
this.SERCALL1.parent = this
with (this.SERCALL1)
left = 125.0
top = 45.0
width = 114.0
height = 122.0
sql = 'Select * from "sercall.DBF" where f_value = ' + '"' +
_app.third_f1 + '"'
active = true
endwith

Rick

> Could you please provide a test case?



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com