Solved

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

Posted on 2004-08-30
5
347 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
  • 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dynamically Growing Sybase Database 3 444
compare Sybase and MSSQL server 18 802
the error when installation Sybase ASE 15.7 x64 bon Windows 37 2,869
SSIS - Update a Sybase Table 33 163
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

822 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