Ms Flex grid query not working

[snipered]

I am sure i posted this before, but i cannot see it, so i guess not.

Every time i try to create a query and show it on the ms flex grid i getting an error saying, ms flex grid does not support this type of bound operation.

I am using a simple sql query-Now, i am not very good at sql in vb, its wierd compared to on Oracle.

strsql = "Select * from Invoice where Name = john smith;"

i initially put speach marks around john smith but it would'nt let me do that.

Any body know where i am going wrong?

[erickwidya]

try this

strsql = "Select * from Invoice where [Name] = 'john smith';"

u need to use single quote to search for string criteria and put [] bracket for preserve words..
i think name isn't preserve words..but give it a try

EDIT : RESERVED word not PRESERVED word. sorry

[snipered]

Cheers, i was thinking of trying the ' ' section. I can't try it till i get home, but thanks for confiriming it.

A question though, what do you mean by preserve?

[erickwidya]

i described preserve word as word that already been 'declared' in it (VB, Access, etc)

but maybe i'm wrong..:P

[snipered]

Oh right, looks like a trial and error situation. If i get an error will try it with [ ], if that don't work i'll asume it's something else.

[erickwidya]

in other words something like that

[dglienna]

I think that he means RESERVED word. A word that can't be used, like SELECT, or FROM.

[RobDog888]

Originally posted by snipered
Oh right, looks like a trial and error situation. If i get an error will try it with [ ], if that don't work i'll asume it's something else.

Also, the brackets are to be used when you have a table name or field name in your query that has a space in it.

Ex.

SELECT [First Name] FROM [Employee Names];