Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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

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
small_potato
Asked:
small_potato
  • 2
  • 2
1 Solution
 
ChrisKingCommented:
What CT-Lib command are you using to execute this ?
0
 
small_potatoAuthor Commented:
The sequence is:
ct_command()
ct_send()
ct_result()

The return result is FAIL.
0
 
ChrisKingCommented:
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
 
grant300Commented:
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
 
small_potatoAuthor Commented:
Thank you very much!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now