FP and SQL - Part 2

Art · Apr 25, 2004

A31 is set up as varchar in the SQL table

I also tried Tom Rowes query format and all I was able to
get is a schema error

the problem is that all this worked before and we just
cant figure out what changed to start causing the error

Subject: Re: FP and SQL search
From: "Kathleen Anderson [MVP - FP]"
<[email protected]> Sent: 4/23/2004 3:57:35 PM

I don't think Art has said what kind of field a31 is (text
or number).

I haven't used the DRW with SQL Server, but I will give it
a shot.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Cowboy (Gregory A. Beamer)

Kathleen may be the best person, as she is our DRW MVP guru, but it
would be helpful to add a followup with a few more steps and how you
are filtering (completely with DRW, writing any SQL, etc.). More
input will certainly help here.

Generic answer (problems I have seen in the past):
If you are writing ANY of the SQL is the fact that many come from the
Access (aka, bastardized SQL) world and try to move Access SQL to
T-SQL. This, unfortunately, fails more often than it works, at least
in my experience.

***********************************************************
***********
Think Outside the Box!
***********************************************************
***********
"Lost with FP 2002 and SQL"

wrote in message news:36ea01c4296a$a4c606d0 [email protected]...

..