SQL search argument that contains blank value causes error

[Lloyd Blankfein]

Hi,

I send this SQL statement to a ms-access database:

Please Login or Register  to view this content.

This causes an error: Run-time error '-2147217900(80040e14)': Automation error


Strategies(i, 1) looks like this "abc xyz"

I know that the statement is interpreted like this: SELECT Keyword from Setup where ID=abc xyz order by Keyword

What is necessary to tell acces that abc xyz is one word?

Thank you very much!
Lloyd

[Kyle123]

Please Login or Register  to view this content.

It's generally not good practice to have variable length strings as primary keys though

[mike7952]

Normally ID is used as a Unique ID autonumber. If you have a field that is ID and is a text field you need to add a single quotes before and after Strategies(i, 1)

try this

Please Login or Register  to view this content.

[Lloyd Blankfein]

Hi Kyle,

thanks for the fast reply. Yes you are right, I have done the according changes in the database design.

Lloyd