MULTIPLE VARIABLES IN MDQ FILE

[eyetry]

I am having a problem generating a (query) tree within the DB Interface Designer.

I'm connecting to the DB fine and can genrate both tables and a tree from a simple query with no variables. I can also generate a tree using one variable in the query. Multiple variables cause the build to fail.

Sample syntax (I'm new to the DB world)...

Select * From DBName Where Member_ID = #ID# and Last_Name = #LName#

Both values are defined as text in the DB and I've defined the variables with moc values (with and without single quotes)

eyetry

 

[Myggiz]

Whats the error you'r getting.
Just tried the same syntax and had no problems at all...

// Roberth

 

[eyetry]

Thanks Myggiz!

The sample I posted here worked for me too. So it had to be the syntax of my real query. I had the query formated like this..

Select * From DBName
Where Member_ID = #ID# and
Last_Name = #LName# and
DOB = #Date#

Should have been

Select * From DBName
Where Member_ID = #ID# and <sp>
Last_Name = #LName# and <sp>
DOB = #Date#

Works now