gdunn59
asked on
How to Comment Out Lines of Code in a Pass Through Query In MS Access 2016
I'm working with a MS Access database that was developed by someone else.
I've converted this database to work in the Windows 10 environment with MS Access 2016. Since converting the database to MS Access 2016, the comments that are in the pass through queries are causing issues.
The comments are commented out as follows:
/* comments */
Is there a way to comment out lines in a Pass Through Query in MS Access 2016 (the above way doesn't work in this version of Access)?
Thanks,
gdunn59
I've converted this database to work in the Windows 10 environment with MS Access 2016. Since converting the database to MS Access 2016, the comments that are in the pass through queries are causing issues.
The comments are commented out as follows:
/* comments */
Is there a way to comment out lines in a Pass Through Query in MS Access 2016 (the above way doesn't work in this version of Access)?
Thanks,
gdunn59
What kind of database are you passing-through to?
I wonder if something else is at play. The following works fine for me, using Access 2016 against SQL server 2012
/*This is a comment */
Select top 1 * from UserRoles.tblUser
/*This is a comment */
Perhaps you haven't updated the connection string? Or installed the right driver?
ASKER
Anders Ebro,
Yes I've updated the connection string, and if I remove the comments it runs fine.
Thanks,
gdunn59
Yes I've updated the connection string, and if I remove the comments it runs fine.
Thanks,
gdunn59
have you tried the "--" comment prefix?
What is your backend?
could you try the following SQL and see if it runs:
could you try the following SQL and see if it runs:
/*This is a comment */
Select @@SPID
/*This is a comment */
Just as a way of testing whether it might be related to your SQL in combination with the comment, rather than something else
ASKER
Also, it's not SQL Server it's Oracle.
Here's the pass through query:
Thanks,
gdunn59
Here's the pass through query:
/* ******************* TODO: CHECK FOR DUPLICATES *********** */
SELECT DISTINCT
EDMADMIN.CD_WELL.COMPLETION_WELL_ID,
EDMADMIN.CD_WELL.WELL_ID,
EDMADMIN.CD_WELL.CONDUCTOR_INSTALL_DATE,
EDMADMIN.CD_WELL.FIELD_NAME,
EDMADMIN.CD_DATUM.DATUM_ELEVATION
FROM
EDMADMIN.CD_WELL,
EDMADMIN.CD_DATUM
WHERE
EDMADMIN.CD_WELL.WELL_ID = EDMADMIN.CD_DATUM.WELL_ID(+) AND
EDMADMIN.CD_WELL.COMPLETION_WELL_ID IN (<WINS_NO>) AND
UPPER( EDMADMIN.CD_DATUM.IS_DEFAULT) = 'Y'
/* UPPER( EDMADMIN.CD_DATUM.DATUM_NAME) = 'RKB' /* removed 4/8/15 */
Thanks,
gdunn59
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Anders Ebro,
No, what you posted didn't run. I get the following error (see attached document).
Thanks,
gdunn59
C--Users-msc551-Desktop-Doc1.docx
No, what you posted didn't run. I get the following error (see attached document).
Thanks,
gdunn59
C--Users-msc551-Desktop-Doc1.docx
What I posted worked for SQL server. I must admit I have no experience with Oracle. But in SQL Server a unfinished comment is not allowed, so try to fix that (per my previous post) and see if that helps.
ASKER
Anders Ebro,
I tried your last posting ID: 41987946 and I still get the error that is contained in the document I uploaded in my last posting.
Thoughts??
Thanks,
gdunn59
I tried your last posting ID: 41987946 and I still get the error that is contained in the document I uploaded in my last posting.
Thoughts??
Thanks,
gdunn59
Thoughts? Yes ... probably need to post in the Oracle section as well.
ASKER
DatabaseMX (Joe Anderson - Access MVP),
Ok. Thanks!
Ok. Thanks!
ASKER
DatabaseMX (Joe Anderson - Access MVP),
It looks like it was posted to Oracle as well.
Thanks,
gdunn59
It looks like it was posted to Oracle as well.
Thanks,
gdunn59
>> But in SQL Server a unfinished comment is not allowed,
Also not in Oracle but technically it is finished: There is only one close. Oracle should ignore "extra" opens. It sees a comment start, it continues until it sees a comment end.
Now back to the error: No idea really.
The error text is real informative: http://psoug.org/oraerror/ORA-24374.htm
Even though it is an Oracle error message, I'm not sure it is coming from the database. It might be coming from the Oracle client.
Are you also using upgraded Oracle drivers? Are those drivers compatible with the version of Oracle database you are connecting to?
Also not in Oracle but technically it is finished: There is only one close. Oracle should ignore "extra" opens. It sees a comment start, it continues until it sees a comment end.
Now back to the error: No idea really.
The error text is real informative: http://psoug.org/oraerror/ORA-24374.htm
Even though it is an Oracle error message, I'm not sure it is coming from the database. It might be coming from the Oracle client.
Are you also using upgraded Oracle drivers? Are those drivers compatible with the version of Oracle database you are connecting to?
ASKER
slightwv,
I'm not sure about the drivers. I'll have to reach out to the IT guys.
Thanks,
gdunn59
I'm not sure about the drivers. I'll have to reach out to the IT guys.
Thanks,
gdunn59
If you copy the SQL and paste it into whatever substitutes for for the new query window in SSMS in Oracle, does the query work?
ASKER
Sorry for the delay.
Pat, I don't have access to SSMS in Oracle.
Thanks,
gdunn59
Pat, I don't have access to SSMS in Oracle.
Thanks,
gdunn59
I know that --
whatever substitutes for for the new query window in SSMS
ASKER
Pat,
Ok. I'll have to try that when I get a minute.
Thanks,
gdunn59
Ok. I'll have to try that when I get a minute.
Thanks,
gdunn59