[AccessD] SQL statement problem

So, if  Left(strErrDescription, 255) might have an apostrophe in it then
using Chr(34) before and after the Left(strErrDescription, 255) should work
whether there is an apostrophe or not.

lngErrNumber & ", " & chr(34) & Left(strErrDescription, 255) & chr(34) & ",
#"


John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

Home: 253.588.2139
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498

"Commit to the Lord whatever you do,
                and your plans will succeed." Proverbs 16:3



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nancy Lytle
Sent: Thursday, May 08, 2003 11:02 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] SQL statement problem


Thank you for your reply but it still doesn't want to work

Using your code this is the insert statement produced:

insert into tblUserLog([ErrNumber], [ErrDescription], [ErrDate], [UserName],
[ShowUser], [CallingProc]) values ('2102' ,'The form name 'This Form' is
misspelled or refers to a form that doesn't exist.' ,'5/8/2003 1:55:33 PM',
'nlytle', 'True', 'Form_Open()')

THe message I get is Syntax error (missing operator) in query expression:

 "The form name 'This Form' is misspelled or refers to a form that doesn't
exist.' ,'5/8/2003 1:55:33 PM', 'nlytle', 'True', 'Form_Open()')'.

It may have to do with the single quotes inside the ErrDescription, notice
the double quotes at the beggining and single quote ending Any ideas?

Nancy L


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Ruff
Sent: Thursday, May 08, 2003 1:35 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] SQL statement problem


strSQLInsert = "insert into tblUserLog([ErrNumber], [ErrDescription],
[ErrDate], [UserName], [ShowUser], [CallingProc]) values "

Error in this second line, the lngErrNumber is a number so remove the
apostrophe before and after lngErrNumber.  Now() is a date so place a #
before and after Now().  The SQL statement should be; strSQLInsert =
strSQLInsert & "(" & lngErrNumber & ",'" & Left(strErrDescription, 255) &
"',#" & Now() & "#', '" & fcnOSUserName & "', '" & vShowUser & "', '" &
strCallingProc & "')"



John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

Home: 253.588.2139
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498

"Commit to the Lord whatever you do,
                and your plans will succeed." Proverbs 16:3



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nancy Lytle
Sent: Thursday, May 08, 2003 10:31 AM
To: Accessd
Subject: [AccessD] SQL statement problem


Can anyone see what is wrong with this statement?
I have a feeling it has to do with quote marks but I have been pulling my
hair out trying to get it,  I guess I just can't see the forrest for the
trees.

strSQLInsert = "insert into tblUserLog([ErrNumber], [ErrDescription],
[ErrDate], [UserName], [ShowUser], [CallingProc]) values " strSQLInsert =
strSQLInsert & "('" & lngErrNumber & "' ,'" & Left(strErrDescription, 255) &
"' ,'" & Now() & "', '" & fcnOSUserName & "', '" & vShowUser & "', '" &
strCallingProc & "')"

This is how it reads when I try and do the insert:
insert into tblUserLog([ErrNumber], [ErrDescription], [ErrDate], [UserName],
[ShowUser], [CallingProc]) values ('2102' ,'The form name 'This Form' is
misspelled or refers to a form that doesn't exist.' ,'5/8/2003 1:28:00 PM',
'nlytle', 'True', 'Form_Open()')

Thanks,
Nancy L

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com