Looking for *= in queries?

[Maury Markowitz]

We are considering upgrading from SQL Server 2000 to 2008, but the
Compatibility Wizard states that *= is no longer supported. I looked
through our modules and storedprocs and found a couple of examples
that I was able to fix.

However, I am sure that there are many instances of this in queries
coded directly into the forms and reports. How can I find these?

Maury

 

[Stuart McCall]

We are considering upgrading from SQL Server 2000 to 2008, but the
Compatibility Wizard states that *= is no longer supported. I looked
through our modules and storedprocs and found a couple of examples
that I was able to fix.

However, I am sure that there are many instances of this in queries
coded directly into the forms and reports. How can I find these?

Maury

Dim qdf As Dao.QueryDef

For Each qdf In DBEngine(0)(0).QueryDefs
If Instr(1, qdf.SQL, "*=") > 0 Then
Debug.Print qdf.Name
End If
Next

Any names that turn up with ~sq as the first three characters are embedded
into Forms, Combos etc. It's pretty easy to work out where they are from
their names.

You need a reference to DAO for this to work, of course.

 

[Maury Markowitz]

This is excellent stuff! Is there a way to adapt this for ADP's as
well?

Maury

 

[Stuart McCall]

This is excellent stuff! Is there a way to adapt this for ADP's as
well?

Maury

Sorry, no. I've always been strictly mdb. Perhaps someone else will chime in
with a suggestion for you.