Board index paradox

Query ReadFromFile and variables

Query ReadFromFile and variables

Post by So'n'S » Fri, 09 Oct 1998 04:00:00



I am able to use a tilde variable in an embedded (hard-coded) query in my
code.  I would like to readFromfile, set the value of the variable and run
the query.  Anyone know how to do this?  (I have the original query saved
with the tilde variable in it).  Do I need to do some fancy conversion to a
queryString?
 
 
 
Top

Query ReadFromFile and variables

Post by Michael Irwin [CTech » Sat, 10 Oct 1998 04:00:00


A queryfromfile has to read in a legal query. A query with tildes in it isn't
legal until the tilde-variables are replaced with real values. Therefore you'll
have to come up with some other way of doing things. I leave my queries
hardcoded in the ObjectPAL, writing them out just before execution to provide a
debugging aid.

Mike


> I am able to use a tilde variable in an embedded (hard-coded) query in my
> code.  I would like to readFromfile, set the value of the variable and run
> the query.  Anyone know how to do this?  (I have the original query saved
> with the tilde variable in it).  Do I need to do some fancy conversion to a
> queryString?

--
Mike Irwin
[Volunteer CTech Sysop, not a Corel employee
Please post enquiries and responses to the Corel newsgroups (cnews.corel.ca).]

 
 
 
Top

1. Tilde variable & Query ReadFromFile

Has anyone tried to dynamicly assign a variable value using a tilde
variable in a query that is read from file?  I tried the following
(with ~aType in the query)

aType="Mechanical"
q.readFromFile(":ROYMAST:NewReleases.qbe")
q.executeQBE()

This generates an error that the variable is not defined.  It only
works if I paste the query in (hard code it).

Any thoughts on whether this is correct Pdox behavior?

Noah

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

2. consistent subset

3. Query readFromFile and tilde variables

4. Problem to see the newgroup

5. Query.ReadFromFile

6. SQL Links + Oracle

7. How to assign a value into local variable from a query in string variable

8. Help! Trouble with Triggers

9. Data Driven Query - specify query in global variable?

10. Passing Variable off Form to SQL Pass Through Query

11. Need help with query that needs Dynamic SQL, variables, and Temporary tables

12. IS it possible to make a query that searches in a table with tablename xxxxx (variable)

13. Beginner question - using Query Analyzer with variables


All times are UTC
Board index