RE: Error Message

Hi Dave,

>
>>Insert your comment:
>>The above error is generated by clicking the 'view' toolbar button on a table of mine called user. I can >>get the same error using the SQL winodow...
>>In the SQL window:
>>select * from user
>>gives the error, but
>>select * from "user"
>>works okay.

>Hi,
>The problem is that user is a reserved word because it is part of the SQL syntax. It's usually best to >avoid reserved words for object names, though I appreciate that's not always easy, or what you want.
>Frank: It seems to me that the best solution might be to maintain a list of reserved words and add a >check in fmtID to make sure the word is not in the list. What do you think?
>Regards, Dave

In fmtID why do not escape always ?

------------------
e.g:
Public Function fmtID(ByVal szData As String) As String
On Error Resume Next

'Replace double quotes
szData = Replace(szData, QUOTE, QUOTE & QUOTE)
szData = QUOTE & szData & QUOTE
fmtID = szData

End Function
------------------

What do you think?

Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-----ooo---

--
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Bisogno di un elettricista? Trovalo su QxService e potrai trovare anche il nuovo Nec e606! UMTS Fai la tua richiesta e partecipa al concorso! Clicca qui!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1414&d=28-5