Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: create field name function

    Hi,
    When I try to run the below statement in sysbase 12.5 :

    create table test (
    function smallint not null)
    go

    it give error of incorrect syntax.

    This name was created in our office previous sybase version (which I don't remember because it past my time) and it works. Can someone tell me why its not working in this version 12.5 and how to solve it without using another name. I need the name for upgrading database.

    Thanks for the help in advance.

  2. #2
    Join Date
    Mar 2004
    Location
    Hyderabad, India
    Posts
    8

    Re: create field name function

    Hi

    I have tried out ur table creation in ase 12.0, it got created

    In sybase 12.5 the work "function" is a keyword

    So that may be that is the reason why u cant create a table with that column name

    any more quries u can mail me at kapila.sridhar@email.com

    bye

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    ... but in version 12.5.1, the Function keyword was removed from the reserved words, due tu customer's pressure.

    A problem could come later using RS and function strings...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •