| Author |
 Topic Search  Topic Options
|
Boecky 
Groupie
Joined: 23 December 2002
Location: Belgium
Status: Offline
Points: 110
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Language in access
Posted: 11 December 2003 at 1:35am |
Hi
I have a weird experience with following sql command:
strCmd = "SELECT * FROM tblSomething WHERE Lang = 'nl' ORDER BY Something_ID DESC"
Previous command will work, but if I change Lang to Language, it won't work anymore
strCmd = "SELECT * FROM tblSomething WHERE Language = 'nl' ORDER BY Something_ID DESC"
Off course I change this in my db too
Does anyone know why this is, and how I can solve it? Coz I really wanna use the word Language
|
 |
Leeb65
Groupie
Joined: 05 December 2003
Location: Germany
Status: Offline
Points: 62
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2003 at 2:16am |
strCmd = "SELECT * FROM tblSomething WHERE [Language] = 'nl' ORDER BY Something_ID DESC"
Try that
Lee
|
|
Boecky
Groupie
Joined: 23 December 2002
Location: Belgium
Status: Offline
Points: 110
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2003 at 2:26am |
|
thanks, that works!
Is 'language' a reserved word or something?
|
|
Leeb65
Groupie
Joined: 05 December 2003
Location: Germany
Status: Offline
Points: 62
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2003 at 2:33am |
Ja, it's a VS reserved word, at least as far as I know.
You can set a documents language using it. Both Lang and Language are used.
Edited by Leeb65
|
|
MorningZ
Senior Member
Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2003 at 5:31am |
MSDN's list of reserved words
access absolutely sucks in that it is waaaay too picky with column names.. SQL Server is much much much more forgiving.. and if you are used to SQL Server, just wrapping all the Access columns in [ ]'s solves 100% of those problems
|
|
Contribute to the working anarchy we fondly call the Internet
|
|
Leeb65
Groupie
Joined: 05 December 2003
Location: Germany
Status: Offline
Points: 62
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2003 at 5:35am |
|
Good tip MorningZ, although I only ever use SQL Server now.
|
|
Diep-Vriezer
Senior Member
Joined: 06 August 2003
Location: Netherlands
Status: Offline
Points: 831
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2003 at 10:08am |
Have you tried XML?  I'm in luv with XML now.
BTW, I also use SQL, since the loads of probs I had with Acces.
|
|
Gone..
|
|
MorningZ
Senior Member
Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 December 2003 at 10:51am |
i wouldnt fall too in love with XML.. its usefull in a few situations, but the lack of relationships and lack of a true query language is a MAJOR shortcoming
as for Access vs SQL.. Access works fine for any site with low traffic as long as its coded properly (mainly properly closing/disposing of threads to the database).. it is enough to get the job done
|
|
Contribute to the working anarchy we fondly call the Internet
|
|
