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

Possible Direct DB Access

Hai To all,

I have created one addon using UDO. Our company need to get ISV Certification for that addon. So we test that using .Net Profiler while testing that i got the error

"Possible Direct DB Access"

how to solve it. In my previous post i ask the same but i didt get the solution..

If anyone have idea help us.....

Regards,

Anitha

Edited by: Rui Pereira on Dec 23, 2008 3:05 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 08, 2008 at 05:18 PM

    Anitha,

    Typically this might mean that you are using an SQL Stored Procedure, trigger, etc. and directly accessing the SAP Business One Db. This is not allowed per the SAP Certification Standards & Guidelines. Are you using any methods such as above tin your ass-on?

    Eddy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for ur reply Edward,

      I am not using any stored procedures or triggers in my code but i think iam directly using Db.The following is my snippet code....

      Sub Access_control()

      Try

      Dim Rec1, rec2, rec3, rec As SAPbobsCOM.Recordset

      Rec1 = com.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

      rec2 = com.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

      rec3 = com.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

      rec = com.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

      PI_Frm = app.Forms.Item("PI")

      Rec1.DoQuery("SELECT count(*) from [@ACFF_HEAD]a,[@ACFF_DETAIL]b where a.DocEntry=b.DocEntry and b.U_fname='apdep' and a.U_uname='" & com.UserSignature & "' and b.U_sname='PI_UDO' ")

      rec.DoQuery("select count(*) from OUSR where superuser='Y' and Userid='" & com.UserSignature & "'")

      If Rec1.Fields.Item(0).Value > 0 Or rec.Fields.Item(0).Value > 0 Then

      PI_Frm.Items.Item("c_abdept").Enabled = True

      Else

      PI_Frm.Items.Item("c_abdept").Enabled = False

      End If

      rec2.DoQuery("SELECT count(*) from [@ACFF_HEAD]a,[@ACFF_DETAIL]b where a.DocEntry=b.DocEntry and b.U_fname='appro' and a.U_uname='" & com.UserSignature & "' and b.U_sname='PI_UDO' ")

      If rec2.Fields.Item(0).Value > 0 Or rec.Fields.Item(0).Value > 0 Then

      PI_Frm.Items.Item("c_abp").Enabled = True

      Else

      PI_Frm.Items.Item("c_abp").Enabled = False

      End If

      rec3.DoQuery("SELECT count(*) from [@ACFF_HEAD]a,[@ACFF_DETAIL]b where a.DocEntry=b.DocEntry and b.U_fname='dir' and a.U_uname='" & com.UserSignature & "' and b.U_sname='PI_UDO' ")

      If rec3.Fields.Item(0).Value > 0 Or rec.Fields.Item(0).Value > 0 Then

      PI_Frm.Items.Item("c_dir").Enabled = True

      Else

      PI_Frm.Items.Item("c_dir").Enabled = False

      End If

      Catch ex As Exception

      End Try

      End Sub

      In this code iam using DoQuery....where all iam using this i got the error.

      Can u suggest me rather than this how to change my code based on SAP certification???

      Thanks Regards,

      Anitha

      Edited by: Rui Pereira on Dec 23, 2008 2:55 PM

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.