Parse query options into a valid SQL string

[Shannon]

Why do I get the message, "Word can not parse your query options into a valid SQL string?

What can I change to get this to work

Thanks, Shannon

 

[Peter Jamieson]

What it usually means is that Word has got confused about the type of data
in a column in your data source, and builds the wrong piece of query
language. For example, if it thinks the field is a number, it should build a
bit of language like "WHERE myfield = 123", but if it thinks the field is a
piece of text it should use "WHERE myfeild = '123'). This can occur because
the data converters that get data on behalf of Word may logically have to
make guesses about what data is in a column.

Although you may not always be able to solve this problem easily, (we'd at
least need to know which version of Word and what the data source was to
start thinking about a solution), if your data source is Excel and you have
a column where some of the data is numeric and some is alphanumeric, you may
need to refomat the column in Excel as text and reconnect Word to your data
source.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?U2hhbm5vbg==?=,

Why do I get the message, "Word can not parse your query options into a valid SQL string?"

Because Word isn't able to understand some kind of filtering conditions you're trying to
set.

Which version of Word? What's the data source type? Under exactly what circumstances (after
performing which commands) do you get this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail

 

[Guest]

Thank You.

Peter nailed it when he talked about confusing data
types. You were onto that too, I could tell. I was
querying a field (column in Excel) that had trophy
placement, such as 1st, 2nd...Honorable Mention. Query
had a little problem with the 1 in 1st and so on.

Once I declared the format as text, it did fine.

Thanks again, Shannon

-----Original Message-----
Hi =?Utf-8?B?U2hhbm5vbg==?=,

Because Word isn't able to understand some kind of

filtering conditions you're trying to

set.

Which version of Word? What's the data source type? Under

exactly what circumstances (after

performing which commands) do you get this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any

follow question or reply in the

 

[Shannon]

Forget what I said, I was on the wrong field when it
worked. I have Microsoft Word 2000 merging data from
Excel. I receive the error after closing the query
window. The data is formated as text, but I still get the
problem. It is still the data with 1st, 2nd...Honorable
Mention that it has a problem with. When I thought it
worked, I was clicking the wrong title.

-----Original Message-----
Hi =?Utf-8?B?U2hhbm5vbg==?=,

Because Word isn't able to understand some kind of

filtering conditions you're trying to

set.

Which version of Word? What's the data source type? Under

exactly what circumstances (after

performing which commands) do you get this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any

follow question or reply in the