Solved

Table column name conflicts with keyword "date"...

Posted on 2004-08-30
5
361 Views
Last Modified: 2012-06-27
Hi!
    I am using CTLib to connect the Sybase IQ database. There is a table named "Table1" and one column named "date".

The following is the SQL:
   select "date" from "Table1"

This statement works in the interactive SQL environment but FAIL in CTLib API.


Could somebody help? thanks.
0
Comment
Question by:small_potato
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 6

Expert Comment

by:ChrisKing
ID: 11939934
What CT-Lib command are you using to execute this ?
0
 

Author Comment

by:small_potato
ID: 11940334
The sequence is:
ct_command()
ct_send()
ct_result()

The return result is FAIL.
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 11941027
I have no issue embedding quotes, are you using CS_LANG_CMD and CS_NULLTERM ?
eg. ct_command(..., CS_LANG_CMD, (CS_VOID *) QueryString, CS_NULLTERM, CS_UNUSED)

can you provide the actual line of c code where you set / pass you query string
0
 
LVL 19

Accepted Solution

by:
grant300 earned 250 total points
ID: 11947741
Try using the command:
    set quoted identifiers on

If that doesn't work, try setting them off.

I believe there is a different default setting for the connection depending on whether you are using jConnect 5.5 or isql/ct_lib directly.  You can try setting them on and off in ISQL as well and see what happens.

Bill
0
 

Author Comment

by:small_potato
ID: 11970594
Thank you very much!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Original post  on Monitis Blog. Web performance monitoring is broken into two camps: passive and active. Passive monitoring is defined as looking at real-world historical performance by monitoring actual log-ins, site hits, clicks, requests for…
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question