Ms Flex grid query not working

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.

VB Code:

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?

try this

VB Code:

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 :)

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?

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

but maybe i'm wrong..:P

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.

in other words something like that :D

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

Quote:

---

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.

Code:

---

SELECT [First Name] FROM [Employee Names];

---