Jim Lawrence (AccessD)
accessd at shaw.ca
Thu May 8 19:19:47 CDT 2003
Hi Nancy:
You might have to check the fields you are getting the data from and the
ones you are putting the data into. Check to see if the fields you are
inserting the data into match the data type you are putting into them. A
common mistake is to try and put string data into a numeric field. All data
with "'" marks around are assumed to be character fields and date string
fields. Other fields do not require quotation marks. Remember also dates can
be stored as date strings or as numeric data. Check the source and
destination carefully.
HTH
Jim
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Nancy Lytle
Sent: Thursday, May 08, 2003 12:38 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] SQL statement problem
John's version gave me:
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 3:10:56 PM',
'nlytle', 'True', 'Form_Open()')
And Andy's gave me:
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 3:12:39 PM',
'nlytle', 'True', 'Form_Open()')
Both of which seem identical to what I got. I think I am going crazy! It
has to be something terribly simple, but I just can't get it.
By the way I am using A2000 on Win2000.
I have used this same technique many times in the past, but this time it
just won't work.
It has to be the single quotes inside the Err_Description.
Nancy L.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Thursday, May 08, 2003 2:12 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] SQL statement problem
Nancy
How about
strSQLInsert = "insert into tblUserLog([ErrNumber], [ErrDescription],
[ErrDate], [UserName], [ShowUser], [CallingProc]) values "
strSQLInsert = strSQLInsert & "(" & lngErrNumber & ", '" &
Left(strErrDescription, 255) & "' ,Now(), '" & fcnOSUserName & "', '" &
vShowUser & "', '" & strCallingProc & "')"
How does that do?
Andy Lacey
http://www.minstersystems.co.uk
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nancy Lytle
> Sent: 08 May 2003 19:02
> 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/a> ccessd
> Website:
> http://www.databaseadvisors.com
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website:
> http://www.databaseadvisors.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> 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