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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
