help on jet 3.1 convrting to jet 4.0

[ragu g]

I am using jet engine 3.1 and converting to jet 4.0
an sql query is not funtioning gives error.

the query is select name,name+space(2) as name1 from table

I need help how to connect to jet 4.0 and to run the query successfully.

Thanks for ur reply

regards
ragu

 

[Cor Ligthert]

Ragu,

Maybe this page helps you,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_1l4j.asp

I hope this help?

Cor

 

[Paul Clement]

¤ I am using jet engine 3.1 and converting to jet 4.0
¤ an sql query is not funtioning gives error.
¤
¤ the query is select name,name+space(2) as name1 from table
¤
¤ I need help how to connect to jet 4.0 and to run the query successfully.
¤

The keyword "name" is a Jet reserved word and must be enclosed within brackets:

select [name], [name] & space(2) as name1 from tablename


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)