Compare design time variable to run time variable

[Chong]

How do I use a Data Adapter configuration wizard to generate a query that will compare the variable in the query to my run time variable?

This is what I have but it doesn't work. The wizard kept giving me errors:

SELECT
Personal.*,
Education.*,
Response.*
FROM
Education,
Personal,
Response
WHERE
Personal.SSN = @intSSN
Response.SSN = @intSSN

Please help if anyone knows.

Thanks!

Chong

[VBCrazyCoder]

I usually put the query in a stored procedure, and then pass in my runtime values as parameters.

[Edneeis]

Not all datasources support parameters, or some support them differently. What datasource are you using? Access? SQL?

[hellswraith]

It looks like your query is wrong too. Should it be a join statement?

[Chong]

Thanks for helping me out. I am using MS Access mdb. The codes was just a sample I copied from the configuration wizard. It doesn't matter if I have the join or not. I was trying to do it in different ways but obviously it doesn't work.

How do I use store procedure?

Thanks!

Chong