Skip to Content
author's profile photo Former Member
Former Member

Objects name case sensitive

Hi Dear;

to call any object in SDK, i have to write the object name(index) as case sensitive.

if there any way to call these objects without case sensitive?

Ex: if i have a UDF named U_BPDrv and i try to get it as U_BPDRV i get an error.

how can i resolve this error?

thank you Dear;

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 06:42 AM

    Hi Dany,

    the case sensitivity does`nt belong to sap, but to sql server. You have to change the option for this on sql server - I expect that you have on sql server binary collation.

    Petr

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:02 PM

    Hi Dany,

    Unfortunately the case sensitivity is an SDK issue - it is definitely not an SQL Server problem, so you will have to follow the UDF's case sensitive naming convention when you use them, there is no way around this issue.

    Regards, Lita

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Lita,

      i tried it now. UDF field is named as u_Test.

      When I call SELECT ordr.u_Test so the result is the same as when I call SELECT ordr.U_TESt, so here is it not case sensitive. When I try get result from recordset as rs_ordr.Fields.Item("U_TeSt").Value() it give no error. When I bound result from recordset to matrix as

      column.DataBind.SetBound(True, "@KZ", "u_TEst") - no error as well.

      Everything was tested with no binary collation on db.

      So I`m persuaded, that in this cases it depends on sql server and not on SDK.

      Petr

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 06:45 AM

    i'll try

    thank you

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.