• RELEVANCY SCORE 3.45

    DB:3.45:Length Of Uniqueid For Matrix Column 39





    I suggest increasing the permissible length of the Unique ID used for matrix columns from 10 to 12 for user defined columns, so as to permit the database column name to be used as the Unique id. System created columns can have names this long but not user defined ones. The ability to use the field name as the Unique ID is extremely useful when writing generic code to populate/process matrixes and this is not possible unless you restrict your UDF field names to 10 characters (including the U_), once you allow for a 3 character partner code (so as to play nice in the sandbox) that doesn't leave a lot of scope for meaningful fieldnames.

    DB:3.45:Length Of Uniqueid For Matrix Column 39


    I suggest increasing the permissible length of the Unique ID used for matrix columns from 10 to 12 for user defined columns, so as to permit the database column name to be used as the Unique id. System created columns can have names this long but not user defined ones. The ability to use the field name as the Unique ID is extremely useful when writing generic code to populate/process matrixes and this is not possible unless you restrict your UDF field names to 10 characters (including the U_), once you allow for a 3 character partner code (so as to play nice in the sandbox) that doesn't leave a lot of scope for meaningful fieldnames.

  • RELEVANCY SCORE 3.27

    DB:3.27:Screen Painter Matrix Control Column Uniqueid pa





    Dear All

    I have been facing issue while designing a form in screen painter for my add-on. when i open any xml in screen painter all controls are working fine but matrix column unique id is not visible. when same xml file open in older version of screen painter[sap b1 v9 pl 4] it shows it unique id in matrix column.

    also i was unable to use b1 client menus like file edit and so on....

    i am using sap b1 v9 pl11.

    DB:3.27:Screen Painter Matrix Control Column Uniqueid pa


    Dear All

    I have been facing issue while designing a form in screen painter for my add-on. when i open any xml in screen painter all controls are working fine but matrix column unique id is not visible. when same xml file open in older version of screen painter[sap b1 v9 pl 4] it shows it unique id in matrix column.

    also i was unable to use b1 client menus like file edit and so on....

    i am using sap b1 v9 pl11.

  • RELEVANCY SCORE 3.18

    DB:3.18:Fill Matrix From Datasource kd





    i have multiple dataset for filling different column of Matrix

    how can i "translate" multiple dataset to user data source and then filling into the matrix?

    DB:3.18:Fill Matrix From Datasource kd


    First of all, if you have any option to use a grid instead of a matrix, please do so.. quicker

    if not

    Steps:

    - Add matrix with columns bound to userdatasources

    - Add rows: oMatrix.AddRow()

    - Call oMatrix.GetLineData(1..number of records) [To focus to correct userdatasource]

    - Set value in userdatasource

    - Call oMatrix.SetLineData(1... number of records) [To copy data from userdatasource to the matrix]

  • RELEVANCY SCORE 3.15

    DB:3.15:Add The Elements Of A Single Row/Column Of A Matrix dm



    Hello everyone,

    what's the easiest way to add all the elements of a single row or column of a matrix given the matrix and the number of that row/column on LabVIEW ? The output should be a number for each row or column.







    Solved!
    Go to Solution.

    DB:3.15:Add The Elements Of A Single Row/Column Of A Matrix dm


    Oh, I didn't know this feature mattered. As you can see, I'm new to labview, ANDto this community. But i like it, and i'll do as you said.

  • RELEVANCY SCORE 3.11

    DB:3.11:Please Help Me W/ This Problem... ps


    public class Main {
    public static void main(String[] args) {
    int[][] matrix = new int[4][3];
    int row, col, value = 1;
    final int NUM_ROWS = matrix.length;
    final int NUM_COLS = matrix[0].length;

    for (row = 0; row NUM_ROWS; row++) {
    for (col = 0; col NUM_COLS; col++) {
    matrix[row][col] = value;
    value++;
    }
    }

    for (row = 0; row NUM_ROWS; row++) {
    for (col = 0; col NUM_COLS; col++) {
    System.out.print(matrix[row][col] + "\t");
    }
    System.out.println();
    }

    }

    }

    I need help with my code that will find the sum of the 3 rows which equal 6, 15, 24, 33 then add the columns that equal 22, 26 , 30.
    here is my code so far:

    DB:3.11:Please Help Me W/ This Problem... ps

    Hi,

    thanks for usig the code-formatting. As for your question, please see my previous post.

    Bye.

  • RELEVANCY SCORE 3.01

    DB:3.01:How To Find The Position Of Element Of A Matrix 9m



    Hi,

    I have a question to ask you.

    I have a matrix N x M which contains a large number of zero. I wish to find the position of the element not equal to zero and to classify them in a table of two columns: line of the matrix and the column of the matrix. I do not need the value of the element.

    Do you know how I have to proceed?

    Thanks for help

    DB:3.01:How To Find The Position Of Element Of A Matrix 9m


    If you are using LabVIEW 2012, it can be a bit more easier. I have used round to nearest integer as there are caveats in comparing floating point numbers.

    Here:




    Beginner? Try LabVIEW Basics Sharing bits of code? Try Snippets or LAVA Code Capture Tool Have you tried Quick Drop?, Visit QD Community.

  • RELEVANCY SCORE 3.01

    DB:3.01:Matrix - Help With Setting 1st Column For Line Numbers 3f



    Hi,

    I have created a matrix on a custom form and would like to add line numbers to the # column line that of the quotation screen.

    The matrix itself is populated correct from the Query and LoadFromDataSource, and all the fields and columns are filled in correctly, the only column I am having trouble with is the 1st one for line numbers. My code for adding the line numbers is

    SBO_Application.MessageBox("Matrix Count: " tMatrix.RowCount)
    For i = 1 To tMatrix.RowCount
    oEditText = tColumns.Item("#").Cells.Item(i).Specific
    oEditText.Value = i
    Next

    DB:3.01:Matrix - Help With Setting 1st Column For Line Numbers 3f


    Try This....

    for(int i=1;i=oMatrix.Count;i++)
    {
    oEdit = (SAPbouiCOM.EditText)oMatrix.Columns.Item("V_-1").Cells.Item(i).Specific;
    oEdit.Value=i.ToString();
    }

  • RELEVANCY SCORE 2.96

    DB:2.96:Interactive Sorting In Matrix Layout df


    Hi friends,
    I need help with sorting a matrix. I have a matrix with a row group of City and a column group of Products, the data inside the matrix is the amount of Sales. Products are coming dynamically through column group are I want the matrix rows to be sorted by
    the decending value or ascending values.
    For example, if the report displays Product1, Product2, Product3... amount of sales results by Product.
    Can we apply interactive sorting on dynamic column group?

    Thanks in advance.

    DB:2.96:Interactive Sorting In Matrix Layout df

    Hi There
    Please follow these steps

    go to your product header text box and right click and go to interactive sortingClick on enable interactive sortingSelect the groups radio buttonAnd select the group of your productIn Sort by use your product name
    I am putting some screenshot for your help.
    If you still have a questions please let me know.
    Many thanks
    Syed Qazafi Anjum
    Please click Mark as Answer if this resolves your problem or Vote as Helpful if you find it helpful.

  • RELEVANCY SCORE 2.92

    DB:2.92:Technique To Control An Automatically Expanding Matrix Column Group 11


    Hello guys I have a .rdlc with a matrix control. the matrix has its column header cell grouped. At runtime the data detail field expands horizontally on one line causing the report width to increase, which is expected. but how do i control the length to  which it expands i.e specify the number of columns that expand on a line and cause it to continue on the next line so that i can preserve the original length of my report. illustration:     data1      data2      data3      data4       data5 ...................             datan (not appropriate) would want the matrix to expand as        data1         data2        data3                                                            data4        data5         .......                                                            datan

    DB:2.92:Technique To Control An Automatically Expanding Matrix Column Group 11

    Hello guys I have a .rdlc with a matrix control. the matrix has its column header cell grouped. At runtime the data detail field expands horizontally on one line causing the report width to increase, which is expected. but how do i control the length to  which it expands i.e specify the number of columns that expand on a line and cause it to continue on the next line so that i can preserve the original length of my report. illustration:     data1      data2      data3      data4       data5 ...................             datan (not appropriate) would want the matrix to expand as        data1         data2        data3                                                            data4        data5         .......                                                            datan

  • RELEVANCY SCORE 2.89

    DB:2.89:Vector[1xn] * Matrix[Nxm] How Would You Set It Up ? - Nvidia Developer Forums 8a


    Hi All,

    I need to multiply a huge vector V (say, it contains 150 000 000 floats) on matrix M, but the matrix is not a real matrix but a hardcoded formula F(row, column), so the actual value of F must be recalculated for each row and column. As the vector is really huge, formula becomes almost the only way of suitable matrix representation (150Mx150M matrix is something beyond the imagination).

    Thanks in advance for any thoughts.

    DB:2.89:Vector[1xn] * Matrix[Nxm] How Would You Set It Up ? - Nvidia Developer Forums 8a

    [quote name=&9;seibert&9; date=&9;Oct 13 2008, 07:49 PM&9;]Oh wait, I&9;m being stupid about the memory thing. outV doesn&9;t need to have all the elements, actually. You can just stuff however many you can fit given your memory constraints, and then copy them out and start filling the outV array at the beginning again.

    Similarly, using the reduction in shared memory trick to reduce the size of tempV, you can probably make this entire task fit onto one GTX 280.
    [snapback]451459[/snapback]

    Yeah, this fits into a single GTX280. OK, thanks for the advice&3;

  • RELEVANCY SCORE 2.85

    DB:2.85:Help With Instantiating New Objects c7


    Hello, thank you for taking time to help me solve this problem.

    I have to write a program that creates a new "Matrix" class and fills it with the desired fill number. I have created code that works to a degree, but it bugged. It seems that If I try to create a new instance of the Matrix class and call upon an older instance, it uses the new instance instead.

    Here is the code:
    public class Matrix
    {

    private static double[][] MatrixX;
    private static int rows=10;
    private static int columns =10;

    public Matrix()
    {
    this(10,10);
    }

    public Matrix(int width,int length)
    {
    this(width,length,0);

    }

    public Matrix(int width,int length, double fill)
    {
    rows = width;
    columns = length;
    MatrixX = new double[rows][columns];
    for(int count = 0; countrows; count++)
    {
    for(int count2=0; count2columns; count2++)
    {
    MatrixX[count][count2] = fill;
    }
    }

    }

    public boolean hasNextRow(int count)
    {
    intcount2 = count;

    if(count2=rows)
    {
    return true;
    }
    else
    {
    return false;
    }
    }

    public boolean hasNextCol(int count)
    {
    intcount2 = count;

    if(count2=columns)
    {
    return true;
    }
    else
    {
    return false;
    }
    }

    public int getNumberRows()
    {
    return rows;
    }

    public int getNumberCols()
    {
    return columns;
    }

    public double get(int r, int c)
    {
    return MatrixX[r][c];
    }

    public String toString()
    {
    for(int count = 0; countrows; count++)
    {
    for(int count2=0; count2columns; count2++)
    {
    System.out.print(MatrixX[count][count2] +" ");
    }
    System.out.println("");
    }
    System.out.println("Number of Cols = " + this.getNumberCols());
    System.out.println("Number of Rows = " + this.getNumberRows());
    return "";
    }

    public boolean equals(Matrix v)
    {
    if(this.getNumberRows() == v.getNumberRows()this.getNumberCols() == v.getNumberCols())
    {
    return true;
    }
    else
    {
    return false;
    }

    }

    public Matrix add(Matrix a)
    {
    int rowsInst = a.getNumberRows();
    int colsInst = a.getNumberCols();
    double sum = a.get(0,0)+this.get(1,1);

    if(a.equals(this))
    {
    return new Matrix(rowsInst, colsInst, sum);
    }
    else
    {
    return new Matrix(rowsInst, colsInst, -1);
    }
    }

    public static Matrix identityMatrix(int m)
    {
    Matrix asdf = new Matrix(m,m,0);
    for(int count =0; countasdf.getNumberCols(); count++)
    {
    MatrixX[count][count]= 1;
    }
    return asdf;
    }

    public static void main (String[] args)
    {
    Matrix myMat = new Matrix(4,5,7);
    Matrix myMat1 = new Matrix(4,5,7);
    System.out.println(myMat);
    System.out.println(myMat.add(myMat1));
    System.out.println(identityMatrix(4));

    }
    }

    DB:2.85:Help With Instantiating New Objects c7

    Thank you very much paul.miner, I now understand what I was doing wrong. I'm going to also read the tutorials for static and naming conventions too.

    I greatly apreciate your help :)

  • RELEVANCY SCORE 2.85

    DB:2.85:Problem Field Of Type "Connection" The Matrix cz



    Hi,

    I want to make an attachment function in an Matrix. But to link to my column with a capo in the database of the type "Connection" does not work. And if i do the same for one field it_EDIT out of the matrix, it works.

    I want to make the function of the attachment (annex) pattern SAP in my Matrix.

    DB:2.85:Problem Field Of Type "Connection" The Matrix cz


    Hi,

    Please gothrough below code.

    Case SAPbouiCOM.BoEventTypes.et_CLICK

    Try

    Select Case pVal.ItemUID

    Case "b_browse"

    If pVal.BeforeAction Then If frmProject.Items.Item(pVal.ItemUID).Enabled = False Then BubbleEvent = False

    If pVal.ActionSuccess Then

    If oMatrix2.RowCount 0 Then

    If oMatrix2.Columns.Item("TrgtPath").Cells.Item(1).Specific.value.Equals("") Then

    oMatrix2.Clear()

    oDBDSDetail2.Clear()

    End If

    End If

    If SetAttachMentFile(frmProject, oDBDSHeader, oMatrix2, oDBDSDetail2) = False Then

    BubbleEvent = False

    End If

    End If

    Case "b_display"

    If pVal.BeforeAction Then If frmProject.Items.Item(pVal.ItemUID).Enabled = False Then BubbleEvent = False

    If pVal.ActionSuccess Then

    For i As Integer = 1 To oMatrix2.VisualRowCount

    If oMatrix2.IsRowSelected(i) Then OpenAttachment(oMatrix2, oDBDSDetail2, i)

    Exit For

    Next

    End If

    Case "b_delete"

    If pVal.BeforeAction Then If frmProject.Items.Item(pVal.ItemUID).Enabled = False Then BubbleEvent = False

    If pVal.ActionSuccess Then

    DeleteRowAttachment(frmProject, oMatrix2, oDBDSDetail2, oMatrix2.GetNextSelectedRow(0, SAPbouiCOM.BoOrderType.ot_RowOrder))

    End If

    Case "Attach"

    If pVal.BeforeAction = False And pVal.Row 0 Then

    If oMatrix2.IsRowSelected(pVal.Row) Then

    frmProject.Items.Item("b_display").Enabled = True

    frmProject.Items.Item("b_delete").Enabled = True

    End If

    End If

    End Select

    Catch

    End Try

    'Fuctions

    #Region " Attachment Option "

    Sub AddAttachment(ByVal oMatAttach As SAPbouiCOM.Matrix, ByVal oDBDSAttch As SAPbouiCOM.DBDataSource, ByVal oDBDSHeader As SAPbouiCOM.DBDataSource)

    Try

    If oMatAttach.VisualRowCount 0 Then

    Dim rsetAttCount As SAPbobsCOM.Recordset = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

    Dim oAttachment As SAPbobsCOM.Attachments2 = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oAttachments2)

    Dim oAttchLines As SAPbobsCOM.Attachments2_Lines

    oAttchLines = oAttachment.Lines

    oMatAttach.FlushToDataSource()

    rsetAttCount.DoQuery("Select Count(*) From ATC1 Where AbsEntry = '" Trim(oDBDSHeader.GetValue("U_AtcEntry", 0)) "'")

    If Trim(rsetAttCount.Fields.Item(0).Value).Equals("0") Then

    For i As Integer = 1 To oMatAttach.VisualRowCount

    If i 1 Then oAttchLines.Add()

    oDBDSAttch.Offset = i - 1

    oAttchLines.SourcePath = Trim(oDBDSAttch.GetValue("U_ScrPath", oDBDSAttch.Offset))

    oAttchLines.FileName = Trim(oDBDSAttch.GetValue("U_FileName", oDBDSAttch.Offset))

    oAttchLines.FileExtension = Trim(oDBDSAttch.GetValue("U_FileExt", oDBDSAttch.Offset))

    oAttchLines.Override = SAPbobsCOM.BoYesNoEnum.tYES

    Next

    oAttachment.Add()

    Dim rsetAttch As SAPbobsCOM.Recordset = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

    rsetAttch.DoQuery("Select Case When Count(*) 0 Then Max(AbsEntry) Else 0 End AbsEntry From ATC1")

    oDBDSHeader.SetValue("U_AtcEntry", 0, rsetAttch.Fields.Item(0).Value)

    Else

    oAttachment.GetByKey(Trim(oDBDSHeader.GetValue("U_AtcEntry", 0)))

    For i As Integer = 1 To oMatAttach.VisualRowCount

    If oAttchLines.Count i Then oAttchLines.Add()

    oDBDSAttch.Offset = i - 1

    oAttchLines.SetCurrentLine(i - 1)

    oAttchLines.SourcePath = Trim(oDBDSAttch.GetValue("U_ScrPath", oDBDSAttch.Offset))

    oAttchLines.FileName = Trim(oDBDSAttch.GetValue("U_FileName", oDBDSAttch.Offset))

    oAttchLines.FileExtension = Trim(oDBDSAttch.GetValue("U_FileExt", oDBDSAttch.Offset))

    oAttchLines.Override = SAPbobsCOM.BoYesNoEnum.tYES

    Next

    oAttachment.Update()

    End If

    End If

    'Delete the Attachment Rows...

    Dim rsetDelete As SAPbobsCOM.Recordset = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

    rsetDelete.DoQuery("Delete From ATC1 Where AbsEntry = '" Trim(oDBDSHeader.GetValue("U_AtcEntry", 0)) "' And Line '" oMatAttach.VisualRowCount "' ")

    Catch ex As Exception

    oApplication.StatusBar.SetText("AddAttachment Failed:" ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning)

    Finally

    End Try

    End Sub

    Sub DeleteRowAttachment(ByVal oForm As SAPbouiCOM.Form, ByVal oMatrix As SAPbouiCOM.Matrix, ByVal oDBDSAttch As SAPbouiCOM.DBDataSource, ByVal SelectedRowID As Integer)

    Try

    oDBDSAttch.RemoveRecord(SelectedRowID - 1)

    oMatrix.DeleteRow(SelectedRowID)

    oMatrix.FlushToDataSource()

    For i As Integer = 1 To oMatrix.VisualRowCount

    oMatrix.GetLineData(i)

    oDBDSAttch.Offset = i - 1

    oDBDSAttch.SetValue("LineID", oDBDSAttch.Offset, i)

    oDBDSAttch.SetValue("U_TrgtPath", oDBDSAttch.Offset, Trim(oMatrix.Columns.Item("trgtpath").Cells.Item(i).Specific.Value))

    oDBDSAttch.SetValue("U_ScrPath", oDBDSAttch.Offset, Trim(oMatrix.Columns.Item("scrpath").Cells.Item(i).Specific.Value))

    oDBDSAttch.SetValue("U_FileName", oDBDSAttch.Offset, Trim(oMatrix.Columns.Item("filename").Cells.Item(i).Specific.Value))

    oDBDSAttch.SetValue("U_FileExt", oDBDSAttch.Offset, Trim(oMatrix.Columns.Item("fileext").Cells.Item(i).Specific.Value))

    oDBDSAttch.SetValue("U_Date", oDBDSAttch.Offset, Trim(oMatrix.Columns.Item("date").Cells.Item(i).Specific.Value))

    oMatrix.SetLineData(i)

    oMatrix.FlushToDataSource()

    Next

    'oDBDSAttch.RemoveRecord(oDBDSAttch.Size - 1)

    oMatrix.LoadFromDataSource()

    oForm.Items.Item("b_display").Enabled = False

    oForm.Items.Item("b_delete").Enabled = False

    If oForm.Mode SAPbouiCOM.BoFormMode.fm_ADD_MODE Then oForm.Mode = SAPbouiCOM.BoFormMode.fm_UPDATE_MODE

    Catch ex As Exception

    oApplication.StatusBar.SetText("DeleteRowAttachment Method Failed:" ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning)

    Finally

    End Try

    End Sub

    Function SetAttachMentFile(ByVal oForm As SAPbouiCOM.Form, ByVal oDBDSHeader As SAPbouiCOM.DBDataSource, ByVal oMatrix As SAPbouiCOM.Matrix, ByVal oDBDSAttch As SAPbouiCOM.DBDataSource) As Boolean

    Try

    If oCompany.AttachMentPath.Length = 0 Then

    StatusBarErrorMsg("Attchment folder not defined, or Attchment folder has been changed or removed. [Message 131-102]")

    Return False

    End If

    Dim strFileName As String = FindFile()

    If strFileName.Equals("") = False Then

    Dim FileExist() As String = strFileName.Split("\")

    Dim FileDestPath As String = oCompany.AttachMentPath FileExist(FileExist.Length - 1)

    If File.Exists(FileDestPath) Then

    Dim LngRetVal As Long = oApplication.MessageBox("A file with this name already exists,would you like to replace this? " FileDestPath " will be replaced.", 1, "Yes", "No")

    If LngRetVal 1 Then Return False

    End If

    Dim fileNameExt() As String = FileExist(FileExist.Length - 1).Split(".")

    Dim ScrPath As String = oCompany.AttachMentPath

    ScrPath = ScrPath.Substring(0, ScrPath.Length - 1)

    Dim TrgtPath As String = strFileName.Substring(0, strFileName.LastIndexOf("\"))

    oMatrix.AddRow()

    oMatrix.FlushToDataSource()

    oDBDSAttch.Offset = oDBDSAttch.Size - 1

    oDBDSAttch.SetValue("LineID", oDBDSAttch.Offset, oMatrix.VisualRowCount)

    oDBDSAttch.SetValue("U_TrgtPath", oDBDSAttch.Offset, ScrPath)

    oDBDSAttch.SetValue("U_ScrPath", oDBDSAttch.Offset, TrgtPath)

    oDBDSAttch.SetValue("U_FileName", oDBDSAttch.Offset, fileNameExt(0))

    oDBDSAttch.SetValue("U_FileExt", oDBDSAttch.Offset, fileNameExt(1))

    oDBDSAttch.SetValue("U_Date", oDBDSAttch.Offset, GetServerDate())

    oMatrix.SetLineData(oDBDSAttch.Size)

    oMatrix.FlushToDataSource()

    If oForm.Mode SAPbouiCOM.BoFormMode.fm_ADD_MODE Then oForm.Mode = SAPbouiCOM.BoFormMode.fm_UPDATE_MODE

    End If

    Return True

    Catch ex As Exception

    oApplication.StatusBar.SetText("Set AttachMent File Failed:" ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning)

    Return False

    Finally

    End Try

    End Function

    Sub OpenAttachment(ByVal oMatrix As SAPbouiCOM.Matrix, ByVal oDBDSAttch As SAPbouiCOM.DBDataSource, ByVal PvalRow As Integer)

    Try

    If PvalRow = oMatrix.VisualRowCount And PvalRow 0 Then

    Dim RowIndex As Integer = oMatrix.GetNextSelectedRow(0, SAPbouiCOM.BoOrderType.ot_RowOrder) - 1

    Dim strServerPath, strClientPath As String

    strServerPath = Trim(oDBDSAttch.GetValue("U_TrgtPath", RowIndex)) + "\" + Trim(oDBDSAttch.GetValue("U_FileName", RowIndex)) + "." + Trim(oDBDSAttch.GetValue("U_FileExt", RowIndex))

    strClientPath = Trim(oDBDSAttch.GetValue("U_ScrPath", RowIndex)) + "\" + Trim(oDBDSAttch.GetValue("U_FileName", RowIndex)) + "." + Trim(oDBDSAttch.GetValue("U_FileExt", RowIndex))

    'Open Attachment File

    OpenFile(strServerPath, strClientPath)

    End If

    Catch ex As Exception

    oApplication.StatusBar.SetText("OpenAttachment Method Failed:" ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Warning)

    Finally

    End Try

    End Sub

    Sub AttchButtonEnable(ByVal oForm As SAPbouiCOM.Form, ByVal Matrix As SAPbouiCOM.Matrix, ByVal PvalRow As Integer)

    Try

    If PvalRow = Matrix.VisualRowCount And PvalRow 0 Then

    Matrix.SelectRow(PvalRow, True, False)

    If Matrix.IsRowSelected(PvalRow) = True Then

    oForm.Items.Item("b_display").Enabled = True

    oForm.Items.Item("b_delete").Enabled = True

    Else

    oForm.Items.Item("b_display").Enabled = False

    oForm.Items.Item("b_delete").Enabled = False

    End If

    End If

    Catch ex As Exception

    StatusBarErrorMsg("Attach Button Enble Function...")

    End Try

    End Sub

    #End Region

  • RELEVANCY SCORE 2.84

    DB:2.84:Function Mkl_Sdnscsr- Urgent 9m



    Hi,

    I have got some basic questions.

    I'm trying to use the functions of Intel Math Kernel Library- for converting a matrix in dense representation into CSR format.

    There are the following possibilities as I see:

    1) The function mkl_sdnscsr which has the following arguments;

    (job, m , n, adns, lda, acsr, ja, ia, info)

    Now:

    from the inputs required;

    acsr = array containing non zero elements of the matrix A. Its length is equal to the number of non zero elements of the matrix A.

    ja = array containing the column indices for each non zero element of the matrix A.

    My question is;

    if in my routine, I do not have theindices of the non zero elements of my matrix available, then , how do I use this function?

    Because, I have a matrix (Say) 'K' which is in dense form,and I have not stored the indices of the non zero elements. How can I use this function in such a case?

    I just havea matrix of form:

    3.14 0 0 20.04 0 0

    0 27 0 0 -0.6 0

    0 0 -0.01 0 0 0

    -0.031 0 0 0.08 0 314

    That is all and I want to convert into CSR format.

    I just want to give this matrix as input and get the CSR format. Is it possible?

    Pleasehelp.

    DB:2.84:Function Mkl_Sdnscsr- Urgent 9m


    Older versions of MKL may not provide the single-precision versions of functions, e.g., mkl_sdnscsr(). For example, the MKL that came with Intel C++ 11.1.065 did not. You can settle the question for your installation by running the command below in the MKL\LIB\IA32 directory:

    ..mkllibia32 dumpbin /symbols mkl_core.lib | find "mkl_sdnscsr"

    If nothing is found, you conclude that only the double precision version is available, and you may consider obtaining a later version of MKL.

    Your code in #5 above has a bug; you need to add a "return 0;" statement before the FAILURE1: label. Otherwise, the code prints a "FAILED" message even after a correct run.

  • RELEVANCY SCORE 2.83

    DB:2.83:Udo Masterdata And Matrix 79



    Hi everyone,

    I have a problem to load a matrix.

    I have a form whith type x, uniqueID y and objectType z (z is an UDO)

    The UDO and the table are MasterData

    Then, I have a matrix with two columns; one for a Code, the other for the Name.

    Tha columns have:

    Alias = Code / Name

    DataBound = true

    Table = @NameOfTable

    But the matrix doesn't load the values from ddbb.

    What I Do wrong?

    Thanks

    Carles

    DB:2.83:Udo Masterdata And Matrix 79


    Hi Eddy and njmog1,

    Finally I've removed the matrix ang I've put two fields.

    Thank you for all

    Carles

  • RELEVANCY SCORE 2.83

    DB:2.83:Where Is The Uniqueid Value Stored In The Sharepoint Database? sk


    I'm trying to find where the 'UniqueId' field is stored in the SharePoint database for a list item. Not the GUID, but the UniqueID. This value is usually formatted like [ID#;GUID]. The guid here is different than the item guid.
    In the documentation the column has a description, 'Lookup to a GUID for an item.' (http://msdn.microsoft.com/en-us/library/dd961684(v=office.12).aspx)
    but I can't find it in the database.
    Here is the query I tried.
    SELECT UserData.*
    FROM dbo.Lists INNER JOIN dbo.UserData
    ON dbo.Lists.tp_ID = dbo.UserData.tp_ListId
    WHERE dbo.UserData.tp_ListId = '[my list]'

    This should pull all values from the AllUserData table but it doesn't list 'UniqueID' as a column.

  • RELEVANCY SCORE 2.83

    DB:2.83:Grid Column: Editable="0" Don't Work Well 7s



    Hello all.

    I'm inserting a new grid column on a specific grid of an addon and I'm having the following problem:

    The column property "Editable" are "0" (false), but the rows below the last filled row looks as an editable column, only for this new column.

    All visual code of this form are in a SRF file, and here is the tag of this column:

    GridColumn UniqueID="COCodLCM" Title="Cdigo do LCM Gerado" LinkedObject="30" Visible="1" Editable="0" AffectsFormMode="1" RightJustified="0" Type="16" Width="151"
    ValidValues/ValidValues
    /GridColumn

  • RELEVANCY SCORE 2.82

    DB:2.82:Nested Matrix Group Subtotals ax


    Hi -

    Does anyone know how to make a standard matrix report give subtotals for a level 1 group?

    Scenario:

    standard matrix report
    level 1 and level 2 row groups
    one column group

    I need the report to give me subtotals for each of my level 1 groups per column. Because this is a nested matrix report, I cannot use the Matrix with a Group design - it blows up.

    Thanks for your help.
    ~SM

    DB:2.82:Nested Matrix Group Subtotals ax

    i am sure there is a way to do that using summary columns, placeholder columsn and some pl/sql code .. however it is hard to give the exact solution without knowing your report in detail.

    thanks,
    ph.

  • RELEVANCY SCORE 2.79

    DB:2.79:Having A Button A Matrix Column... xa



    His this possible to have a button in a column of a Matrix ?

    DB:2.79:Having A Button A Matrix Column... xa


    His this possible to have a button in a column of a Matrix ?

  • RELEVANCY SCORE 2.79

    DB:2.79:Tictactoe Program Help. 97


    Basically I am writing a tictactoe program and I have it working for the most part except when it prints out the board it comes out as one line. Here is my code so far
    public class TicTacToe
    {
    public static void main(String[] args)
    {

    int[][] matrix = new int[3][3];
    for (int row = 0; row matrix.length; row++) {
    for (int column = 0; column matrix[row].length; column++) {
    matrix[row][column] = (int)(Math.random() * 2);
    }
    }
    for (int row = 0; row matrix.length; row++) {
    for (int column = 0; column matrix[row].length; column++) {
    System.out.print(matrix[row][column] + " ");
    }
    }




    }
    }The output comes out to be:
    0 0 1 1 0 0 1 1 1

    when I want it to look like this:
    0 0 1
    1 0 0
    1 1 1

    I considered adding for (int p = 0; p % 3 = 0; p++)and using that to make the line break every time p was 0 but I am unsure how to incorporate it into my code.
    Any tips are appreciated.

    DB:2.79:Tictactoe Program Help. 97

    ArslanAhmad

    Please do not solicit off-forum communication to your email address as this defeats the purpose of a forum. I'm blocking your post on that account.

    For those following this thread, here is the remaining content.

    db

    =================================
    import java.util.Scanner;

    public class TickTacToe {

    public static void main(String[] args) {

    Scanner input = new Scanner(System.in);

    int line=0;
    int go=0;
    int player=0;
    int row=0;
    int column=0;
    int winner=0;
    char board[][] = {

    {'1','2','3'},
    {'4','5','6'},
    {'7','8','9'}

    };

    for(int i=0;i9winner==0;i++)
    {
    System.out.println(board[0][0]+" "+board[0][1]+" "+board[0][2]);
    System.out.println(board[1][0]+" "+board[1][1]+" "+board[1][2]);
    System.out.println(board[2][0]+" "+board[2][1]+" "+board[2][2]);

    player = i%2+1;
    char sign;
    if(player==1)
    sign = 'X';
    else
    sign = '0';

    do
    {
    System.out.println("Player "+player+" Enter the number of the square where you want to place your:"+sign);
    go=input.nextInt();
    System.out.println(go);

    row = --go/3; /* Get row index of square */
    column = go%3; /* Get column index of square */
    System.out.println("ROW NUMBER::"+row);
    System.out.println("COLUMN NUMBER::"+column);
    }while(go0 || go9 || board[row][column]'9');


    board[row][column] = (player == 1) ? 'X' : 'O';


    /* Check for a winning line - diagonals first */

    if((board[0][0] == board[1][1] board[0][0] == board[2][2]) ||
    (board[0][2] == board[1][1] board[0][2] == board[2][0]))
    winner = player;

    else

    /* Check rows and columns for a winning line */

    for(line = 0; line = 2; line ++)
    if((board[line][0] == board[line][1] board[line][0] == board[line][2])||
    (board[0][line] == board[1][line] board[0][line] == board[2][line]))
    winner = player;

    }


    /* Game is over so display the final board */

    System.out.println(board[0][0]+" "+board[0][1]+" "+board[0][2]);
    System.out.println(board[1][0]+" "+board[1][1]+" "+board[1][2]);
    System.out.println(board[2][0]+" "+board[2][1]+" "+board[2][2]);

    /* Display result message */
    if(winner == 0)

    System.out.println("\nHow boring, it is a draw\n");

    else

    System.out.println("\nCongratulations player,"+player+" YOU ARE THE WINNER");

    }

    }This is Complete game you can try it have fun.. If you feel any problem regarding this code dont hesitate to contact me.

  • RELEVANCY SCORE 2.78

    DB:2.78:Store Column Into Matrix 31



    Hello, I'm acquiring some data that comes into a string of numbers. I'd like to store them into a matrix in this way: for acquisition 1 - data in column 1, acquisition 2-data in column 2 and so on...

    I did the code attached simulating some data, but when I put them in the matrix, the new acquisition finishes in column 1 and the old one become a list of 0.

    Any suggestion?

    ps - I'm acquiring pixel values, so at the end I'd like a pixel matrix to reconstruct an image. every acquisition is a vertical line of the image.










    Attachments:







    column.png ‏13 KB

    DB:2.78:Store Column Into Matrix 31

    Elena_vsc wrote:

    Hi, could you tell me where is the error? thanks

    Your VI looks nothing like my example. I cannot really tell what the error is, because you are not telling us what kind of result you get and what kind of result you expect. Do you get an error message?

    You did not initialize the shift register (right-click the left side...create constant)
    LabVIEW makes no distinction between row vectors and column vectors. so remove the smaller "build array" and the transposition. Transpose once outside the loop, after it leaves the right shift register. (and also going to the "appended array" indicator if needed). Make the "transposed array" a 1D array and resize it vertically on the front panel.




    LabVIEW Champion . Do more with less code and in less time .

  • RELEVANCY SCORE 2.78

    DB:2.78:Help On This Program!!! 9m


    I have a problem with these programs.When complied, error message is that cannot resolve symbol
    symbol:method linearEquations()
    location :class MatrixOp
    p.linearEquations
    ^
    Question:how do i link the 3 files together?
    :how to solve the error msg?
    :anything wrong in the programs?

    -----------------------------------------------------------------
    class Input
    {
    public static void main(String args[])
    {
    int i;

    MatrixOp p = new MatrixOp();
    double [][] A = {{0,2,1},{2,4,4},{3,1,0}};
    double [] b = {7,22,5};
    p.linearEquations();
    System.out.println("The solution of AX=b:");

    for(i=0; i3; i++)
    {
    System.out.println(b);
    }
    }
    }

    ------------------------------------------------------------------
    class Gaussian
    {
    public void linearEquations(double [][] A, double[] b)
    {

    //matrix A will be destroyed,solution will be in matrix b
    //checking size of matrix A

    int n=A.length;

    if(A[0].length != n)
    {
    System.out.println("Matrix A should be be a square matrix");

    return;
    }

    int i,j,k, itemp=0;
    double maxi,temp;

    //Looking for largest entries in the column

    for(j=0; jn; j++)
    {
    maxi=-1E-12;

    for(i=j; in; i++)
    {
    if(Math.abs(A[i][j]) maxi)
    {
    itemp=1;
    maxi=Math.abs(A[i][j]);
    }
    }

    if(maxi1E-12)
    {
    System.out.println
    ("The Set either has a mutltiple" +"solutions or no unique solution");
    return;
    }

    //Permuting itemp row with the j-th row

    if(itemp != j)
    {
    for(k=j; kn; k++)
    {
    temp=A[j][k];
    A[j][k]=A[itemp][k];
    A[itemp][k]=temp;
    }

    temp=b[j];
    b[j]=b[itemp];
    b[itemp]=temp;
    }

    //Divide j-th row by A[i][j]

    temp=A[i][j];
    b[j]=b[j]/temp;

    for(k=j; kn; k++)
    {
    A[j][k]=A[j][k]/temp;
    }

    for(i=0; in; i++)
    {
    if(i != j)
    {
    temp=A[i][j];

    for(k=0; kn; k++)
    {
    A[i][k]=A[i][k]-temp*A[j][k];
    b[i]=b[i]-temp*b[j];
    }
    }
    }
    }

    }

    }

    ------------------------------------------------------------------
    class MatrixOp
    {
    private int m,n;

    public double [][] add(double[][] A, double [][] B)
    {
    double [][] C = new double[A.length][A[0].length];

    if ( A.length != B.length || A[0].length != B[0].length)
    {
    System.out.println("Matrix not compatible for additions!");

    return(new double [1][1]);
    }

    int i, j;

    for (i=0; iA.length; i++)

    for (j=0; jA.length; j++)

    C[i][j]=A[i][j]+B[i][j];

    return C;

    }

    public double [][] mult(double [][] A, double [][] B)
    {
    if (A[0].length != B.length)
    {
    System.out.println("Matrix not compatible for multiplication!");

    return(new double[1][1]);
    }

    double[][] C = new double[A.length] [B[1].length];

    int i,j,k;

    for (i=0; iA.length; i++)

    for (j=0; jB[1].length; j++)
    {
    C[i][j]=0;

    for (k=0; kA[1].length; k++)

    C[i][j] = C[i][j] + A[i][k] * B[k][j];

    }
    return C;

    }

    public double [][] tr(double [][] A)
    {
    double[][] C = new double[A[0].length][A.length];

    int i, j;

    for (i=0; iA.length; i++)
    for (j=0; jA[1].length; j++)

    C[j][i] = A[i][j];

    return C;
    }

    public void print(double [][] A)
    {
    int n=A.length;
    int m=A[0].length;

    int i,j ;

    for (i=0; in; i++)
    {
    for (j=0; jm; j++)
    {
    System.out.println(A[i][j]+" ");
    System.out.println();
    }

    }
    System.out.println();
    }
    }

    DB:2.78:Help On This Program!!! 9m

    linearEquations is a method of Gaussian, not MatrixOp. And this thread belongs in Java Programming, not Algorithms - it's not about Gaussian elimination but about getting code to compile.

  • RELEVANCY SCORE 2.77

    DB:2.77:Snake Program zx


    Hey I'm trying to rework a program of Snake. Instead of growing when it eats apples I'd like to get it to grow after a certain interval of time has passed. Here is the code at the moment.

    import javax.swing.*;
    import java.awt.*;
    import java.awt.image.BufferedImage;
    import java.awt.event.*;
    import java.awt.image.*;
    import java.util.Random.*;


    public class snakeprog extends JApllet implements KeyListener
    {
    private BufferedImage myImage;
    private Graphics buffer;
    private int [][] matrix=new int [100][100];

    private int xSn=50;
    private int ySn=50;
    private int SnDir=0;
    private int xcor =(int)(Math.random()*100);
    private int ycor =(int)(Math.random()*100);
    private int[]xvalues=new int [100];
    private int[]yvalues=new int [100];
    private int counter=0;
    private int maxLength=5;
    private int length=1;



    public void print()
    {
    for(int x=0;x100;x++)
    {
    for(int y=0;y100;y++)
    {
    System.out.print(matrix[x][y]);
    }
    System.out.println();
    }
    }
    public void zero()
    {
    for(int x=0;x100;x++)
    {
    for(int y=0;y100;y++)
    {
    matrix[x][y]=0;
    }
    }
    }
    public void walls()

    {
    for(int x=0;x100;x++)
    {
    matrix[x][0]=1;
    }
    for(int y=0;y100;y++)
    {
    matrix[0][y]=1;
    }
    for(int a=0;a100;a++)
    {
    matrix[a][99]=1;
    }
    for(int b=0;b100;b++)
    {
    matrix[99]=1;
    }

    }
    public void level1()
    {
    zero();
    walls();

    }
    public void level2()
    {

    zero();
    walls();
    for(int a=25;a75;a++)
    {
    matrix[a][50]=1;
    }

    }
    public void level3()
    {
    zero();
    walls();
    for (int a=25;a75;a++)
    {
    matrix[25][a]=1;
    matrix[75][a]=1;
    }
    }
    public void level4()
    {
    zero();
    walls();
    for (int a=15;a85;a++)
    {
    matrix[50][a]=1;
    }
    for(int b=15;b85;b++)
    {
    matrix[b][50]=1;
    }
    }
    public void level5()
    {
    zero();
    walls();
    for(int b=10;b90;b++)
    {
    matrix[b][5]=1;
    matrix[b][95]=1;
    }
    for(int b=10;b90;b++)
    {
    matrix[5][b]=1;
    matrix[95][b]=1;
    }
    for(int b=30;b70;b++)
    {
    matrix[b][15]=1;
    matrix[b][85]=1;
    }
    for(int b=30;b70;b++)
    {
    matrix[15][b]=1;
    matrix[85][b]=1;
    }
    for(int b=45;b65;b++)
    {
    matrix[b][30]=1;
    matrix[b][65]=1;
    }
    for(int b=45;b65;b++)
    {
    matrix[30][b]=1;
    matrix[65][b]=1;
    }
    }
    public void paint (Graphics g)
    {
    g.drawImage(myImage, 0, 0, getWidth(), getHeight(), null);

    }
    public void make_buffer()
    {
    for(int x=0;x100;x++)
    {
    for(int y=0;y100;y++)
    {
    if(matrix[x][y]==1)
    {
    buffer.setColor(Color.red);
    buffer.fillRect(x*5+50,y*5+50,5,5);
    }
    if(matrix[x][y]==0)
    {
    buffer.setColor(Color.black);
    buffer.fillRect(x*5+50,y*5+50,5,5);
    }
    if(matrix[x][y]==2)
    {
    buffer.setColor(Color.green);
    buffer.fillRect(x*5+50,y*5+50,5,5);
    }
    if(matrix[x][y]==3)
    {
    buffer.setColor(Color.green);
    buffer.fillOval(xcor,ycor,10,10);
    }
    }

    }
    }
    private class Listener implements ActionListener
    {
    public void actionPerformed(ActionEvent e)
    {
    if(!still_in_race) return;
    if(SnDir==0)
    {
    ySn--;
    }

    if(SnDir==2)
    {
    ySn++;
    }

    if(SnDir==1)
    {
    xSn++;
    }

    if(SnDir==3)
    {
    xSn--;
    }
    if(matrix[xSn][ySn]!=0) still_in_race=false;
    if(lengthmaxLength) {
    length++;
    } else {
    matrix[xvalues[0]][yvalues[0]]=0;
    for(int i=1; i != length; i++) {
    xvalues[i-1]=xvalues;
    yvalues[i-1]=yvalues[i];
    }
    }
    xvalues[length-1]=xSn;
    yvalues[length-1]=ySn;
    matrix[xSn][ySn]=2;

    make_buffer();
    repaint();
    }

    public snake()

    {
    addKeyListener(this);
    myImage= new BufferedImage (600,600,BufferedImage.TYPE_INT_RGB);
    buffer = myImage.getGraphics();
    level1();

    set_starting_point();
    //apple();
    print();
    repaint();

    Timer t = new Timer(100,new Listener()); //new Timer is made
    t.start();//timer starts

    }
    public static void main(String[]args)
    {
    snake window = new snake();
    window.setSize(600,600);
    window.setLocation(0,0);
    window.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    window.show();
    window.requestFocus();
    }

    public void set_starting_point()
    {
    matrix[xSn][ySn]=2;
    }
    /*public void apple()
    {
    matrix[xcor][ycor]=3;

    }*/
    public void crash()
    {

    }
    public void keyPressed(KeyEvent e)
    {
    switch(e.getKeyCode())
    {
    case KeyEvent.VK_LEFT:
    SnDir=3;
    break;
    case KeyEvent.VK_RIGHT:
    SnDir=1;
    break;
    case KeyEvent.VK_UP:
    SnDir=0;
    break;
    case KeyEvent.VK_DOWN:
    SnDir=2;
    break;
    }
    }
    public void keyReleased(KeyEvent e)
    {
    switch(e.getKeyCode())
    {
    case KeyEvent.VK_LEFT:

    break;
    case KeyEvent.VK_RIGHT:

    break;
    case KeyEvent.VK_UP:

    break;
    case KeyEvent.VK_DOWN:

    break;
    }
    }
    public void keyTyped(KeyEvent e)
    {
    }

    }
    }

    DB:2.77:Snake Program zx

    Thanks for the advice. I honestly found Turing a lot more intuitive than Java. If anyone else has any code suggestions or hints I'd really appreciate it.

  • RELEVANCY SCORE 2.77

    DB:2.77:Adding Custom Column To A User Matrix 1f



    Hi all

    I have a little problem

    When i create my matrix i add columns according to how many ship to's i have

    from there if i have 3 ship to's three columns are created with the shipto Name as the title.

    My problem is

    The ship to itself length is 10 characters then my program crashes and says

    INVALID length string cannot surpass 10 characters.

    I know this has to do with the datasources the thing is the datsource are useally created AFTER the matrix is created. So i cannot define a length for the column BEFORE the matrix is created because i get a null reference

    My question is is there a way without datasources or with to set the colmun length

    and when i say length i do not mean size. ( i actually mean how many characters this column can accept)

    Thanks looking forword to your answers!

    DB:2.77:Adding Custom Column To A User Matrix 1f


    Hi All

    Thanks for your answers but i have redone my Code so that instead of creating of putting Name and Description the same (NAME can be a max of 10 char) i put Name to ST_0, ST_1 ....

    And Description to the fill name which can hold 10 Characters

  • RELEVANCY SCORE 2.76

    DB:2.76:How To Importing From Fixed Width Flat File?. 7s


    I am working on a data warehousing project where my source is a FIXED WIDTH Flat File and my target is Teradata.
    How can i import data from such a flat file, it does not have any delimiter.?.

    File format for ex:

    1st column is of length 1,

    2nd column is of length 30,

    3rd column is of length 50,

    4th column is of length 10 and so on....

    DB:2.76:How To Importing From Fixed Width Flat File?. 7s


    Hi Adil,

    I have posted a similar solution in the following thread... Can you please check it, if it hepls?

    https://community.informatica.com/message/55345#55345

    Thank you

    Prashant

  • RELEVANCY SCORE 2.75

    DB:2.75:Showing Uniqueid For Matrix Columns In Screen Painter 7m



    i m using SAP B1 9.0 latest version and screen painter 9.00 version as well. The problem i am not able to edit/view the correct uid (unique id) for each of the matrix columns. i try reinstall the SAP client software but still not working.

    DB:2.75:Showing Uniqueid For Matrix Columns In Screen Painter 7m


    Hi Simon

    Definitely u can change the UID other properties in the SRF file usng the VS. but necessary UID changes also reflect in your methods , functions events used the said UID

  • RELEVANCY SCORE 2.74

    DB:2.74:Code Problem xz


    well i have 3 problems

    public Matrix(String matrixString)
    {
    String sMatrix = matrixString.split(";");
    int column = sMatrix.length();

    String tMatrix = sMatrix.trim();
    int values = tMatrix.length();

    int row = values/column;

    int nMatrix = Integer.parseInt(tMatrix);

    int[][] matrixArray = new int [row][column];
    }for this first code, the compiler says "Incompatible types" for the code that starts with String sMatrix

    public Matrix add(Matrix B)
    {
    for (int x=0, y=0; x Matrix.length y Matrix[x].length; x++, y++)
    {
    Matrix[x][y] = B;
    }

    if((row == a)(column == b))
    {
    int i=0, j=0, x=0, y=0, ix=0, jo=0;

    while ((i matrixArray.length)(x Matrix.length))
    {
    i++;
    x++;

    while ((j matrixArray.length)(y Matrix[x].length))
    {
    j++;
    y++;

    while ((ix newMatrix.length)(jo newMatrix[ix].length))
    {
    ix++;
    jo++;

    newMatrix[ix][jo] = matrixArray[i][j] + Matrix[x][y];
    }
    }
    }
    }
    }
    in this code the compiler gives the same message but this time for the code that starts with Matrix[x][y] = B

    public Matrix scalarMult(double k)
    {
    double scalar = k;

    for (int i=0; i matrixArray.length; i++)
    {
    for (int j=0; j matrixArray.length; j++)
    {
    for (int ix=0, jo=0; ix newMatrix.length jo newMatrix[ix].length; ix++, jo++)
    {
    newMatrix[ix][jo] = scalar * matrixArray[i][j];
    }
    }
    }
    }
    and finally for this code, the compiler gives the error message "possible loss of precision" for the code newMatrix[ix][jo] = scalar * matrixArray[i][j];
    and i don't understand this final message

    thx
    and i hope that i'm not asking too much

    DB:2.74:Code Problem xz

    i changed it to this code but i get the error "cannot find symbol method split(java.lang.String) for the code "String[] tMatrix = sMatrix.split(" ");" , when i am applying it to an array and expecting in return an array to.
    and i have to change the string to an int but i cant do it to an array
    public Matrix(String matrixString)
    {
    String[] sMatrix = matrixString.split(";");

    int column = sMatrix.length;

    String[] tMatrix = sMatrix.split(" ");
    int values = tMatrix.length;

    int row = values/column;

    int nMatrix = Integer.parseInt(tMatrix);

    int[][] matrixArray = new int [row][column];
    }this is what this class is supposed to do
    /**
    * Creates a new matrix my parsing the specified string.
    *
    * The string will be in the following format:
    * [ 3 4 ; 2 1 ; -3 5 ]
    *
    * Rerpresents the 3 x 2 matrix:
    *
    * 3 4
    * 2 1
    * -3 5
    *
    * Hint: lookup String.split(String regex) and String.trim()
    *
    */
    public Matrix(String matrixString)
    {
    /* fill this is */
    }

  • RELEVANCY SCORE 2.74

    DB:2.74:Matrix -Equipment / Boot Time Length For Cisco kc



    Hi everybody,

    did not manage to find that kind of information the cisco web site.

    Searching a table/matrix that could give me an average of the time that is needed for an equipement to boot.

    I already agree that this will depend of:

    * hardware configuration of the equip. (how many cards in the slots) because the Power On Self test will be longer

    DB:2.74:Matrix -Equipment / Boot Time Length For Cisco kc


    based on the caveat you sited it is useless to gather such information.

    Another factor is whether you are doing minimal or bypass or complete diagnostics (on catalyst platforms).

  • RELEVANCY SCORE 2.73

    DB:2.73:Add Value To Column In Matrix jc



    hi

    dim n as integer=10

    dim tot as integer

    omatrix = oForm.Items.Item("mtrx").Specific

    For i = 1 To omatrix.RowCount

    If Len(omatrix.Columns.Item("lcode").Cells.Item(i).Specific.value()) 0 Then

    valu = Integer.Parse(omatrix.Columns.Item("numdays").Cells.Item(i).Specific.value()) 'select empno from matrix rows

    End If

    Next

    tot=valu-n

    my question is

    hw to add calculated tot value to column of the matrix

    DB:2.73:Add Value To Column In Matrix jc


    If the question is answered please assign points and close the thread.

    this is so in future if someone is searching they can see an answered thread and check it to see if it helps.

  • RELEVANCY SCORE 2.72

    DB:2.72:Finding Values In A Matrix 9s


    I have a matrix, inwhich I want to identify a column based on a row values, go down in that column until I find the value that I am looking for and then go across that row into the first column of that row and provide that value. How do I do that?

  • RELEVANCY SCORE 2.72

    DB:2.72:Insert Data Into Table 11


    When I try to insert data into the table, I get the error message:
    [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The name 'uniqueID' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

    What is wrong in the following code?

    String uniqueID, GenericType;
    float elevation, CalcTotalHeight, CalcTotalArea, CalcTotalVolume;
    ...
    ...
    stmt.executeUpdate(
    "INSERT INTO IFCData VALUES (uniqueID, GenericType, elevation, CalcTotalHeight, CalcTotalArea, CalcTotalVolume)" );

  • RELEVANCY SCORE 2.71

    DB:2.71:Technique To Control An Automatically Expanding Matrix Column Group xa


    Hello guys I have a .rdlc with a matrix control. the matrix has its column header cell grouped. At runtime the data detail field expands horizontally on one line causing the report width to increase, which is expected. but how do i control the length to  which it expands i.e specify the number of columns that expand on a line and cause it to continue on the next line so that i can preserve the original length of my report. illustration:     data1      data2      data3      data4       data5 ...................             datan (not appropriate) would want the matrix to expand as        data1         data2        data3                                                            data4        data5         .......                                                            datan

    DB:2.71:Technique To Control An Automatically Expanding Matrix Column Group xa

    Hello guys I have a .rdlc with a matrix control. the matrix has its column header cell grouped. At runtime the data detail field expands horizontally on one line causing the report width to increase, which is expected. but how do i control the length to  which it expands i.e specify the number of columns that expand on a line and cause it to continue on the next line so that i can preserve the original length of my report. illustration:     data1      data2      data3      data4       data5 ...................             datan (not appropriate) would want the matrix to expand as        data1         data2        data3                                                            data4        data5         .......                                                            datan

  • RELEVANCY SCORE 2.71

    DB:2.71:Identity On Non-Pk Column (Property) 9d


    Is there a way to tell Data Svcs. I want to identify my entities on something besides the property that is marked as the PK ? I know this sounds odd, but from the model side we have the following:
    int ID (PK)
    string UniqueID
    and I want Data Svcs. to do lookups on UniqueID. For example, if I delete an entity, I want the lookup based off of UniqueID, but I can't make UniqueID PK for other reasons. I have tried query interceptors, but it's too late at that point, b/c
    lookup is already done.

    Thanks.

    DB:2.71:Identity On Non-Pk Column (Property) 9d

    Hi,
    Pam is correct. WCF Data Services uses so called key properties which basically uniquly specify each entity. If you're using EF as the provider for WCF DS, then primary keys are the key properties (you can't change this).
    With custom provider (or with reflection provider) you can define the key properties yourself though. Implementing custom provider is a lot of work, and if you're already using EF then reflection provider won't really work either.
    Thanks,Vitek Karas [MSFT]

  • RELEVANCY SCORE 2.71

    DB:2.71:Proper Reading In Of A Matrix. p3


    Hello,

    I am having difficulty figuring out how to accuratly specify the range of my matrix. After a file is selected in my program from the GUI the file name gets passed to the bufferedreader and then my code translates the csv into a matrix. However how can I tell the height of my matrix? The matrix.length seems to be the length of my matrix. As well as the counter in my first while loop. They appear to be equal values when I do testing. Is there some way to know the dimensions of a matrix being read in so I don't get strange output when I try to convert this matrix to a different type. Thank you.

    Example of what I am trying to figure out:

    Incoming .csv file:
    4,5,2,3,5
    1,3,3,4,5
    2,3,4,5,6

    Length is 4 (from 0 to 4)*
    Height is 2 (from 0 to 2)*
    *Note If this is not how java assigns its matrix please let me know

    This is what I have for code to do this, but how can I tell if my matrix is limited and gain access to these values for future manipulation?:

    Code:
    BufferedReader br = new BufferedReader(new FileReader(chooser.getSelectedFile()));

    while((line = br.readLine()) != null) {
    list.add(line.replaceAll(" ",""));
    counter++;
    }

    matrix = new String[list.size()][];

    for(int x = 0; x matrix.length; x++) {
    matrix[x] = ((String)list.get(x)).split(",");
    }

    DB:2.71:Proper Reading In Of A Matrix. p3

    For anyone whos interested I figured it out.
    The code that I was looking for is:

    matrix[n].length; // Size of how many seperate instantces are on that line of the array.

    [/code[

  • RELEVANCY SCORE 2.70

    DB:2.70:Number Default Length 1x


    What is the default length for a column of type NUMBER if the length is not explicitly defined in Oracle 9.2.0.5 ?

    DB:2.70:Number Default Length 1x

    The absence of precision and scale designators specifies the maximum range and precision for an Oracle number.

    http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements2a.htm#45723

  • RELEVANCY SCORE 2.69

    DB:2.69:Set Values In Matrix p3



    hi ,

    i created matrix in screen painter. it includes 3 columns unit of measurement, length, width.

    i want to set values to length and width manually.

    when the form is loaded the length and width should appear in matrix

    Regards,

    Puneeth

    DB:2.69:Set Values In Matrix p3


    Here an sample to add DataSource-Information via a XML-Editor.

    form appformnumber="WREDE_CREDITNOTES" FormType="WREDE...
    datasources
    dbdatasources
    action type="add"
    datasource tablename="@WREDE_CREDITNOTES"/
    datasource tablename="@WREDE_CN_LINES"/
    /action
    /dbdatasources
    userdatasources
    action type="add"
    datasource uid="FolderDS" type="9" size="1"/
    datasource uid="NumAtCard" type="9" size="100"/
    datasource uid="cnnumber" type="9" size="100"/
    datasource uid="dnline" type="0" size="4"/
    datasource uid="lines" type="0" size="4"/
    datasource uid="sum" type="6" size="8"/
    datasource uid="sum2" type="6" size="8"/
    datasource uid="draft" type="0" size="4"/
    datasource uid="Folder2" type="9" size="1"/
    datasource uid="FolderDS" type="9" size="10"/
    datasource uid="FolderDS" type="9" size="10"/
    /action
    /userdatasources
    DataTables
    DataTable Uid="OPENDN"
    Columns/
    /DataTable
    /DataTables
    /datasources
    Menus

  • RELEVANCY SCORE 2.69

    DB:2.69:Image In Column Header Of User Matrix kp



    Hi,

    does anybody know how i can show an image in the column header of a matrix. I'm using a user matrix.

    thanks for help.

    Markus

    DB:2.69:Image In Column Header Of User Matrix kp


    2005A does not give any resolution to this either, but the columns have their titleobject as a whole class with just one property so I see this as a hint that we might get it, and more important in my view sorting later. but not until 2005A SP1 or perhaps first in 2006A

  • RELEVANCY SCORE 2.68

    DB:2.68:Pivot Example zx


    I need to some help to PIVOT my dataset, need to move the description column to individual columns, soI have 1 row for eaach id
    below is an example
    declare @Pivot table (
    S_dates datetime
    , id varchar(10)
    , code varchar(100)
    , description varchar(max))
    insert @Pivot select '2014-03-24 00:00:00.000','1580/7','07611819360532','Matrix 90° L-Plate, medium, 22 holes, reversible, thickness 0.8 mm, Pure Titanium, sterile'
    insert @Pivot select '2014-03-24 00:00:00.000','1580/7','07611819362369','Matrix Screw Ø 1.85 mm, self-drilling, length 4 mm, Titanium Alloy (TAN), sterile, pack of 4 units in Clip'
    insert @Pivot select '2014-03-24 00:00:00.000','1580/7','07611819362383','Matrix Screw Ø 1.85 mm, self-drilling, length 5 mm, Titanium Alloy (TAN), sterile, pack of 4 units in Clip'
    insert @Pivot select '2014-03-24 00:00:00.000','1580/7','07611819362437','Matrix Screw Ø 2.1 mm, self-tapping, length 4 mm, Titanium Alloy (TAN), sterile, pack of 1 unit in Clip'
    insert @Pivot select '2014-03-21 00:00:00.000','7551/4','07611819362406','Matrix Screw Ø 1.85 mm, self-drilling, length 6 mm, Titanium Alloy (TAN), sterile, pack of 4 units in Clip'
    insert @Pivot select '2014-03-21 00:00:00.000','7551/4','07611819362437','Matrix Screw Ø 2.1 mm, self-tapping, length 4 mm, Titanium Alloy (TAN), sterile, pack of 1 unit in Clip'
    insert @Pivot select '2014-03-21 00:00:00.000','7551/4','07611819377523','Matrix Drill Bit Ø 1.4 mm with Stop, length 44.5/8 mm, for J-Latch Coupling, sterile'
    insert @Pivot select '2014-03-21 00:00:00.000','4820/4','07611819360709','Matrix Anatomic L-Plate, short, 33 holes, reversible, thickness 0.8 mm, Pure Titanium, sterile'
    insert @Pivot select '2014-03-21 00:00:00.000','4820/4','07611819362222','Matrix Screw Ø 1.85 mm, self-tapping, length 6 mm, Titanium Alloy (TAN), sterile, pack of 4 units in Clip'
    insert @Pivot select '2014-03-21 00:00:00.000','4820/4','07611819377523','Matrix Drill Bit Ø 1.4 mm with Stop, length 44.5/8 mm, for J-Latch Coupling, sterile'
    insert @Pivot select '2014-03-21 00:00:00.000','3738/4','07611819360709','Matrix Anatomic L-Plate, short, 33 holes, reversible, thickness 0.8 mm, Pure Titanium, sterile'
    insert @Pivot select '2014-03-21 00:00:00.000','3738/4','07611819362222','Matrix Screw Ø 1.85 mm, self-tapping, length 6 mm, Titanium Alloy (TAN), sterile, pack of 4 units in Clip'
    insert @Pivot select '2014-03-21 00:00:00.000','3738/4','07611819362406','Matrix Screw Ø 1.85 mm, self-drilling, length 6 mm, Titanium Alloy (TAN), sterile, pack of 4 units in Clip'
    insert @Pivot select '2014-03-21 00:00:00.000','3738/4','07611819362437','Matrix Screw Ø 2.1 mm, self-tapping, length 4 mm, Titanium Alloy (TAN), sterile, pack of 1 unit in Clip'
    insert @Pivot select '2014-03-21 00:00:00.000','3738/4','07611819377523','Matrix Drill Bit Ø 1.4 mm with Stop, length 44.5/8 mm, for J-Latch Coupling, sterile'
    insert @Pivot select '2014-03-21 00:00:00.000','6578/1','07611819360709','Matrix Anatomic L-Plate, short, 33 holes, reversible, thickness 0.8 mm, Pure Titanium, sterile'
    insert @Pivot select '2014-03-21 00:00:00.000','6578/1','07611819362406','Matrix Screw Ø 1.85 mm, self-drilling, length 6 mm, Titanium Alloy (TAN), sterile, pack of 4 units in Clip'
    insert @Pivot select '2014-03-12 00:00:00.000','7666/1','07611819381100','Drill Bit Ø 1.5 mm with Stop, length 50/6 mm, 2-flute, for J-Latch Coupling, sterile'
    select * from @Pivot

    DB:2.68:Pivot Example zx

    Sounds like this is what you're after
    SELECT S_dates,id,
    MAX(CASE WHEN Seq = 1 THEN code END) AS Code1,
    MAX(CASE WHEN Seq = 1 THEN description END) AS description1,
    MAX(CASE WHEN Seq = 2 THEN code END) AS Code2,
    MAX(CASE WHEN Seq = 2 THEN description END) AS description2,
    MAX(CASE WHEN Seq = 3 THEN code END) AS Code3,
    MAX(CASE WHEN Seq = 3 THEN description END) AS description3,
    MAX(CASE WHEN Seq = 4 THEN code END) AS Code4,
    MAX(CASE WHEN Seq = 4 THEN description END) AS description4,
    MAX(CASE WHEN Seq = 5 THEN code END) AS Code5,
    MAX(CASE WHEN Seq = 5 THEN description END) AS description5
    FROM
    (
    SELECT ROW_NUMBER() OVER (PARTITION BY S_Dates,id ORDER BY Code) AS Seq,*
    FROM @Pivot
    )t
    GROUP BY S_dates,id
    to make this dyanmic see
    http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/dynamic-crosstab-with-multiple-pivot-columns.aspx

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Where abouts do I add an INTO statement, so the results are stored into a table? I thought it would be as easy as adding INTO Table just before the first FROM statement, but its not working
    like this
    SELECT S_dates,id,
    MAX(CASE WHEN Seq = 1 THEN code END) AS Code1,
    MAX(CASE WHEN Seq = 1 THEN description END) AS description1,
    MAX(CASE WHEN Seq = 2 THEN code END) AS Code2,
    MAX(CASE WHEN Seq = 2 THEN description END) AS description2,
    MAX(CASE WHEN Seq = 3 THEN code END) AS Code3,
    MAX(CASE WHEN Seq = 3 THEN description END) AS description3,
    MAX(CASE WHEN Seq = 4 THEN code END) AS Code4,
    MAX(CASE WHEN Seq = 4 THEN description END) AS description4,
    MAX(CASE WHEN Seq = 5 THEN code END) AS Code5,
    MAX(CASE WHEN Seq = 5 THEN description END) AS description5
    INTO YourNewTableName
    FROM
    (
    SELECT ROW_NUMBER() OVER (PARTITION BY S_Dates,id ORDER BY Code) AS Seq,*
    FROM @Pivot
    )t
    GROUP BY S_dates,id
    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

  • RELEVANCY SCORE 2.68

    DB:2.68:Count In Matrix 3c


    Hi,In matrix i have a field status if i have 5 no's of 'A' in that column and 4 no's of 'N' in that column. In header i should get value 5 in Accepted text box and value 4 in rejected text box. Plz give me a solution for it.Madhavi

    DB:2.68:Count In Matrix 3c

    I commented the title object now its working sorry without noticing it i posted the question

  • RELEVANCY SCORE 2.68

    DB:2.68:How To Get Blanket Column From Sales Order Matrix ds



    Hi,

    I need to know the index of column "Is Blanket" in sales order matrix.

    Generally, is there a way to get all columns index for a matrix?

    currently i'm using:

    colBlk = mSales.get_Columns().Item("U_blanket");

    but it doesn't work, i got the error "Invalid column".

    Can anyone help me?

    Thank's in advance.

    Best Regards

    Andrea

    DB:2.68:How To Get Blanket Column From Sales Order Matrix ds


    Hi

    You can go to the SAP Business One menu and select the System Information (checked). Then you can go to the screen and with the mouse hover over that column. You'll notice the information in the status bar. Something similar to this

    [Form=139 Item=29 Column=11 .... ]

  • RELEVANCY SCORE 2.67

    DB:2.67:Problem With Jpa @Embeddable Class Field In @Embedded a1


    I have a Embeddable class and Embadded in all of my JPA Entities, the version(in DBUniqueId) field is mandatory for some JPA Entities and for others it should not be present.

    My DBUser.java JPA Entity shouldn't have version field(DBUser table doesn't have one) and so I didn't include it in @AttributeOverrides of DBUser.java. when I try to run the JPA query it results in exception

    Query:
    ListDBUser userList = (ListDBUser)entityManager.createQuery(SELECT u FROM DBUser u WHERE u.userId.root=?1 AND u.userId.extension=?2).setParameter(1,"root1").setParameter(2,"ext1").getResultList ();

    And The Exception is:
    ---- Begin backtrace for Nested Throwables
    java.sql.SQLException: ORA-00904: "T0"."VERSION": invalid identifier

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)

    How do I inform to JPA Entity to ignore only the version field of the Embeddable in my JPA Entity @Embedded place.
    So the above query can successful. Thank You!

    Please guide me to solve this problem.

    @Embeddable
    @MappedSuperclass
    public class DBUniqueId implements Serializable {

    /**
    * serialVersionUID.
    */
    private static final long serialVersionUID = 8903598739796209331L;
    /**
    * root.
    */
    private String root;
    /**
    * extension.
    */
    private String extension;
    /**
    * version.
    */
    private String version;

    //Getters Setters

    }

    @Entity
    @Table(name = "MyTable", schema = "MySchema")
    public class DBUser implements Serializable {
    /**
    * unique user id.
    */
    private DBUniqueId uniqueUserId;
    /**
    * Get the unique user id.
    *
    * @return codeDBUniqueId/code - unique person id
    */
    @Embedded
    @AttributeOverrides( {
    @AttributeOverride(name = "root", column = @Column(name = "LUSR02_ID_ROOT", nullable = true, length = 50)),
    @AttributeOverride(name = "extension", column = @Column(name = "LUSR02_ID_EXT", nullable = true, length = 50))
    })
    public DBUniqueId getUserId () {
    return uniqueUserId;
    }
    /**
    * set user unique id.
    *
    * @param uniqueId - unique id of the person
    */
    public void setUserId (final DBUniqueId uniqueId) {
    this.uniqueUserId = uniqueId;
    }

    }

    DB:2.67:Problem With Jpa @Embeddable Class Field In @Embedded a1

    Hi,

    I am not sure weather, you understood my post or not, just summarizing it in short.

    First of all my DBUniqueId.java is not JPA entity, it is Embeddable or MappedSuperclass having three properties.

    And DBUser.java is a JPA entity and it overrides only two leaving version like below.
    @Embedded
    @AttributeOverrides( {
    @AttributeOverride(name = "root", column = @Column(name = "LUSR02_ID_ROOT", nullable = true, length = 50)),
    @AttributeOverride(name = "extension", column = @Column(name = "LUSR02_ID_EXT", nullable = true, length = 50))
    })
    public DBUniqueId getUserId () {
    return uniqueUserId;
    }

    When i try to query on DBUser.java JPA entity, it throws exception.
    My understanding is that since DBUser.java is not overriding attribute 'extension' in AttributeOverride annotation, it should not throw exception when I query on DBUser entity.

    For this problem, temporarly I have created DBVersionUniqueId.java and made it work and working around to find solution for the above problem.

    I will post if I find any. Thank You!

  • RELEVANCY SCORE 2.67

    DB:2.67:Row Numbering In Matrix 37



    hi guys,

    I create one form in screen painter and use this form in VB.net. In this form one matrix is available.

    In the first column of the matrix I want to display serial number for the Row.

    how is it possible to display serial number in the first column?

    can anyone help me for this problem?

    thanks.

    DB:2.67:Row Numbering In Matrix 37


    Hi

    What also works quite nicely is when you start painting the matrix with code, is to delete this column, and then add another column as you wish, see some sample code below

    oMatrix = oform.Items.Item("4").Specific
    oMatrix.Columns.Remove("V_0")

    oMatrix.Columns.Add("Type", SAPbouiCOM.BoFormItemTypes.it_EDIT)
    oColumn = oMatrix.Columns.Item("Type")
    oColumn.DataBind.SetBound(True, "", "uds7")
    oColumn.TitleObject.Caption = "Entity"
    oColumn.Editable = False
    oColumn.Width = "100"

  • RELEVANCY SCORE 2.67

    DB:2.67:Most Efficient Way To Process Row-Major 2-D Matrix Column Wise c3



    Hi,

    I'm testing out TBB right now. One of the algorithms I want to parallelize works on a row-major 2-D matrix by processing a column at a time.

    How can I code this in TBB such that my algorithm can work on a column at a time?

    Assuming that: matrix is M (row) x N (column), and given pointer float* that points to the (0,0) of the matrix. Assume further that the matrix is contiguous.

    Originally, I hand-coded this such that for each element in the column, I stride by i*N to get to the next row.

    Taking this a step further: how can we parallelize a column strip (i.e. if an algorithm works on multiple columns at a time)?

    DB:2.67:Most Efficient Way To Process Row-Major 2-D Matrix Column Wise c3


    What are the typical array dimensions?

    The easiest way to operate on columns at the same time is to use a parallel_for.

    False sharingmay be a problem, particularly if the operations writes to columns of the matrix. One cache line on Core 2 Duo is 64 bytes. That's 16 floats. If you have thousands of columns, it might pay to process 16 columns at a time. Doing so would require writing range object similar to blocked_range, but always stays on multiple-of-16 boundaries. (If we ever add a fourth template parameter to blocked_range, it should be for this "multiple of" feature.) Or use the normal blocked_range, but let each index in it represent a group of 16 columns. That complicates the indexing calculations slightly but should not be unwieldly.

    If there are too few columns for that scheme to work, you might actually be better off (at least with regard to cacheline traffic) copying each column to a temporary vector, operate on the temporary, and then copy back. Likewise copying might pay off if there are so many rows that a group of 16 columns will not fit in outer-level cache.

    The parallel_for template tends to distribute indices relatively far apart to different threads, so if there are many more columns than worker threads, the false sharing issue might not be a big issue. I suggest trying the obvious straightforward indexing first.

  • RELEVANCY SCORE 2.67

    DB:2.67:Default Value For A Column In Matrix dk



    Hi,

    How to set default value for a column in matrix which is of type combo(Yes/No).

    The cell has combo in it

    Manoj

    DB:2.67:Default Value For A Column In Matrix dk


    Hi Manoj,

    The column is set as combo. Now you need to tell SBO what constituates a Y or N. In my example my Column "Col6" must display Yes if the RENTED column = 1 and No if the RENTED column = 0. (I'm obviously using a datasource to tie the data to the matrix)

    oMatrix = frm.Items.Item("YourMatrixID").Specific

    oColumns = oMatrix.Columns

    oColumn = oColumns.Item("Col6")

    oColumn.DataBind.SetBound(True, "@VIDEO", "U_RENTED")

    oColumn.ValOn = "1"

    oColumn.ValOff = "0"

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Build A Matrix Of Zeros xk



    Hello,

    I am trying to build a tsunami Simulator and I need to create an empty matrix of zeros for the three variables u,v and b. How do I go about doing this?

    The code I need to enter is:

    % Build empty u, v, b matricesu=zeros(length(x), length(y), length(t));v=zeros(length(x), length(y), length(t));b=zeros(length(x), length(y));h=zeros(length(x), length(y), length(t));

    Thanks

    Sam

    DB:2.67:How To Build A Matrix Of Zeros xk


    Remember to mark a post as a Solution if it solved your problem (and give Kudos where appropriate )




    ----------------------------------------------------------------------------------------------------------------------------"If anyone needs me, I'll be in the Angry Dome!"

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Make Group Matrix Report In Bi Publisher Template Builder For Word p9


    Dear All

    I have created a template in MSWord's BI Publisher for creating Matrix report, it is working fine, but i couldn't do it for Group matrix report. Kindly give me any kind of example regarding group matrix or nested group in column level and row level.

    Regards
    Haq Nawaz
    A.F.Ferguson Co

    Edited by: 823804 on Dec 28, 2010 5:42 PM

    DB:2.67:How To Make Group Matrix Report In Bi Publisher Template Builder For Word p9

    Hey hi,
    I m also trying to create template for matrix wih group. have you found any solution for this? if yes please forward me the information on my mail id patilpoonam2238@gmail.com

  • RELEVANCY SCORE 2.66

    DB:2.66:Previous Expression For Column In Matrix? 17


    Is there an expression function like Previous for columns in a matrix?

    DB:2.66:Previous Expression For Column In Matrix? 17

    Hi Jerry,
    I just want tobe able to show the difference between one column and the next in a matrix report. I.e., column 1 is 10%, column 2 is 20% and column 3 would be the difference between the two. There are a variable number of columns though. I don't mind
    if the difference is somehow shown in column 2 using an expression either.

  • RELEVANCY SCORE 2.66

    DB:2.66:Unable To Understand About The Nvl 37


    i want to know the space used by the following column , it may be possible that one of these column will bw null, for taht purpose i m using NVL , but i m unable to understand that where i will put null, to get the exact space

    i have three queries here , let me know which will give me correct result ,because all these three queries gives me different result

    select (
    nvl(sum(length(mis_skill_lookup)),0) +
    nvl(sum(length(mis_skill_selected)),0) +
    nvl(sum(length(mis_place_selected)),0) +
    nvl(sum(length(mis_agent_selected)),0) +
    nvl(sum(length(mis_dblookup_checkpoint)),0) +
    nvl(sum(length(mis_call_duration)),0) +
    nvl(sum(length(mis_survey_result)),0) +
    nvl(sum(length(mis_survey_id)),0)
    / 1024) / 1024 a
    from mis_data where mis_dblookup_checkpoint 0 and mis_call_duration 0;

    in the second and third query i have put nvl only in one column , just for an example, i will latter on put it into all the column

    select ((sum(length(mis_skill_lookup)) +
    sum(length(mis_skill_selected)) +
    sum(length(mis_place_selected)) +
    sum(length(mis_agent_selected)) +
    sum(length(mis_dblookup_checkpoint)) +
    sum(length(mis_call_duration)) +
    sum (length (nvl(mis_survey_result,0))) +
    sum(length(mis_survey_id))) / 1024) / 1024 a
    from mis_data where mis_dblookup_checkpoint 0 and mis_call_duration 0;

    select ((sum(length(mis_skill_lookup)) +
    sum(length(mis_skill_selected)) +
    sum(length(mis_place_selected)) +
    sum(length(mis_agent_selected)) +
    sum(length(mis_dblookup_checkpoint)) +
    sum(length(mis_call_duration)) +
    nvl(sum(nvl(length('||mis_survey_result||'),0)),0) +
    sum(length(mis_survey_id))) / 1024) / 1024 a
    from mis_data where mis_dblookup_checkpoint 0 and mis_call_duration 0;

  • RELEVANCY SCORE 2.65

    DB:2.65:Select Next Upcoming Date From Multiple Tables jj


    Hi everyone,
    I have two tables Client and
    Event.
    Client has 6 events say e1, e2, e3, e4, e5, e6 in chronological order and each one of this column is related
    Event.
    Event table has eventstarttime column.
    I am trying to extract the next upcoming event (e1 or e2 or e3 or e4 or e5 or e6) for each client. I was able to list the number of hours before the next upcoming event for each client but not the eventid itself.
    I appreciate if you can suggest me someways to accomplish this query..thank You.

    Client Table

    ClientID

    E1

    E2

    E3

    E4

    E5

    E6

    uniqueid

    uniqueid

    uniqueid

    uniqueid

    uniqueid

    uniqueid

    uniqueid

    Event Table

    EventID

    Eventstarttime

    uniqueid

    datetime

    DB:2.65:Select Next Upcoming Date From Multiple Tables jj

    Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how, follow ISO-11179 data element naming conventions and formatting rules. Temporal
    data should use ISO-8601 formats. Code should be in Standard SQL as much as possible and not local dialect.

    Sample data is also a good idea, along with clear specifications. It is very hard to debug code when you do not let us see it. If you want to learn how to ask a question on a Newsgroup, look at: http://www.catb.org/~esr/faqs/smart-questions.html

    Most newbies post vague narratives; you are the first to post vague QBE diagrams! Have you ever rad a book on RDBMS? Do you know what a repeating group violation of First Normal Form (1NF) is? Post the DDL and let's fix this insterad of kludging something.

    --CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets
    / Trees and Hierarchies in SQL
    I didn't mean to post anything vague. Iapologize. My only intention was to keep my question as simple as possible.
    Thanks for yoursuggestions. I know the 1NF repeating group violation rule of 1 NF. I am aware that my table violates that rule and as I am using some else's design and I can't change it now.
    Let me ask you my question again.

    I have two tables : Prospect and Event, below is the DDL for the two tables

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[prospect](
    [prospectid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_prospect_prospectid] DEFAULT (newid()),
    [name] [nvarchar](255) NOT NULL CONSTRAINT [DF_prospect_name] DEFAULT (''),
    [na_eventid] [uniqueidentifier] NULL,
    [sp_eventid] [uniqueidentifier] NULL,
    [as_eventid] [uniqueidentifier] NULL,
    [ci_eventid] [uniqueidentifier] NULL,
    [ci2_eventid] [uniqueidentifier] NULL,
    [ci3_eventid] [uniqueidentifier] NULL,
    [cl_eventid] [uniqueidentifier] NULL,
    [fd_eventid] [uniqueidentifier] NULL,
    [ff_eventid] [uniqueidentifier] NULL,
    CONSTRAINT [PK_prospect] PRIMARY KEY CLUSTERED
    (
    [prospectid] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event1] FOREIGN KEY([sp_eventid])
    REFERENCES [dbo].[event] ([eventid])
    GO
    ALTER TABLE [dbo].[prospect] CHECK CONSTRAINT [FK_prospect_event1]
    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event2] FOREIGN KEY([as_eventid])
    REFERENCES [dbo].[event] ([eventid])
    GO
    ALTER TABLE [dbo].[prospect] CHECK CONSTRAINT [FK_prospect_event2]
    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event3] FOREIGN KEY([cl_eventid])
    REFERENCES [dbo].[event] ([eventid])
    GO
    ALTER TABLE [dbo].[prospect] CHECK CONSTRAINT [FK_prospect_event3]
    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event4] FOREIGN KEY([ci_eventid])
    REFERENCES [dbo].[event] ([eventid])
    GO
    ALTER TABLE [dbo].[prospect] CHECK CONSTRAINT [FK_prospect_event4]
    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event5] FOREIGN KEY([ci2_eventid])
    REFERENCES [dbo].[event] ([eventid])
    GO
    ALTER TABLE [dbo].[prospect] CHECK CONSTRAINT [FK_prospect_event5]
    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event6] FOREIGN KEY([ci3_eventid])
    REFERENCES [dbo].[event] ([eventid])
    GO
    ALTER TABLE [dbo].[prospect] CHECK CONSTRAINT [FK_prospect_event6]
    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event7] FOREIGN KEY([fd_eventid])
    REFERENCES [dbo].[event] ([eventid])
    GO
    ALTER TABLE [dbo].[prospect] CHECK CONSTRAINT [FK_prospect_event7]
    GO
    ALTER TABLE [dbo].[prospect] WITH CHECK ADD CONSTRAINT [FK_prospect_event8] FOREIGN KEY([ff_eventid])
    REFERENCES [dbo].[event] ([eventid])

    ---------------------------------------------------------------------------------------------------------------------------

  • RELEVANCY SCORE 2.65

    DB:2.65:Matrix Column pm



    Dear Users,

    In my form, I have made the first column of the matrix non-editable through screen painter. My problem is when I press TAB from the last column of the matrix...

    The cursor gets set to first row (2nd Column) always. according to me. It should be in 2nd Row (2nd Column).

    Please help me....

    Regards

    DB:2.65:Matrix Column pm


    Hi Kuldeep,

    You are double clicking on a cell on the previous row with this :

    oMatrix.Columns.Item(enControlName.colPaid).Cells.Item(Row - 1).Click(BoCellClickType.ct_Double, 0);

    If you want it to move to the next row the use pVal.Row + 1 (just make sure you have a row there or else an exception will be thrown).

    I haven't tested it thought. Let me know how it goes.

    Good luck.

    Best regards,

    Pedro Magueija

  • RELEVANCY SCORE 2.65

    DB:2.65:Matrix Column Sort 8f



    Hi!

    I need to sort the column of a matrix as a result of clicking on the column header.

    How can I do?

    Thanks

    DB:2.65:Matrix Column Sort 8f


    Hi

    You can use below code line.

    oMatrix = oFirstForm.Items.Item("Matrix").Specific

    ' Get Column object

    oColumn = oMatrix.Columns.Item("CardCode")

    oColumn.TitleObject.Sortable = True

    ' Sort by columnh

    Ascending sort order

    oColumn.TitleObject.Sort(SAPbouiCOM.BoGridSortType.gst_Ascending)

    or

    Descending sort order

    oColumn.TitleObject.Sort(SAPbouiCOM.BoGridSortType.gst_Descending)

    Thanks

    Sunil Babu Keerthy

  • RELEVANCY SCORE 2.65

    DB:2.65:Fixed Column Names In Matrix Dynamic Column ad


    Hello all
    Iam trying to pivot fixed number of column values using matrix in ssrs2008

    in my case i need 10 coumn values need to be pivoted even though i dont get 10 values every time

    i.e i need 10 fixed column names pivoted and there corresponding relevent values if we get any ,else null values for the missing column

    Many Thanks
    siddu

    DB:2.65:Fixed Column Names In Matrix Dynamic Column ad

    Hi,
    You can use relational engine anduse OPENROWSET to get the output from the cube in table format. Then apply the result in that table to process with the logic detailed above.
    A sample to read from cube from within TSQL is

    SELECT *
    FROM OPENROWSET(MSOLAP, DATASOURCE=server name;Initial Catalog=SSAS DB name;,
    select [measures].[sales] on 0,
    {[category].members} on 1
    from [cube]
    ) AS Table1

  • RELEVANCY SCORE 2.65

    DB:2.65:Max Table Name Length And Column Name Length? fk


    Does anyone have any pointers to a matrix of database length limits?
    For example, a list of each of the major databases' max table name
    length, max column name length, max varchar length, etc.

    I've seen some one-on-one comparisons (SQL Server vs Oracle, etc) but
    nothing very complete. I'd appreciate any pointers anyone has to this
    topic.

    thanks,
    dave

    DB:2.65:Max Table Name Length And Column Name Length? fk

    David McCuistion wrote:

    Does anyone have any pointers to a matrix of database length limits?
    For example, a list of each of the major databases' max table name
    length, max column name length, max varchar length, etc.I've seen some one-on-one comparisons (SQL Server vs Oracle, etc) but
    nothing very complete. I'd appreciate any pointers anyone has to this
    topic.thanks,
    daveHi Dave,

    I stumbled upon this...............
    ---------------------------------------------------------------------
    Feature SQL Server 2000 IBM DB2 v8.1
    column name length 128 128
    index name length 128 128
    table name length 128 128
    view name length 128 128
    cursor name length 128 18
    constraint name length 128 18
    password length 128 32
    SQL variable length 128 64
    user name length 128 30
    index length 900 1024
    max char() size 8000 254
    max varchar() size 8000 32672
    max columns per table 1024 1012
    max table row length 8036 32677
    max columns per index 16 16
    max indexes per table 250 32767
    longest SQL statement 16777216 65535
    columns per SELECT statement 4096 1012
    columns per INSERT statement 1024 1012
    nested stored procedure levels 32 16
    -------------------------------------------------------------------------

    Oracle 9i Database IBM DB2v8.1
    database name length 8 8
    column name length 30 128
    index name length 30 128
    table name length 30 128
    view name length 30 128
    stored procedure name length 30 128
    most columns per table 1000 1012
    most columns in an index key 32 16
    max number of columns in GROUP BY 255 1012
    max number of columns in ORDER BY 255 1012
    longest index key 3155 1024
    max varchar() size 4000 32672
    max char() size 2000 254
    max table row length 255000 32677
    longest SQL statement 16777216 65535
    recursive subqueries 64 28
    constant string size in SELECT 4000 32672
    --------------------------------------------------------------------------

    Feature SQL Server 2000 Oracle 9i Database
    database name length 128 8
    column name length 128 30
    index name length 128 30
    table name length 128 30
    view name length 128 30
    stored procedure name length 128 30
    index length 900 749
    max columns per index 16 32
    max char() size 8000 2000
    max varchar() size 8000 4000
    max columns per table 1024 1000
    max table row length 8036 255000
    max query size 16777216 16777216
    recursive subqueries 40 64
    constant string size in SELECT 16777207 4000
    constant string size in WHERE 8000 4000
    ---------------------------------------------------------------------------

    Check out this link for ingres......
    http://dbforums.com/arch/41/2002/5/371623

    Cheers,
    -Sapna

  • RELEVANCY SCORE 2.65

    DB:2.65:Datagridview Column Max. Length 1a


    Hello all!
     
    How can I get a column cell with max. length quantity of signs?
     
    Example:
    dataGridView.Rows[row.Index].Cells[XXX].MaxLength = 10;
     
    Thanks for every help!

  • RELEVANCY SCORE 2.65

    DB:2.65:Generation Of Uniqueid sp


    Hi All,
    Does any one know in Forte, shall we generate unique-ID,
    continuously, given a starting string and length of the string, like we
    have in VC++( MFC).

    Thankx,
    Babu

    Bid and sell for free at http://auctions.yahoo.com

    DB:2.65:Generation Of Uniqueid sp

    Hi All,
    Does any one know in Forte, shall we generate unique-ID,
    continuously, given a starting string and length of the string, like we
    have in VC++( MFC).

    Thankx,
    Babu

    Bid and sell for free at http://auctions.yahoo.com

  • RELEVANCY SCORE 2.65

    DB:2.65:Documaker : How To Set The Field Of 2d Matrix zf


    Hi,

    I created a field of 2D Matrix, but it's not 2D Matrix...
    Can you notice what this is wrong?

    Font ID : Data Matrix for Documaker (dm______.ttf)
    Type : Bar Code
    Length : 32
    Format : Data Matrix
    Symbol Size : 18 * 18
    Scale : 1
    Rule : XDD
    Source Name : xxxxxxx

    XML sample is as follows.

    Barcode
    xxxxxxx12345678901234567890123456789012/xxxxxxx
    /Barcode

    In test, this field is output as follows...

    AIHPBMGKHJENFPFKDK
    AHFMCKOBPOEONLALIK
    ALJLFFJMANLMMJAEBK
    AGFCPMJOBELOEIKFCK
    DDLDDDDDLLLLDLDDDL

    I can output the barcode with the 'Code 39 1:1:2:2'.
    Please help me.

    Thanks

    DB:2.65:Documaker : How To Set The Field Of 2d Matrix zf

    Hi,

    Thank you for your reply!

    With your advice, I checked the FXR file on Server.
    That is not changed from about 1 years ago...

    There is also your advice, this problem is solved.
    Thank you!

  • RELEVANCY SCORE 2.65

    DB:2.65:Tic Tac Toe Code Help sx


    I am a beginner Java programmer, and I need help with my tic tac toe code.

    import javax.swing.JOptionPane;

    /*
    * Created on Nov 14, 2006
    *
    * TODO To change the template for this generated file go to
    * Window - Preferences - Java - Code Style - Code Templates
    */

    /**
    * @author jye
    *
    * TODO To change the template for this generated type comment go to
    * Window - Preferences - Java - Code Style - Code Templates
    */
    public class TicTacToe {

    public static void main(String[] args) {
    int[][]matrix = {{0,1,2},{3,4,5},{6,7,8}};

    while (true)
    {
    System.out.println(); //keeps the tables seperate
    for(int row = 0; rowmatrix.length;row++)
    {
    for(int col = 0; col matrix[row].length;col++)
    {

    if (matrix[row][col]!=-1 matrix[row][col]!=-2) //Compares each element to -1 and and -2, if not, then it just prints out the regular number
    {
    System.out.print(matrix[row][col] + " ");
    }
    if (matrix[row][col]==-1)
    {
    System.out.print("X" + " ");
    }
    if (matrix[row][col]==-2)
    {
    System.out.print("O" + " ");
    }
    }
    System.out.println();
    }

    int p1 = Integer.parseInt(JOptionPane.showInputDialog (null, "Enter number 1"));
    int p2 = Integer.parseInt(JOptionPane.showInputDialog (null, "Enter number 2"));
    for(int row = 0; rowmatrix.length;row++) //this piece of code refers to above print code
    {
    for(int col = 0; col matrix[row].length;col++)
    {
    if (p1==matrix[row][col]) //compares each element in array to the position inputted. If it is equal to the number inputted, then it changes that to -1. For example, the postition of 4 is [1][1], it will replace [1][1] with -1. The matrix[row][col] is a position.
    {
    matrix[row][col]=-1;
    }
    if(p2==matrix[row][col])
    {
    matrix[row][col]=-2;
    }
    }
    }


    for(int row = 0; rowmatrix.length;row++)
    {
    for(int col = 0; col matrix[row].length;col++)
    {
    if(matrix[0][0]==-1 matrix[0][1]==-1 matrix[0][2]==-1)
    {
    System.out.println("Player 1 wins.");break;
    }
    if(matrix[1][0]==-1 matrix[1][1]==-1 matrix[1][2]==-1)
    {
    System.out.println("Player 1 wins.");break;
    }
    if(matrix[2][0]==-1 matrix[2][1]==-1 matrix[2][2]==-1)
    {
    System.out.println("Player 1 wins.");break;
    }
    if(matrix[0][0]==-1 matrix[1][0]==-1 matrix[2][0]==-1)
    {
    System.out.println("Player 1 wins.");break;
    }
    if(matrix[0][1]==-1 matrix[1][1]==-1 matrix[2][1]==-1)
    {
    System.out.println("Player 1 wins.");break;
    }
    if(matrix[0][2]==-1 matrix[1][2]==-1 matrix[2][2]==-1)
    {
    System.out.println("Player 1 wins.");break;
    }
    if(matrix[0][0]==-1 matrix[1][1]==-1 matrix[2][2]==-1);
    {
    System.out.println("Player 1 wins.");break;
    }
    if(matrix[0][2]==-1 matrix[1][1]==-1 matrix[2][0]== -1)
    {
    System.out.println("Player 1 wins.");break; //I GET A "UNREACHEABLE CODE" ERROR HERE
    }
    if(matrix[0][0]==-2 matrix[0][1]==-2 matrix[0][2]==-2)
    {
    System.out.println("Player 2 wins.");break;
    }
    if(matrix[1][0]==-2 matrix[1][1]==-2 matrix[1][2]==-2)
    {
    System.out.println("Player 2 wins.");break;
    }
    if(matrix[2][0]==-2 matrix[2][1]==-2 matrix[2][2]==-2)
    {
    System.out.println("Player 2 wins.");break;
    }
    if(matrix[0][0]==-2 matrix[1][0]==-2 matrix[2][0]==-2)
    {
    System.out.println("Player 2 wins.");break;
    }
    if(matrix[0][1]==-2 matrix[1][1]==-2 matrix[2][1]==-2)
    {
    System.out.println("Player 2 wins.");break;
    }
    if(matrix[0][2]==-2 matrix[1][2]==-2 matrix[2][2]==-2)
    {
    System.out.println("Player 2 wins.");break;
    }
    if(matrix[0][0]==-2 matrix[1][1]==-2 matrix[2][2]==-2);
    {
    System.out.println("Player 2 wins.");break;
    }
    if(matrix[0][2]==-2 matrix[1][1]==-2 matrix[2][0]== -2)
    {
    System.out.println("Player 2 wins.");break;//I GET A "UNREACHEABLE CODE" ERROR HERE
    }
    }
    }




    }

    }
    }Why do I get a unreachable error code???
    Thanks.

    DB:2.65:Tic Tac Toe Code Help sx

    Thanks so much. Haha, I'm a bit tired right now. Thanks again!

  • RELEVANCY SCORE 2.65

    DB:2.65:Automatic Decrease Column Width Of The Matrix kc



    Hi my gurus,

    Pls help me, I made a form with a matrix. After each times I open that form, each column in matrix automatic to decrease it's width, what happen ? And how to correct it, to column is fixed width ? thanks for every helping. I'm using SBO 2005A, to develop by VB.NET, screen painter.

    DB:2.65:Automatic Decrease Column Width Of The Matrix kc


    Thank you very much Adele and Nick. My problem was solved.

  • RELEVANCY SCORE 2.65

    DB:2.65:Nvarchar Length Issue jk


    i created this table in SQL Server 2008 R2.
    CREATE TABLE MyTable
    (
    Uniqueid NUMERIC,
    TITLE NVARCHAR(11),
    firstname NVARCHAR(17),
    initial VARCHAR(1),
    lastname VARCHAR(31)
    )

    right after i created this table ran sp_help MyTable
    As you can see all the NVARCHAR column lengths are doubled. is there a reason?

    Column_name
    Type
    Computed
    Length
    Prec

    Uniqueid
    numeric
    no
    9
    18

    Title
    nvarchar
    no
    22

    firstname
    nvarchar
    no
    34

    initial
    varchar
    no
    1

    lastname
    varchar
    no
    31

    DB:2.65:Nvarchar Length Issue jk

    As the side note, there are a few inconsistencies in your table structure. In case, if you need to deal with unicode data, it would make sense to define all parts of the name as unicode strings. Not only FirstName and Title.
    Also, for Initial it's better to use CHAR(1)/NCHAR(1) rather than variable width column. With fixed-width columns you'd always use 1/2 bytes. With variable width you'd use extra 2 bytes in offset array (even when null). Only exception would be the case when
    both Initial and LastName are null (assuming you have physical order of columns the same with what you have in CREATE TABLE statement).Thank you!
    My blog: http://aboutsqlserver.com

  • RELEVANCY SCORE 2.65

    DB:2.65:Text &Amp; Align Properties For Column - Not Working f8


    I would like to perform column alignment in Matrix kind of report. But it is not allowing to perform column alignments. How to resolve this.

    DB:2.65:Text &Amp; Align Properties For Column - Not Working f8

    Hi,

    We have a known bug with doing alignment in the Matrix view.

    4934836: MATRIX: VALUES ARE CENTERED INSTEAD OF RIGHT JUSTIFIED

    We are targeting the next major release for this fix.

    Regards, Stephen

  • RELEVANCY SCORE 2.64

    DB:2.64:Best Practices For Determining Column Length fd


    Hi,

    I would like to know if there are any best practices available in determining the length for column.

    My question revolves around most of the v$ tables in Oracle. Almost all v$ tables have column length in multiples of 8 i.e 8, 16, 24 and so on...

    Appreciate, if someone could throw light on the advantages/disadvantages of having column length in multiples of 8.

    Thanks in advance

    DB:2.64:Best Practices For Determining Column Length fd

    No, there's no benefit to define your column length in multiple of 8. Only define it according to your needs.

    Other than that, it's not true that v$ tables in Oracle define column length in multiples of 8. some of them yes some of them not.

    SQL desc v$instance
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    INSTANCE_NUMBER NUMBER
    INSTANCE_NAME VARCHAR2(16)
    HOST_NAME VARCHAR2(64)
    VERSION VARCHAR2(17)
    STARTUP_TIME DATE
    STATUS VARCHAR2(12)
    PARALLEL VARCHAR2(3)
    THREAD# NUMBER
    ARCHIVER VARCHAR2(7)
    LOG_SWITCH_WAIT VARCHAR2(15)
    LOGINS VARCHAR2(10)
    SHUTDOWN_PENDING VARCHAR2(3)
    DATABASE_STATUS VARCHAR2(17)
    INSTANCE_ROLE VARCHAR2(18)
    ACTIVE_STATE VARCHAR2(9)
    BLOCKED VARCHAR2(3)
    EDITION VARCHAR2(7)

    SQL desc v$log
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    GROUP# NUMBER
    THREAD# NUMBER
    SEQUENCE# NUMBER
    BYTES NUMBER
    MEMBERS NUMBER
    ARCHIVED VARCHAR2(3)
    STATUS VARCHAR2(16)
    FIRST_CHANGE# NUMBER
    FIRST_TIME DATE

  • RELEVANCY SCORE 2.64

    DB:2.64:Specifying Maximum Length For A Column ak


    HI,

    Is it possible to specify a column length of its maximum permissible length for that datatype
    For ex:
    create table test (name varchar(10));
    in the above DDL is it possible to make the 'name' column accept the max permissible length for varchar
    how must the data type be declared for it.

    Regards

    DB:2.64:Specifying Maximum Length For A Column ak

    Hi
    Is it advisable to use refcursors or temporary tables as a rule of thumb.....can anyone give a few thoughts on this...

    Thanks in advance
    Regards

  • RELEVANCY SCORE 2.64

    DB:2.64:Date Column In Matrix .... fm



    Hi my gurus,

    I design form by Screen Painter with a matrix, I want to load DocNum, DocDate, ... of ORDR table into matrix, but it error: "Invalid date value". Pls tell me how to do it. Thanks for everything.

  • RELEVANCY SCORE 2.64

    DB:2.64:Total Of The Matrix Column At The Bottom Of Column ss



    Hi,

    I have a query here.

    I'm adding one UDF in packing matrix of Delivery transaction(Marketing Docs). Now I want to display total of that col. at the bottom. SAP B1 shows such total for its own system column e.g Weight column in packing matrix. Pls. suggest a way to show/display such total in a matrix.

    Thanx and regards.

    K. Vivek

    DB:2.64:Total Of The Matrix Column At The Bottom Of Column ss


    Hi,

    Thanx for reply, since it is total of the colum, I want to show it at the bottom of that column, by creating another col. interface wise it is not so user friendly. Therefore I force to diplay at bottom only.

    Thanks regards.

  • RELEVANCY SCORE 2.64

    DB:2.64:Format Column For Currency k8



    How do you format a column to display currencies ?

    $3, 524.32 instead of just 3524.32

    The matrix column is bound to a DataTable

    DB:2.64:Format Column For Currency k8


    Hello

    What you can do is to build up the Currency sign into your query when you load the datatable. Otherwise the system will not show the Currency symbol.

    Regards,

    Jnos

  • RELEVANCY SCORE 2.64

    DB:2.64:Some Info About Form Exists jk



    HI..

    i had a matrix..

    it has some values on the first column so

    i want to copy all these values into the sales order one of the column.

    so i used oform.getformtypecount

    used for loop

    so first matrix suppose contain 10 rows ..

    ten times the sales order form is loading

    i don't want to load the onece the form is exist..

    so , i had used the below bold color code

    this code is working in previous program present not working ..

    may i know why..

    how can i know the form is exist or not

    if open i dont' want to activate it

    how can i solve this one.......................

    Try

    If (pVal.BeforeAction = True And pVal.FormUID = "TT" And pVal.EventType = SAPbouiCOM.BoEventTypes.et_COMBO_SELECT) Then

    Dim obcb As SAPbouiCOM.ButtonCombo

    obcb = oform.Items.Item("122").Specific

    Dim ic As String

    'oform = sbo_app.Forms.Item("TT")

    'omatrix = oform.Items.Item("9").Specific

    For i = 1 To omatrix.VisualRowCount

    oform = sbo_app.Forms.Item("TT")

    omatrix = oform.Items.Item("9").Specific

    ic = omatrix.Columns.Item("V_1").Cells.Item(i).Specific.value

    Dim x As Integer

    Dim foundG As Boolean = False

    For x = 0 To sbo_app.Forms.Count - 1

    If sbo_app.Forms.Item(x).UniqueID = "139" Then

    foundG = True

    Exit For

    End If

    Next

    If foundG = True Then

    sbo_app.Forms.Item("139").Select()

    Else

    sbo_app.ActivateMenuItem("2050")

    oform = sbo_app.Forms.GetFormByTypeAndCount("139", "1")

    End If

    Dim orec As SAPbobsCOM.Recordset

    orec = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

    orec.DoQuery("select t0.cardcode,t0.cardname from ocrd t0 where t0.cardcode='ap01001'")

    oform.Items.Item("4").Specific.value = orec.Fields.Item(0).Value

    oform.Items.Item("54").Specific.value = orec.Fields.Item(1).Value

    omatrix = oform.Items.Item("38").Specific

    omatrix.Columns.Item("1").Cells.Item(i).Specific.value = ic

    omatrix.AddRow(1)

    Next

    End If

    Catch ex As Exception

    sbo_app.MessageBox(ex.Message)

    End Try

    DB:2.64:Some Info About Form Exists jk


    Hi,

    yes, because there's a second mistake - sbo_app.Forms.Item("139").Select()

    you are mixing UniquedId and FormType.

    save the found unique id in a temp variable.

    use the variable to get the form

    For x = 0 To sbo_app.Forms.Count - 1

    If sbo_app.Forms.Item(x).TypeEx = "139" Then

    tempstring = sbo_app.Forms.Item(x).UniqueID;

    foundG = True

    Exit For

    End If

    Next

    If foundG = True Then

    sbo_app.Forms.Item(tempstring).Select()

    lg David

  • RELEVANCY SCORE 2.64

    DB:2.64:Need Help In Trying To Understand Class Objects s7


    I need help on understanding following problem.I have two files for that, which are as follows:

    first file
    public class Matrix extends Object {
    private int matrixData[][];// integer array to store integer data
    private int rowMatrix;// number of rows
    private int colMatrix;// number of columns

    public Matrix( int m, int n )
    { /*Constructor: initializes rowMatrix and colMatrix,
    and creates a double subscripted integer array matrix
    of rowMatrix rows and colMatrixm columns. */
    rowMatrix = m;
    colMatrix = n;
    matrixData = new int[rowMatrix][colMatrix];
    }
    public Matrix( int data[][] )
    {/* Constructor: creates a double subscripted integer array
    and initilizes the array using values of data[][] array. */
    rowMatrix = data.length;
    colMatrix = data[0].length;
    matrixData = new int [rowMatrix][colMatrix];
    for(int i=0; irowMatrix; i++)
    for(int j=0; jcolMatrix; j++)
    matrixData[i][j] = data[i][j];
    }
    public int getElement( int i, int j)
    { /* returns the element at the ith row and jth column of
    this matrix. */
    return matrixData[i][j];
    }
    public boolean setElement( int x, int i, int j)
    {/* sets to x the element at the ith row and jth column
    of this matrix; this method should also check the
    consistency of i and j (i.e., if i and j are in the range
    required for subscripts; only in this situation the operation
    can succeed); the method should return true if the operation
    succeeds, and should return false otherwise.
    */

    for(i=0;irowMatrix;i++){
    for(j=0;jcolMatrix;j++){
    x = matrixData[i][j];
    }
    }
    if(irowMatrix jcolMatrix){
    return true;
    }
    else{
    return false;
    }
    }

    public Matrix transposeMatrix( )
    {/*returns a reference to an object of the class Matrix,
    that contains the transpose of this matrix. */
    Verify tata;
    Matrix trans;
    //Matrix var = matrixData[rowMatrix][colMatrix];
    for(int row=0;rowrowMatrix;row++){
    for(int col=0;colcolMatrix;col++){
    matrixData[rowMatrix][colMatrix] = matrixData[colMatrix][rowMatrix];
    }}
    trans = new Matrix(matrixData);
    return trans;
    }
    public Matrix multipleMatrix( Matrix m )
    {
    /*returns a reference to an object of the class Matrix,
    that contains the product of this matrix and matrix m. */
    m = new Matrix(matrixData);
    //Matrix var = matrixData[rowMatrix][colMatrix];
    for(int row=0;rowrowMatrix;row++){
    for(int col=0;colcolMatrix;col++){
    //trans[row][col] = getElement(row,col);
    }}
    return m;

    }
    public int diffMatrix( Matrix m )
    {
    /*returns the sum of the squared element-wise differences
    of this matrix and m ( reference to the formula in the description
    of assignment 5) */
    return 0;
    }
    public String toString( )
    {
    /* overloads the toString in Object */
    String output = " row = " + rowMatrix + " col="+colMatrix + "\n";

    for( int i=0; irowMatrix; i++)
    {
    for( int j=0; jcolMatrix; j++)
    output += " " + getElement(i,j) + " ";
    output += "\n";
    }
    return output;
    }
    }Second file

    public class Verify extends Object {
    public static void main( String args[] )
    {
    int[][] dataA = {{1,1,1},{2,0,1},{1,2,0},{4,0,0}}; // data of A
    int[][] dataB = {{1,2,2,0},{1,0,3,0},{1,0,3,4}}; // data of B
    Matrix matrixA = new Matrix(dataA);// matrix A
    System.out.println("Matrix A:"+matrixA);
    Matrix matrixB = new Matrix(dataB);// matrix B
    System.out.println("Matrix B:"+matrixB);

    // Calculate the left-hand matrix
    Matrix leftFormula = (matrixA.multipleMatrix(matrixB)).transposeMatrix();
    System.out.println("Left Side:"+leftFormula);
    // Calculate the right-hand matrix
    Matrix rightFormula = (matrixB.transposeMatrix()).multipleMatrix(matrixA.transposeMatrix());
    System.out.println("Right Side:"+rightFormula);

    // Calculate the difference between left-hand matrix and right-hand matrix
    // according to the formula in assignment description
    double diff = leftFormula.diffMatrix(rightFormula);
    if( diff 1E-6 ) // 1E-6 is a threshold
    System.out.println("Formula is TRUE");
    else
    System.out.println("Formula is FALSE");

    }
    }My basic aim is to verify the formula
    (A . B)' =B' . A' or {(A*B)tranpose = Btranspose * A transpose}Now My problem is that I have to run the verify class file and verify class file will call the matrix class and its methods when to do certain calculations (for example to find left formula it calls tranposematrix() and multipleMatrix();)
    How will I be able to get the matrix which is to be transposed in transposeMatrix method (in Matrix class)becoz in the method call there is no input for transposematrix() and only one input for multipleMatrix(matrix m).
    please peeople help me put in this.
    thanking in advance

    DB:2.64:Need Help In Trying To Understand Class Objects s7

    I need help on understanding following problem.I have two files for that, which are as follows:

    first file
    public class Matrix extends Object {
    private int matrixData[][];// integer array to store integer data
    private int rowMatrix;// number of rows
    private int colMatrix;// number of columns

    public Matrix( int m, int n )
    { /*Constructor: initializes rowMatrix and colMatrix,
    and creates a double subscripted integer array matrix
    of rowMatrix rows and colMatrixm columns. */
    rowMatrix = m;
    colMatrix = n;
    matrixData = new int[rowMatrix][colMatrix];
    }
    public Matrix( int data[][] )
    {/* Constructor: creates a double subscripted integer array
    and initilizes the array using values of data[][] array. */
    rowMatrix = data.length;
    colMatrix = data[0].length;
    matrixData = new int [rowMatrix][colMatrix];
    for(int i=0; irowMatrix; i++)
    for(int j=0; jcolMatrix; j++)
    matrixData[i][j] = data[i][j];
    }
    public int getElement( int i, int j)
    { /* returns the element at the ith row and jth column of
    this matrix. */
    return matrixData[i][j];
    }
    public boolean setElement( int x, int i, int j)
    {/* sets to x the element at the ith row and jth column
    of this matrix; this method should also check the
    consistency of i and j (i.e., if i and j are in the range
    required for subscripts; only in this situation the operation
    can succeed); the method should return true if the operation
    succeeds, and should return false otherwise.
    */

    for(i=0;irowMatrix;i++){
    for(j=0;jcolMatrix;j++){
    x = matrixData[i][j];
    }
    }
    if(irowMatrix jcolMatrix){
    return true;
    }
    else{
    return false;
    }
    }

    public Matrix transposeMatrix( )
    {/*returns a reference to an object of the class Matrix,
    that contains the transpose of this matrix. */
    Verify tata;
    Matrix trans;
    //Matrix var = matrixData[rowMatrix][colMatrix];
    for(int row=0;rowrowMatrix;row++){
    for(int col=0;colcolMatrix;col++){
    matrixData[rowMatrix][colMatrix] = matrixData[colMatrix][rowMatrix];
    }}
    trans = new Matrix(matrixData);
    return trans;
    }
    public Matrix multipleMatrix( Matrix m )
    {
    /*returns a reference to an object of the class Matrix,
    that contains the product of this matrix and matrix m. */
    m = new Matrix(matrixData);
    //Matrix var = matrixData[rowMatrix][colMatrix];
    for(int row=0;rowrowMatrix;row++){
    for(int col=0;colcolMatrix;col++){
    //trans[row][col] = getElement(row,col);
    }}
    return m;

    }
    public int diffMatrix( Matrix m )
    {
    /*returns the sum of the squared element-wise differences
    of this matrix and m ( reference to the formula in the description
    of assignment 5) */
    return 0;
    }
    public String toString( )
    {
    /* overloads the toString in Object */
    String output = " row = " + rowMatrix + " col="+colMatrix + "\n";

    for( int i=0; irowMatrix; i++)
    {
    for( int j=0; jcolMatrix; j++)
    output += " " + getElement(i,j) + " ";
    output += "\n";
    }
    return output;
    }
    }Second file

    public class Verify extends Object {
    public static void main( String args[] )
    {
    int[][] dataA = {{1,1,1},{2,0,1},{1,2,0},{4,0,0}}; // data of A
    int[][] dataB = {{1,2,2,0},{1,0,3,0},{1,0,3,4}}; // data of B
    Matrix matrixA = new Matrix(dataA);// matrix A
    System.out.println("Matrix A:"+matrixA);
    Matrix matrixB = new Matrix(dataB);// matrix B
    System.out.println("Matrix B:"+matrixB);

    // Calculate the left-hand matrix
    Matrix leftFormula = (matrixA.multipleMatrix(matrixB)).transposeMatrix();
    System.out.println("Left Side:"+leftFormula);
    // Calculate the right-hand matrix
    Matrix rightFormula = (matrixB.transposeMatrix()).multipleMatrix(matrixA.transposeMatrix());
    System.out.println("Right Side:"+rightFormula);

    // Calculate the difference between left-hand matrix and right-hand matrix
    // according to the formula in assignment description
    double diff = leftFormula.diffMatrix(rightFormula);
    if( diff 1E-6 ) // 1E-6 is a threshold
    System.out.println("Formula is TRUE");
    else
    System.out.println("Formula is FALSE");

    }
    }My basic aim is to verify the formula
    (A . B)' =B' . A' or {(A*B)tranpose = Btranspose * A transpose}Now My problem is that I have to run the verify class file and verify class file will call the matrix class and its methods when to do certain calculations (for example to find left formula it calls tranposematrix() and multipleMatrix();)
    How will I be able to get the matrix which is to be transposed in transposeMatrix method (in Matrix class)becoz in the method call there is no input for transposematrix() and only one input for multipleMatrix(matrix m).
    please peeople help me put in this.
    thanking in advance

  • RELEVANCY SCORE 2.63

    DB:2.63:Ssrs 2008 R2 - Matrix Column Group Page Break For Different Excel Spreadsheet Tab? d8


    Hi, I have SSRS 2008 R2 Visual Studio 2008 R2. Report has matrix on it. Matrix has row group by PostingDate and Column Group by : AccountCode. In Column group property,on Page Breaks tab, I selected Between each instance of a group. But when I export
    report to excel file, it does not create seperate excel spreadsheet tab for each column group by.

    Any idea how to add page break in matrix column group by to export in individual spreadsheet tab? Thanks.

    DB:2.63:Ssrs 2008 R2 - Matrix Column Group Page Break For Different Excel Spreadsheet Tab? d8

    Hi, I have below Matrix output:

    New York California Texas Nevada ..........
    January-2010 01-Jan-2010 50.00 32.98 54.90 988.43
    02-Jan-2010 423.00 23.38 850.88 82.90
    03-Jan-2010 454.03 654.11 232.20 872.82
    04-Jan-2010 43.00 899.99 89.44 53.22
    TOTAL 1224.00 1890.00 1899.10 1121.00
    February-2010 01-Feb-2010 23.00 898.00 55.10 76.00
    ......
    ......

    How can I add page break in matrix to export in individual spreadsheet tabs by State (column group)? Please can you post step-by-step guide for this? Thanks.

  • RELEVANCY SCORE 2.63

    DB:2.63:Column Length For Long Raw In 7.3.4 9j


    Any suggestions to find out the column length of a LONG RAW column, to get the average row size in Oracle 7.3.4

    Thanks.

    DB:2.63:Column Length For Long Raw In 7.3.4 9j

    The Member Feedback forum is for suggestions and feedback for OTN Developer Services. This forum is not monitored by Oracle support or product teams and so Oracle product and technology related questions will not be answered. We recommend that you post this thread to the Database - General forum. General Database Discussions

    OTN

  • RELEVANCY SCORE 2.63

    DB:2.63:How Can I Find Value In A Particular Column In Matrix Control In Rdlc File And Using In Another Column? 1s



    I am using Matrix control in my RDLC report.Report processing mode is Local.My Stored procedure returns 10 columns. Now I want to add 11th and 12th columns to matrix.

    I want to expression for11th column value as (10th column value - 9th column value) and for12th column value as (1st column value - 10th column value) .

    How can I find and get the values of 1st ,9th and 10th column values in matrix control so that I can write expressions for 11th and 12th columns?

    I want to do this in RDLC file only. I don't want to perform this in stored procedure.

    Please help.

    Regards,

    NSJ

    DB:2.63:How Can I Find Value In A Particular Column In Matrix Control In Rdlc File And Using In Another Column? 1s

    Hi NSJ,
    If I understand you correctly, these 10 columns are static in the matrix control, so you could add another two static columns, then type in the expression =Sum(Fields!10thDatafield.value)-Sum(Fields!9thDatafield.value) for 11th column, and type in the expression
    =Sum(Fields!1thDatafield.value)-Sum(Fields!10thDatafield.value) for 12th column.
    If you have any question, please feel free to ask.
    Thanks,
    Challen FuChallen Fu [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 2.63

    DB:2.63:How To Ensure That A Textbox Will Stay Alinged With A Matrix In Ssrs 2008? sm


    Hello All,
    I am very frustrated with this situation that I have at the moment regarding a matrix. My matrix is laid out and styled the way that I like and it works, however I need to add a title above it and i've chosen to do this with a separate textbox.
    The problem I now have is that when I run the report, the textbox may or may not be the same length as the matrix.
    What method can I use to ensure that my matrix will always line-up correctly with my textbox?
    In a very general way (screenshots are stupidly not allowed in this forum), here is what I am looking for:

    WEEKLY SELL-OUT
    Row Group Column title 1 Column title 2 Column title 3

    WEEKLY SELL-OUT is the title which I need. I've put a rectangle around the matrix and tried aligning them, but each time the data is refreshed the matrix may or may not be aligned with the WEEKLY SELL-OUT textbox.
    I've also tried putting a title within the left corner texbox within the matrix itself, however this is ugly and not what I want. I need it to be centered with the entire matrix and not just withing the textbox. Doing it this way does this to my matrix:
    WEEKLY SELL-OUT
    Row Group Column title 1 Column title 2 Column title 3

    Again this is not what I want. I want it to be centered and using the textboxes inside the matrix does not allow me to do that. Also, i'm not able to merge cells within a row in a matrix, only within a column.
    Surely there MUST be a way to do this properly - can someone help?

    DB:2.63:How To Ensure That A Textbox Will Stay Alinged With A Matrix In Ssrs 2008? sm

    Seemed like a good idea -- to embed the matrix inside the lower cell of a 1-column, 2-rowtable --but I couldn't get it to work.When attempting preview, it resulted in an error-- The tablix 'matrix1' has a detail member
    with inner members. Detail members can only contain static inner members. The matrix works fine outside of the table. I'm not sure if properties of the matrixor table could be adjusted to remedy the error. The 'CanGrow'
    property for the table is set to 'True'.

    UPDATE: It is critical to put the matrix in the
    Header cell, not the
    Details cell. Delete the Details row (cell).Create a new header row above the existing Header that contains the matrix in order to add a title and center it.

  • RELEVANCY SCORE 2.62

    DB:2.62:Maximum Allowed Text Length For Jtable Column mm


    Can you please help me with a JTable Doubt

    How do I set the Maximum Allowed Text Length for a Particular Column of a JTable?

    DB:2.62:Maximum Allowed Text Length For Jtable Column mm

    Thanks a lot mate. I used the following

    class MaximumLengthFilter extends DocumentFilter {

    public void replace(DocumentFilter.FilterBypass fb, int offset, int length,
    String text, AttributeSet attr) throws BadLocationException {
    if ((fb.getDocument().getLength() + length) 10)
    fb.replace(offset, length, text, attr);
    else
    Toolkit.getDefaultToolkit().beep();

    }
    }

  • RELEVANCY SCORE 2.62

    DB:2.62:Checkbox In A Matrix Column k1



    Hi everybody

    How can I load values in a checkbox in a Matrix?

    In screen painter, i have a matrix with two columns: one for task and anohter for comments.

    The task it has to be a checkbox with the values from ddbb but i haven't found how to do it in screen painter. I set:

    alias = U_...

    Databound = true

    displayDesc= true

    table= @name of table

    title = title

    Type = it_combo_box

    UniqueId= task

    But the checkbox don't load the values...

    Thanks

    Carles

    DB:2.62:Checkbox In A Matrix Column k1


    Hello Carles

    The val_On val_Off I don't believe is editable using ScreenPainter. You may have to open the srf file using another tool like Visual Studio (srf is actually an xml file). Below is a sample section of an srf file similar to the one you are looking for.

    specific caption="No Points" AffectsFormMode="1" val_on="Y" val_off="N"
    databind databound="1" table="Source Name" alias="Field Name" /
    /specific

  • RELEVANCY SCORE 2.62

    DB:2.62:Forum Faq: How Do I Achieve Column Break In A Matrix? 89


    SymptomAlthough you can set page break for column group in Reporting Services 2008, page breaks are ignored on column groups. Reference:http://msdn.microsoft.com/en-us/library/ms156434.aspxSolutionHere are some workarounds, available forboth Reporting Services 2005 and2008:Workaround 1Spread the columns from one matrix into several matrixes. You can first copy one matrix and then paste it into several ones you want. Then set the filter for each column group to make sure that the total columns length in one matrix just fit a pages width.Workaround 2The other method is to use a custom code.a.Please copy the following code to the custom code area:Dim FlagTable As System.Collections.HashtableDim Flag AS IntegerFunction MyFunc(ByVal NewValue As Object) As IntegerIf (FlagTable Is Nothing) ThenFlagTable = New System.Collections.HashtableEnd IfIf (NewValue Is Nothing) ThenNewValue = -End IfIf (Not FlagTable .Contains(NewValue )) ThenFlag =Flag 1FlagTable.Add(NewValue, nothing)End IfMyFunc = FlagEnd Functionb.Create a list in your report.Imagine thatthe column group of a matrix is grouped bythe field Column_Group, then set the detail group of list withthe expression like this:=Ceiling(Code.MyFunc(Fields!Column_Group.Value)/5)Note: This means the Max number of column in matrix will be five after you follow step C.c.Sort the dataset by column group field, and then drag the matrix into the list. Click Preview.Workaround 3Similar to the second method, you need to modify the dataset.a.Create an ID column for the column group in your dataset.For example,there isa datasetwith the following query:SELECT * FROM TableThe column group is grouped on the field Group1.Then, modify the query like this:SELECT *, Dense_Rank()OVER(order by Group1) AS ID FROM Tableb.Create a list in your report, set the detail group of the list with the Expression like this:=Ceiling(Fields!ID.Value/5)Note: This meansthat the Max number of column in matrix will be five after you followthe step C.c.Sort the dataset bythe column group and then drag the matrix into the list. Click Preview.

    DB:2.62:Forum Faq: How Do I Achieve Column Break In A Matrix? 89

    I have near about 30 matrics. so I need a paging. I did every thing as per this post and it really works for me.
    I have total four columns. On one page it should show three and the remaining one will be moved to next page.
    Problem occurs when in my first row i have 3 columns and in next page if I have one columns then it show proper on first page but on second page also it gives me three columns insted of one. the first column data is exactly what I have but in remaining two
    columns it shows some garbage data.
    I have data like below.

    Metric ColumnNoRowNo
    1 1
    1
    2 2
    1
    3 3
    1
    4 1
    2
    so while grouping i have a row parent group on RowNo and Column group on ColumnNo.
    can anyone please advice on this.

  • RELEVANCY SCORE 2.61

    DB:2.61:Cfl For Matrix xx



    I have loaded data in the matrix.The cells in the matrix are editable.I want to set cfl for the column item in the matrix.

    DB:2.61:Cfl For Matrix xx


    Petr,

    I have solved the problem.I modified the datasource from which the matrix is loaded.Then I reloaded the matrix.The code is as,

    SBO_Application.Forms.Item("Quality Analysis").DataSources.DataTables.Item("MyDataTable").SetValue("U_Item_Code", pVal.Row - 1, val)

    LoadMatrix()

    Thanks for spending u r valuable time in solving the problem.

    Regards,

    Dilip Kumbhar

  • RELEVANCY SCORE 2.61

    DB:2.61:Fixed Velocity af


    I am looking for a way to fix the velocity of all the notes I have in the Matrix Editor just as you an fix the note length, can anyone help?

    DB:2.61:Fixed Velocity af

    It might be worth expanding on this slightly.

    Once you have the transform window open you can add your own user sets for the more popular transform commands you do by selecting **Create User set** from the drop down menu top left.

    Say you are always quantizing to 1/16, fixing note velocities and and fixing note lengths a certain way, you can program your own user set to do this command in one go. You just select the commands you want to do, rename the user set (by double clicking the 'transform Parameter Set' drop down menu, top left) and it will always appear in your transform window.

    You can create a whole load of these different commands depending on what you want to do and it can save you a lot of time in the matrix editor!

    Also, its worth noting the key command for the transform window or setting up your own for quick access.

    Hope this little tip helps you out

    Here is an example pic:

    http://goldenscan.com/pics/Picture2.png

  • RELEVANCY SCORE 2.61

    DB:2.61:Matrix With Info Columns From Different Table 7x


    Hi, how can i manage to have a column in a matrix that doesn't represent a value of the table the other columns are using?For example, i have a matrix and this matrix has values of the UDT (@Table) and one column contains the projectcode. now i want one column in my matrix to show the project name of the OPRJ. how can i manage that, so that the value of this column in the matrix changes when i change the value of the other column with the project code?best regardsPhilipp

    DB:2.61:Matrix With Info Columns From Different Table 7x

    This is example of function what create form by loading xml file.In my case it was a read-only column, only for code description.
    dbdatasources
    action type="add"
    datasource tablename="@TABLE_NAME_HERE" /
    /action
    /dbdatasources
    userdatasources
    action type="add"
    datasource uid="uPrjName" type="9" size="250" /
    /action
    /userdatasources

  • RELEVANCY SCORE 2.61

    DB:2.61:Proble With Datatable ... Executequery 81



    Hi all,

    I have a matrix with 2 column for example DocNum and DocDate.

    I fill matrix with a DataTable datasource

    the first executequery return me a correct format of date

    102 | 22.08.2006

    103 | 23.08.2006

    when i try to refill the matrix with another call of ExecuteQuery ... the format in a matrix change like this..

    102 | 20060822

    103 | 20060823

    Thanks a lot

    DB:2.61:Proble With Datatable ... Executequery 81


    Hey Dimitri

    In Matrix (or any other items), the way data is displayed is determined by the binded data source

    for dates:

    datasource value is 20060822

    and displayed value should be 22.08.2006

    Maybe your binding to the fields is lost when doing the second executequery

    regards

    Emmanuel

  • RELEVANCY SCORE 2.61

    DB:2.61:Display Value In Matrix sj



    hi ,

    i created matrix in screen painter. it includes 3 columns unit of measurement, length, width.

    i want to set values to length and width manually.

    when the form is loaded the length and width should appear in matrix

    Regards,

    Puneeth

    DB:2.61:Display Value In Matrix sj


    I make copy paste too quick , actually is it

    dim oEdit as As SAPbouiCOM.EditText

    dim oMatrix as SAPbouiCOM.Matrix

    oMatrix = oForm.Items.Item("mtxUID").Specific

    oEdit = oMatrix.Columns.Item("colUID").Cells.Item(insertrow).Specific

    oEdit.value = "1"

  • RELEVANCY SCORE 2.61

    DB:2.61:Searchuser From Displayname cf



    Hello,

    Does anyone know of a way to search for a users UniqueID from a DisplayName. I have tried using the SearchUser method but this only allows for you to search for a user using their UniqueID.

    Thanks in advance.

    DB:2.61:Searchuser From Displayname cf


    Have you filled the PDK for .NET survey yet? You can win an MP3 player!!!

    http://feedback.sap.com/efs/vote?campaign=39c7899ecca40a6709a638bd0388ac8borg=332

  • RELEVANCY SCORE 2.61

    DB:2.61:Matrix Limitation In Oracle km


    Hi,

    I encountered this problem in my matrix report implementation:

    I have a matrix which has a column with fixed width. The row height was initially fixed but I had to change it so that the height is now variable. Problem is, I can't seem to make the column height for each row expand to follow the height of each row (which varies). The height for the columns seem to be fixed no matter what I do. see, I need the height to expand so that I can put a border around every cell which matches the height of the row and column. Is this really an oracle limitation? Thanks

    by the way, if you're interested, here's how it looks like:

    ___________________________
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf --------
    ___________________________
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf --------
    ___________________________

    I want it to look like this:
    ___________________________
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf |______|___
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf |______|___

    DB:2.61:Matrix Limitation In Oracle km

    Hi,

    I encountered this problem in my matrix report implementation:

    I have a matrix which has a column with fixed width. The row height was initially fixed but I had to change it so that the height is now variable. Problem is, I can't seem to make the column height for each row expand to follow the height of each row (which varies). The height for the columns seem to be fixed no matter what I do. see, I need the height to expand so that I can put a border around every cell which matches the height of the row and column. Is this really an oracle limitation? Thanks

    by the way, if you're interested, here's how it looks like:

    ___________________________
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf --------
    ___________________________
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf --------
    ___________________________

    I want it to look like this:
    ___________________________
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf |______|___
    alkjf;ajfa;jfd |matrix|
    adfafdafdadf |______|___

  • RELEVANCY SCORE 2.61

    DB:2.61:Borders In Matrix Report With Multiline Column d8


    I need to design matrix report with border lines grid sorounding all cells. But text in the leading column may get multiline and the coresponding matrix cells stays singleline, which creates an efect of additional empty row (see below). Is it possible to connect the matrix cells heigth with leading column or at least to get the border lines ok.

    ------------
    |row1|m1|n1|
    ------------
    |row2|m2|n2|
    |....|--|--|
    |row2|..|..| -efect of additional empty row
    ------------
    |row3|m3|n3|
    ------------
    where . is an empty space

    Many thanks for any advice,
    Jacek

    DB:2.61:Borders In Matrix Report With Multiline Column d8

    I'm assuming you only need the lines to expand vertically since the top and bottom can be set by changing the border attribute on the matrix frame itself.

    If this is the case, you should be able to use the boilerplate lines and set the "Line Stretch with Frame" property to make the lines expand as the frame surrounding these three objects as you would in a normal Tabular report. This will get rid of your "additional empty row" effect.

  • RELEVANCY SCORE 2.61

    DB:2.61:Create Cfl In Matrix 1m


    Dear Experts How to create CFL in matrix column for add-on modules ,Is possible to create. how to create CFL in matrix and i need step for this

    DB:2.61:Create Cfl In Matrix 1m

    Hi,Try thisIf (pVal.Before_Action = True) Then Dim oitem1 As SAPbouiCOM.Item oitem1 = oForm.Items.Item("57") radio3 = oitem1.Specific radio1 = oForm.Items.Item("58").Specific radio2 = oForm.Items.Item("56").Specific If radio1.Selected = True Then doctype = "A" End If Else If doctype = "A" Then Debug.Print("A") If pVal.ItemUID = "71" Then Debug.Print("71") Dim text As SAPbouiCOM.EditText mat = oForm.Items.Item("71").Specific text = mat.Columns.Item("UDF").Cells.Item(pVal.Row).Specific AddChooseFromList() text.ChooseFromListUID = "CFL1" text.ChooseFromListAlias = "Code" End If End Ifend ifMethod AddChooseFromList() is as follows:Private Sub AddChooseFromList() Try Dim oCFLs As SAPbouiCOM.ChooseFromListCollection oCFLs = oForm.ChooseFromLists 'this part for CFL1 Dim oCFL As SAPbouiCOM.ChooseFromList Dim oCFLCreationParams As SAPbouiCOM.ChooseFromListCreationParams oCFLCreationParams = SBO_Application.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams) ' Adding CFL, one for the button and one for the edit text. oCFLCreationParams.MultiSelection = False oCFLCreationParams.ObjectType = "UDT" oCFLCreationParams.UniqueID = "CFL1" oCFL = oCFLs.Add(oCFLCreationParams) Catch MsgBox(Err.Description) End Try End SubHope it helpsThanks

  • RELEVANCY SCORE 2.61

    DB:2.61:How To Show Item Code In Matrix Form??? 98


    Hi all, In my addon i have a matrix....in the first column of the matrix i want to display the Item code from the Item master data..when i press tab also i want to show the CFL for that....can anybody suggest me some ideas for this???regards,shangai.

    DB:2.61:How To Show Item Code In Matrix Form??? 98

    hi yatsea, Thanks it solved my problem..regards,shangai.

  • RELEVANCY SCORE 2.61

    DB:2.61:Sas Va Specify Length Field For Derived Column ac



    for desiHI,

    How to specify length of derived column in SAS VA. It is taking default 8 Character.

    Thanks

    DB:2.61:Sas Va Specify Length Field For Derived Column ac


    Hi,

    Can you please explain what you mean by derived column and also how you are loading the data into SAS Visual Analytics? If you are loading the data into SAS Visual Analytics via the data builder you can change the length of a character column by specifying its length. You can see examples of this in Wendy McHenry blog post on SAS Visual Analytics: loading data into memory As per the screenshot you can see there are columns defined as a length of 10, 3 5 characters in the output table.

    Once a table is loaded into memory, the length of the field cannot be changed. You can change the format width though as Sam points out and for new calculated items you create.

    Let us know if we have helped with your question and if not, please provide further details so we have a better understanding on what you are after.

    Kind Regards,

    Michelle

  • RELEVANCY SCORE 2.61

    DB:2.61:Deselect Column mz



    hi

    In one of my Custom form i have a matrix. when i click matrix header, the column is selected. how can i deselect the column ?

    DB:2.61:Deselect Column mz


    You may deselect a column by either clicking that column while holding the Ctrl key, or by clicking on the top left square, which will deselect everything.

  • RELEVANCY SCORE 2.61

    DB:2.61:How To Get Custom Property Of A Folder 3m


    Hello Anyone,
    I've created a custom content type folder and attached a custom column called Location Name.
    How do I retrieve the value programmatically?
    **** part of code *********
    SPFolder oFolder = web.GetFolder(uniqueId);
    string locationName = (string)oFolder.GetProperty(Location Name); for sure this won't work
    OR is it somewhere here?
    oFolder.Item.Fields[Location Name];

    Please anyone.
    ThanksM Sariman RKO Business Solutions Inc.

    DB:2.61:How To Get Custom Property Of A Folder 3m

    Thanks a lotM Sariman RKO Business Solutions Inc.

  • RELEVANCY SCORE 2.60

    DB:2.60:Help With A Select Statement. s3


    Hi, I am trying to write a select statement but having difficulty achieving the desired result with my limited knowledge of TSQL. I would appreciate any help on offer either on a possible
    resolve or to point me in the right direction.
    I am using SQL Server 2008R2
    Microsoft SQL Server Management Studio
    10.50.3720.0
    The following table resides within an ODS, the ODS is maintained by a third party. This table has several levels; Admission (7), transfer (10), Suspension (8), Reinstatement (9) and Discharge
    (11). Unfortunately this table shows these levels for two types of activity, staff episodes and department episodes.
    My main objective is to determine the activity type, a transfer count of said activity, its start/end dates and finally depending on the activity type the staff or dept. from/to changes.
    Each collection of activity type must ignore one another completely and determine the transfer start date/end dates appropriately. In addition to these rules I must allow for any suspensions and reinstatements in both types of activity (there can be several
    suspension/reinstatement episodes within a spell of activity). It would be advantageous to show the suspension/reinstatements episodic length within a particular transfer episode.

    Table Structure and example result
    SELECT [UniqueID]

    ,[EpisodeNo]

    ,[Level]

    ,[ActivityDate]

    ,[EpisodeType_Code]

    ,[Staff_Code]

    ,[Dept_Code]

    ,[Site_Code]
    FROM [Activity]
    WHERE [UniqueID]
    = '000001'
    AND [EpisodeNo] =
    '8'
    Results
    SELECT
    * INTO Activity
    FROM
    (
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Admission' AS [Level],
    N'1753-01-27 16:00' AS [ActivityDate],
    N'7' AS [EpisodeType_Code],
    N'1' AS [Staff],
    N'QAA' AS [Dept],
    N'Q' AS [Site]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer' AS [Level],
    N'1753-01-27 23:40' AS [ActivityDate],
    N'10' AS [EpisodeType_Code],
    N'1' AS [Staff],
    N'QB' AS [Dept],
    N'Q' AS [Site]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer' AS [Level],
    N'1753-01-28 20:00' AS [ActivityDate],
    N'10' AS [EpisodeType_Code],
    N'2' AS [Staff],
    N'QC' AS [Dept],
    N'Q' AS [Site]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer' AS [Level],
    N'1753-02-17 13:00' AS [ActivityDate],
    N'10' AS [EpisodeType_Code],
    N'2' AS [Staff],
    N'QD' AS [Dept],
    N'Q' AS [Site]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer' AS [Level],
    N'1753-02-17 13:30' AS [ActivityDate],
    N'10' AS [EpisodeType_Code],
    N'2' AS [Staff],
    N'QC' AS [Dept],
    N'Q' AS [Site]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Suspension' AS [Level],
    N'1753-02-19 15:10' AS [ActivityDate],
    N'8' AS [EpisodeType_Code],
    N'2' AS [Staff],
    N'QC' AS [Dept],
    N'Q' AS [Site]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Reinstatement' AS [Level],
    N'1753-02-20 16:00' AS [ActivityDate],
    N'9' AS [EpisodeType_Code],
    N'2' AS [Staff],
    N'QC' AS [Dept],
    N'Q' AS [Site]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Discharge' AS [Level],
    N'1753-02-23 12:57' AS [ActivityDate],
    N'11' AS [EpisodeType_Code],
    N'2' AS [Staff],
    N'QC' AS [Dept],
    N'Q' AS [Site]
    ) t;
    SELECT [UniqueID], [EpisodeNo],
    [Level], [ActivityDate], [EpisodeType_Code], [Staff], [Dept], [Site]
    FROM Activity

    DROP
    TABLE Activity
    GO
    Ihave written the following query.
    SELECT ad1.[UniqueID]

    ,ad1.[EpisodeNo]

    ,ad1.[EpisodeType_Code]
    AS 'FromEpisodeTypeCode'

    ,ad2.[EpisodeType_Code]
    AS 'ToEpisodeTypeCode'

    ,ad1.[Level]
    '/'
    ad2.[Level] AS
    'EpisodeTypeDescription'

    ,ad1.[ActivityDate]
    AS 'FromDate'

    ,ad2.[ActivityDate]
    AS 'ToDate'

    ,ad1.[Staff_Code]
    AS 'FromStaff'

    ,ad2.[Staff_Code]
    AS 'ToStaff'

    ,ad1.[Dept_Code]
    AS 'FromDept'

    ,ad2.[Dept_Code]
    AS 'ToDept'

    ,(CASE
    WHEN (ad1.[Staff_Code]
    ad2.[Staff_Code])

    OR (ad2.[EpisodeType_Code]
    = '11')
    THEN 1 ELSE 0
    END )AS
    'StaffEpisode'
    ,(CASE
    WHEN (ad1.[Dept_Code]
    ad2.[Dept_Code])

    OR (ad2.[EpisodeType_Code]
    = '11')
    THEN 1 ELSE 0
    END ) AS
    'DeptStay'

    ,DATEDIFF(HH, ad1.[ActivityDate], ad2.[ActivityDate])
    AS 'LOS_Hours'

    ,DATEDIFF(DD, ad1.[ActivityDate], ad2.[ActivityDate])
    AS 'LOS_Days'

    ,ad1.[Site_Code]
    AS 'FromSite'

    ,ad2.[Site_Code]
    AS 'ToSite'
    FROM [Activity]
    AS ad1
    INNER
    JOIN [Activity] ad2 ON ad2.[UniqueID]
    = ad1.[UniqueID]
    AND ad2.[EpisodeNo]
    = ad1.[EpisodeNo]
    AND ad2.[ActivityDate]
    =

    (SELECT
    TOP 1 ad3.[ActivityDate]
    FROM [Activity] AS ad3

    WHERE ad3.[UniqueID]
    = ad1.[UniqueID]
    AND ad3.[EpisodeNo]
    = ad1.[EpisodeNo]
    AND ad3.[ActivityDate]
    ad1.[ActivityDate]
    ORDER BY ad3.[ActivityDate])

    WHERE ad1.[UniqueID]
    = '000001'
    AND ad1.[EpisodeNo]
    = '8'
    ORDER
    BY ad1.[UniqueID], ad1.[EpisodeNo], ad1.[ActivityDate]
    Reults
    SELECT
    * INTO Activity
    FROM
    (
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Start/Transfer' AS [EpisodeTypeDescription],
    N'1753-01-27 16:00' AS [FromDate],
    N'1753-01-27 23:40' AS [ToDate],
    N'7' AS [FromEpisodeTypeCode],
    N'10' AS [ToEpisodeTypeCode],
    N'Q' AS [FromSite],
    N'Q' AS [ToSite],
    N'1' AS [FromStaff],
    N'1' AS [ToStaff],
    N'QAA' AS [FromDept],
    N'QB' AS [ToDept],
    N'0' AS [StaffEpisode],
    N'1' AS [DeptStay],
    N'7' AS [LOS_Hours],
    N'0' AS [LOS_Days]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer/Transfer' AS [EpisodeTypeDescription],
    N'1753-01-27 23:40' AS [FromDate],
    N'1753-01-28 20:00' AS [ToDate],
    N'10' AS [FromEpisodeTypeCode],
    N'10' AS [ToEpisodeTypeCode],
    N'Q' AS [FromSite],
    N'Q' AS [ToSite],
    N'1' AS [FromStaff],
    N'2' AS [ToStaff],
    N'QB' AS [FromDept],
    N'QC' AS [ToDept],
    N'1' AS [StaffEpisode],
    N'1' AS [DeptStay],
    N'21' AS [LOS_Hours],
    N'1' AS [LOS_Days]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer/Transfer' AS [EpisodeTypeDescription],
    N'1753-01-28 20:00' AS [FromDate],
    N'1753-02-17 13:00' AS [ToDate],
    N'10' AS [FromEpisodeTypeCode],
    N'10' AS [ToEpisodeTypeCode],
    N'Q' AS [FromSite],
    N'Q' AS [ToSite],
    N'2' AS [FromStaff],
    N'2' AS [ToStaff],
    N'QC' AS [FromDept],
    N'QD' AS [ToDept],
    N'0' AS [StaffEpisode],
    N'1' AS [DeptStay],
    N'473' AS [LOS_Hours],
    N'20' AS [LOS_Days]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer/Transfer' AS [EpisodeTypeDescription],
    N'1753-02-17 13:00' AS [FromDate],
    N'1753-02-17 13:30' AS [ToDate],
    N'10' AS [FromEpisodeTypeCode],
    N'10' AS [ToEpisodeTypeCode],
    N'Q' AS [FromSite],
    N'Q' AS [ToSite],
    N'2' AS [FromStaff],
    N'2' AS [ToStaff],
    N'QD' AS [FromDept],
    N'QC' AS [ToDept],
    N'0' AS [StaffEpisode],
    N'1' AS [DeptStay],
    N'0' AS [LOS_Hours],
    N'0' AS [LOS_Days]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Transfer/Suspension' AS [EpisodeTypeDescription],
    N'1753-02-17 13:30' AS [FromDate],
    N'1753-02-19 15:10' AS [ToDate],
    N'10' AS [FromEpisodeTypeCode],
    N'8' AS [ToEpisodeTypeCode],
    N'Q' AS [FromSite],
    N'Q' AS [ToSite],
    N'2' AS [FromStaff],
    N'2' AS [ToStaff],
    N'QC' AS [FromDept],
    N'QC' AS [ToDept],
    N'0' AS [StaffEpisode],
    N'0' AS [DeptStay],
    N'50' AS [LOS_Hours],
    N'2' AS [LOS_Days]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Suspension/Reinstatement'
    AS [EpisodeTypeDescription],
    N'1753-02-19 15:10' AS [FromDate],
    N'1753-02-20 16:00' AS [ToDate],
    N'8' AS [FromEpisodeTypeCode],
    N'9' AS [ToEpisodeTypeCode],
    N'Q' AS [FromSite],
    N'Q' AS [ToSite],
    N'2' AS [FromStaff],
    N'2' AS [ToStaff],
    N'QC' AS [FromDept],
    N'QC' AS [ToDept],
    N'0' AS [StaffEpisode],
    N'0' AS [DeptStay],
    N'25' AS [LOS_Hours],
    N'1' AS [LOS_Days]
    UNION ALL
    SELECT
    N'000001' AS [UniqueID],
    N'8' AS [EpisodeNo],
    N'Reinstatement/Finish' AS [EpisodeTypeDescription],
    N'1753-02-20 16:00' AS [FromDate],
    N'1753-02-23 12:57' AS [ToDate],
    N'9' AS [FromEpisodeTypeCode],
    N'11' AS [ToEpisodeTypeCode],
    N'Q' AS [FromSite],
    N'Q' AS [ToSite],
    N'2' AS [FromStaff],
    N'2' AS [ToStaff],
    N'QC' AS [FromDept],
    N'QC' AS [ToDept],
    N'1' AS [StaffEpisode],
    N'1' AS [DeptStay],
    N'68' AS [LOS_Hours],
    N'3' AS [LOS_Days]
    ) t;
    SELECT [UniqueID],[EpisodeNo],[FromEpisodeTypeCode],[ToEpisodeTypeCode],[EpisodeTypeDescription],[FromDate],[ToDate],[FromStaff],[ToStaff],[FromDept],[ToDept],[StaffEpisode],[DeptStay],[LOS_Hours],[LOS_Days],[FromSite],[ToSite]
    FROM Activity

    DROP
    TABLE Activity
    GO
    This provides an indicator and all required information for each activity type. Unfortunately i'm still at a loss.

    How do Iseparate each activity type and the placement of corrected/amended dates for transfers.
    How to handle the suspension/reinstatement episodes and the required amendments to transfer dates and calculation of days.

    Any help in this matter would be gratefully received.
    Thanks in advance.
    Stephen

    DB:2.60:Help With A Select Statement. s3

    Dear Celko, thanks for your thoughts and the time it took you to write your many comments.

    I agree that the DDL is the problem and your constructive criticisms are welcome.

    Thanks also for the links and suggested reading.
    Regards
    Stephen

  • RELEVANCY SCORE 2.60

    DB:2.60:Bold Borders For Grouping Rows Of Matrix Column Of Matrix Report ak


    Hi,
    I have a report to display Bold Borders for each different Grouping records. Here i am using Matrix report. I am able to bring the Bold Borders for each Row Group based on Top Border width to 2pt. with the below expression,
    =Iif(Fields!DrugClass.Value = Previous(Fields!DrugClass.Value),1pt,2pt)
    But i am not able to give the Previous Expression in Matrix Column, dynamic columns, says Use of Aggregate Function inside the Matrix Cell within matrix2 is not supported.
    Anyway to achieve this?

    Regards,
    Fazlu

    DB:2.60:Bold Borders For Grouping Rows Of Matrix Column Of Matrix Report ak

    Hi Fazlu,
    In Reporting Services 2008 or the later versions, the Previous function is supported in matrix data region. For the Previous(expression, scope) function, if the expression does not contain an aggregate, the Previous function defaults to the current scope
    for the report item. In this issue, the default scope of the matrix detail cells are the “DrugClass” row group and the column group. However, the previous function whose expression has no aggregate is not supported in a scope which has two groups.

    For more information about the Previous function, please see:
    Previous Function
    If you have any questions, please feel free to let me know.
    Regards,
    Mike Yin

  • RELEVANCY SCORE 2.60

    DB:2.60:Matrix Multiplication Of (M,N) X (N,P) mj


    hi guys. i have a problem with matrix multiplication. the code i have here wworks fine with square matrices eg (2,2) x (2,2) but have problems when i wan to multiply matrices of different dimensions such as (3,2) x (2,2). below is the code. the contents of the two files that im trying to multiply is listed right at the end and im trying to multiply matrix1 with matrix. thanks guys


    import java.io.*;
    import java.util.Scanner;

    class Matrix
    {
    double[][] element;
    }
    public class Multiply
    {
    public double[][] m1,m2,m3;
    public String fileName1,fileName2;

    public static void main(String[] args)
    {
    System.out.println("*******************");
    System.out.println(" Multiply ");
    System.out.println("*******************");
    System.out.println();

    Multiply m = new Multiply();

    System.out.println("Enter the first file name:");
    m.fileName1 = m.fromKeyboard();
    m.m1 = m.readFromFile(m.fileName1);
    //start of 2nd file operation
    //enter second file name
    System.out.println("Enter the second file name:");
    m.fileName2 = m.fromKeyboard();
    m.m2 = m.readFromFile(m.fileName2);

    m.m3 = m.doMultiplication(m.m1,m.m2);
    char times = '*';
    m.printResult(m.m1, m.m2, m.m3, times);
    System.out.println(" ");
    System.out.println("Multiplication complete. Back to main menu");
    System.out.println(" ");
    }

    //method to read input entered by user for this case the name of the txt files
    //which contains the matrices
    public String fromKeyboard()
    {
    BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

    String input = " ";

    try
    {
    input = br.readLine();
    }
    catch(IOException io)
    {
    System.out.println(io);
    }

    return input;
    }

    //method read the matrices from txt files
    public double[][] readFromFile(String fileName1)
    {
    System.out.println("File name is "+fileName1);

    Matrix mat= null;

    try
    {
    File f1 = new File(fileName1);
    Scanner input = new Scanner(f1);

    String v1;

    v1=input.next();
    v1=input.next();
    v1=input.next();

    int row1 = input.nextInt();
    System.out.println("file has "+row1+" rows");
    v1=input.next();
    v1=input.next();
    int column1 = input.nextInt();
    System.out.println("file has "+column1+" columns");
    mat = new Matrix();
    mat.element = new double[row1][column1];

    for(int i=0;imat.element.length;i++)
    {
    for(int j=0; jmat.element.length; j++)
    {
    mat.element[i][j] = input.nextInt();
    //System.out.println("the element array is "+mat.element[i][j]);
    }

    }
    }
    catch(IOException io)
    {
    System.out.println(io);
    //doMenu(1);

    }
    return mat.element;
    }
    //multiplication process
    public double[][] doMultiplication(double[][] a1, double[][]a2)
    {
    //get wats the dimension of the matrices first
    int row1,row2, column1, column2;
    double[][] m3 = null;
    double result = 0.0;

    row1 = a1.length;
    column1 = a1[0].length;
    row2 = a2.length;
    column2 = a2[0].length;
    System.out.println("row is "+row1);
    System.out.println("column is "+column2);

    m3 = new double[row1][column2];

    System.out.println("multiply length "+m3.length);

    try
    {

    if (column1 != row2)
    System.out.println("row and column sizes do not match");

    //double [][] product = new double[a.rows][b.cols];

    for (int i = 0; i row1; ++i)
    {
    for (int j = 0; j column2; ++j)
    {
    m3[i][j] = 0.0;
    for (int k = 0; k column1; ++k)
    {
    m3[i][j] += m1[i][k]*m2[k][j];
    }
    }
    }

    }
    catch(ArrayIndexOutOfBoundsException ex){
    System.out.println(ex);
    }

    return m3;
    }

    //print results on screen
    public void printResult(double[][]m1, double[][]m2, double[][]m3, char operation)
    {
    for(int i = 0; im1.length; i++)
    {
    for(int j = 0; jm1[i].length; j++)
    System.out.print(" "+m1[i][j]);

    if(i == m1.length/2)
    System.out.print(" "+operation+" ");
    else
    System.out.print(" ");

    for(int j=0; jm2[i].length; j++)
    System.out.print(" "+m2[i][j]);

    if(i == m1.length/2)
    System.out.print(" = ");
    else
    System.out.print(" ");

    for(int j = 0; jm3[i].length; j++)
    System.out.print(" "+m3[i][j]);

    System.out.println("");

    }
    }
    }

    matrix1
    rows = 3
    cols = 2

    1 2
    2 4
    1 1
    /matrix1

    matrix
    rows = 2
    cols = 2

    1 2
    2 4
    /matrix

    DB:2.60:Matrix Multiplication Of (M,N) X (N,P) mj

    thanks jasu00 and everyone. finally managed to solve it with ur comments and replies! :)

  • RELEVANCY SCORE 2.60

    DB:2.60:Need Explaination Of Simple Matrix Code?!?!?! Thx 8k


    Can someone plz explain this simple code to me!?!? im a noob.

    I know that this code cycles through all the rows columns of the given
    matrix, but i get completely lost at this part:

    s[row][col] = m[row + theRow][col + theCol] ;

    Regards,
    Slvr99

    this code takes a matrix of integers M, and a
    row and column index, and returns a new matrix that is the lower
    right sub-matrix of M formed from that position. The header
    of the method is as follows:public static int[][] submatrix( int[][] m, int theRow, int theCol )
    {
    int[][] s; // RESULT: the submatrix of matrix m
    int sRows; // INTERMEDIATE : number of rows in s
    int sCols; // INTERMEDIATE : number of columns in s
    int row; // INTERMEDIATE: index for row position in s
    int col; // INTERMEDIATE: index for column position in s
    sRows = m.length - theRow;
    sCols = m[0].length - theCol;
    s = new int[sRows][sCols];
    for ( row = 0; row sRows; row = row + 1 )
    {
    for ( col = 0; col sCols; col = col + 1 )
    {
    s[row][col] = m[row + theRow][col + theCol] ;
    }
    }
    return s;
    }

    DB:2.60:Need Explaination Of Simple Matrix Code?!?!?! Thx 8k

    It copies all the values as if [theRow, theCol] were one corner of the origin of matrix.
    I suggest you try running this in a debugger and then you can see what it does line by line.

  • RELEVANCY SCORE 2.60

    DB:2.60:How Can I Pass Arguments Of Class T Constructor When Writing Vector B(10); aa



    Hello,

    I'm trying to create an array of Matrices. Matrix is defined in third party ARPREC Library:

    template
    class matrix : public matrix_base {
    protected:
    matrix (matrix a) { }
    public:
    matrix(int n0, int m0 = 1) : matrix_base(n0, m0) {
    matrix_base::elements = new T[m0 * n0];
    }

    ~matrix() {
    delete [] matrix_base::elements;
    }
    };

    Please note that the constructor of the class matrix takes the dimension of the matrix as input. When I try to build a vector (using STL Vector class) of length 10 of such matrices:

    vector matrix b(10);
    the compiler gives me:

    error: no instance of constructor "matrix::matrix" matches the argument list
    vector(size_type __n, const value_type __value = value_type(),
    ^
    detected during instantiation of "std::vector_Tp, _Alloc::vector(size_t={unsigned long}, const _Tp , const _Alloc ) [with _Tp=matrix, _Alloc=std::allocator]"

    Of course, the compiler is right. There is no matrix::matrix constructor. There is just matrix::matrix (n,m) constructor.

    So the question is
    How can I tell to Vector which constructor (or which arguments to the constructor) should it take?

    Please notice that I have a workaround:

    vector matrix b;
    b.reserve(10);
    matrix m(1000,1000);
    m(i,j)=func(i,j); //for all i and j
    b.push_back(m);

    What I don't like about this solution is that b.push_back(m) will copy matrix m to the vector b. So I fill up the matrix m and copy it's contents to the vector. Please note that constructor matrix m(1000,1000); just allocates memory space but will leave the memory uninitialized. So the solution with

    vector matrix b(10);
    would be much more efficient since it would just call constructor 10 times (just allocating memory) and enabling me to directly write into this memory (rather than copying it from matrix m).

    Does anybody has an idea how can pass arguments of class T constructor when writing
    vector T b(10); ? Any hint would be highly appreciated.

    Thanks a lot!
    Jiri

    DB:2.60:How Can I Pass Arguments Of Class T Constructor When Writing Vector B(10); aa


    Hello,

    I'm trying to create an array of Matrices. Matrix is defined in third party ARPREC Library:

    template
    class matrix : public matrix_base {
    protected:
    matrix (matrix a) { }
    public:
    matrix(int n0, int m0 = 1) : matrix_base(n0, m0) {
    matrix_base::elements = new T[m0 * n0];
    }

    ~matrix() {
    delete [] matrix_base::elements;
    }
    };

    Please note that the constructor of the class matrix takes the dimension of the matrix as input. When I try to build a vector (using STL Vector class) of length 10 of such matrices:

    vector matrix b(10);
    the compiler gives me:

    error: no instance of constructor "matrix::matrix" matches the argument list
    vector(size_type __n, const value_type __value = value_type(),
    ^
    detected during instantiation of "std::vector_Tp, _Alloc::vector(size_t={unsigned long}, const _Tp , const _Alloc ) [with _Tp=matrix, _Alloc=std::allocator]"

    Of course, the compiler is right. There is no matrix::matrix constructor. There is just matrix::matrix (n,m) constructor.

    So the question is
    How can I tell to Vector which constructor (or which arguments to the constructor) should it take?

    Please notice that I have a workaround:

    vector matrix b;
    b.reserve(10);
    matrix m(1000,1000);
    m(i,j)=func(i,j); //for all i and j
    b.push_back(m);

    What I don't like about this solution is that b.push_back(m) will copy matrix m to the vector b. So I fill up the matrix m and copy it's contents to the vector. Please note that constructor matrix m(1000,1000); just allocates memory space but will leave the memory uninitialized. So the solution with

    vector matrix b(10);
    would be much more efficient since it would just call constructor 10 times (just allocating memory) and enabling me to directly write into this memory (rather than copying it from matrix m).

    Does anybody has an idea how can pass arguments of class T constructor when writing
    vector T b(10); ? Any hint would be highly appreciated.

    Thanks a lot!
    Jiri

  • RELEVANCY SCORE 2.60

    DB:2.60:Find An Event With A Specific Uid Using Exchange Web Services 2010 sp


    I am accessing Exchange Server API through code to create an appointment. I am able to add an appointment in ES but I am facing an issue to fetch existing appointments in order to update or delete those appointments.
    My understanding is that providing UniqueId while binding appointment object with the service is standard method to find existing appointments. Unfortunately I can't use UniqueId in my SharePoint application as I have hundreds of existing appointments without
    UniqueId stored. So it is impossible for me delete any existing appointment using UniqueId. I can fetch new appointments by storing UniqueId as well in the list but I am not sure about existing on.
    So I am wondering if it is possible to find an existing appointment in Exchange Server using UID instead of UniqueId?
    Here is simplest form of my implementation:
    ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2010_SP1);
    service.Credentials = new WebCredentials(test, test, acme);
    service.Url = new Uri(https://acme.com/EWS/Exchange.asmx);

    Appointment appointment = new Appointment(service);
    String UID = D09F3FF6-1461-414C-89E8-C05BC3B66A4B;
    appointment.ICalUid = UID;
    appointment.Subject = Test Subject;
    appointment.Body = Test Body;

    appointment.Start = new DateTime(2012, 02, 09, 17, 30, 0);
    appointment.End = appointment.Start.AddMinutes(30);
    appointment.Location = 16th Floor Conference Room;

    appointment.RequiredAttendees.Add(tin.tin@acme.com);
    appointment.LegacyFreeBusyStatus = LegacyFreeBusyStatus.Busy;
    appointment.IsResponseRequested = true;
    appointment.Save(SendInvitationsMode.SendToAllAndSaveCopy);

    String UniqueId = appointment.Id.UniqueId;

    // TODO: instead of using UniqueId, get appointment by ICalUid
    appointment = Appointment.Bind(service, new ItemId(UniqueId));
    if (appointment != null)
    {
    //
    }
    Appreciate your help.

    DB:2.60:Find An Event With A Specific Uid Using Exchange Web Services 2010 sp

    Hi Glen
    In case of Calendar event created through IPhone i am getting UID as 'FD8436180C594341977272AAB7EF855B0' when reading it through email listener.
    I need to search this Appointment through EWS API's
    Can you please let me know how to convert this UID into GlobalObjectID. So that i can find ItemID by using FindItem passing GlobalObjectID.
    Thanks
    Siva

  • RELEVANCY SCORE 2.59

    DB:2.59:How Can I Find Value In A Particular Cell Of A Column In Matrix Control In Rdlc File? ma


    Hi All,

    I am using Matrix control in my RDLC report.Report processing mode is Local.My Stored procedure returns 10 columns. Now I want to add 11th and 12th columns to matrix.

    I want to expression for11th column value as (10th column value - 9th column value) and for12th column value as (1st column value - 10th column value) .

    How can I find and get the values of 1st ,9th and 10th column values in matrix control so that I can write expressions for 11th and 12th columns?

    I want to do this in RDLC file only. I don't want to perform this in stored procedure.

    Please help.

    Regards,

    NSJ

    DB:2.59:How Can I Find Value In A Particular Cell Of A Column In Matrix Control In Rdlc File? ma

    Hi, Please select your matrix control on report and add new colomns to the matrix control Then write the column header what you want in 10th column and in the value field select the filed name in the expression field like Fieldname1.value & Fieldname9.value
    and same for next column.Thanks, Pranil Yambal | Pranil.Yambal@hotmail.com

  • RELEVANCY SCORE 2.59

    DB:2.59:Join Not Working (For Me) 91


    I have 2 datasets of the same length. For some reason one uploaded as a dataset while the other is a genericCSV. Anyway, one dataset has several different scoring metrics which I want to use is a regression. I try to take 1 column from the scoring matrix
    and join it with the feature matrix, but the joinfails.
    Additional information: The scoring matrix's formatisdataset and azureML sees all of the columns as strings. The feature matrix's format is GenericCSV and all od the columns are seen as numeric. Bothhave 2,427,770 rows.
    Score has 64 columns (though I only try to joinone column) while the featurematrix has 95 columns. Thanks for the help.

    Just another Superhero with a slide rule rather than a cape.

    DB:2.59:Join Not Working (For Me) 91

    Hi Richard,
    Can you tell us more about the join? What type of join are you attempting (inner join etc.) and what error do you receive?Can you provide a subset of your feature and scoring datasets to illustrate your issue?

    Thanks,
    Jim

  • RELEVANCY SCORE 2.59

    DB:2.59:Work Around/Alternate Solution For Oracle Error Ora-01460 And Ora-02063 z1


    After the installation of Oracle.DataAccess version 2.111.7.20, I get the following error.(the code worked fine with Oracle.DataAccess version 9.2.0.700 )
    I have attached the error as well as the sample code.
    ORA-01460 and ORA-02063 are known bugs in the new ODP but would like to know if there is any Work around/Alternate solution for this problem(other than
    the use of stored procs)..
    Thanks!

    Error:
    ORA-01460: unimplemented or unreasonable conversion requested
    ORA-02063: preceding line from BSREAD_STAGINGRO at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
    at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
    at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
    at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
    .............................................
    ...............................................

    SampleCode
    ---------------------

    private bool isValidFieldData(string clientName, string fieldNumber, string uniqueID, string clientID)
    {
    using (OracleConnection mBSConnection = new OracleConnection(mBSConnectionString))
    {
    OracleDataReader oRdr = null;
    OracleCommand Valid_FieldData_Command = null;
    try
    {
    Valid_FieldData_Command = new OracleCommand();
    Valid_FieldData_Command.Connection = mBSConnection;
    Valid_FieldData_Command.CommandText = "SELECT uniqueid FROM EXTDB.BSData WHERE agencyid = :agencyid and agencyname=:agencyname AND fieldnumber =:fieldnumber AND uniqueid = :uniqueid";
    Valid_FieldData_Command.Parameters.Add(":agencyid", OracleDbType.Varchar2, 255).Value = agencyID;
    Valid_FieldData_Command.Parameters.Add(":agencyname", OracleDbType.Varchar2, 255).Value = agencyName;
    Valid_FieldData_Command.Parameters.Add(":fieldnumber", OracleDbType.Varchar2, 255).Value = fieldNumber;
    Valid_FieldData_Command.Parameters.Add(":uniqueid", OracleDbType.Varchar2, 255).Value = uniqueID;

    mBSConnection.Open();
    oRdr = Valid_FieldData_Command.ExecuteReader(); -Error occurs here

    The error occurs whenever the length of any of the parameter is increased. But there is no specific length where it is breaking down.
    For example in this case, it breaks down with the given error if

    agencyID 8
    agencyName 6
    fieldNumber 9
    uniqueid 6

    DB:2.59:Work Around/Alternate Solution For Oracle Error Ora-01460 And Ora-02063 z1

    After the installation of Oracle.DataAccess version 2.111.7.20, I get the following error.(the code worked fine with Oracle.DataAccess version 9.2.0.700 )
    I have attached the error as well as the sample code.
    ORA-01460 and ORA-02063 are known bugs in the new ODP but would like to know if there is any Work around/Alternate solution for this problem(other than
    the use of stored procs)..
    Thanks!

    Error:
    ORA-01460: unimplemented or unreasonable conversion requested
    ORA-02063: preceding line from BSREAD_STAGINGRO at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
    at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
    at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
    at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
    .............................................
    ...............................................

    SampleCode
    ---------------------

    private bool isValidFieldData(string clientName, string fieldNumber, string uniqueID, string clientID)
    {
    using (OracleConnection mBSConnection = new OracleConnection(mBSConnectionString))
    {
    OracleDataReader oRdr = null;
    OracleCommand Valid_FieldData_Command = null;
    try
    {
    Valid_FieldData_Command = new OracleCommand();
    Valid_FieldData_Command.Connection = mBSConnection;
    Valid_FieldData_Command.CommandText = "SELECT uniqueid FROM EXTDB.BSData WHERE agencyid = :agencyid and agencyname=:agencyname AND fieldnumber =:fieldnumber AND uniqueid = :uniqueid";
    Valid_FieldData_Command.Parameters.Add(":agencyid", OracleDbType.Varchar2, 255).Value = agencyID;
    Valid_FieldData_Command.Parameters.Add(":agencyname", OracleDbType.Varchar2, 255).Value = agencyName;
    Valid_FieldData_Command.Parameters.Add(":fieldnumber", OracleDbType.Varchar2, 255).Value = fieldNumber;
    Valid_FieldData_Command.Parameters.Add(":uniqueid", OracleDbType.Varchar2, 255).Value = uniqueID;

    mBSConnection.Open();
    oRdr = Valid_FieldData_Command.ExecuteReader(); -Error occurs here

    The error occurs whenever the length of any of the parameter is increased. But there is no specific length where it is breaking down.
    For example in this case, it breaks down with the given error if

    agencyID 8
    agencyName 6
    fieldNumber 9
    uniqueid 6

  • RELEVANCY SCORE 2.59

    DB:2.59:One Of My Table Column Length Is Very Long. It Is Responsible For Software Slowness? pa


    Hello Everyone,
    My organisation one developer asking me column length very log any issue to create if column length is very long and
    getting software slow if column length is very long...
    Thanks in advance..

    DB:2.59:One Of My Table Column Length Is Very Long. It Is Responsible For Software Slowness? pa

    Hi David,
    The OP states that Column name is very long, not a datatype.....

    Kalman Toth Database OLAP Architect
    SQL Server 2014 Database Design
    New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012

  • RELEVANCY SCORE 2.59

    DB:2.59:Permutation Vector For Dgetrf xj



    I am having trouble with the output ipiv from dgetrf. My understanding is that it should return an array the length of the number of rows of my input matrix. Each member of this array should contain a different number. These numbers are the column in which a 1 would be placed for the corresponding column i.e. if:

    ipiv =

    1

    4

    5

    2

    3

    This would correspond to a permutation matrix that looks like:

    1 0 0 0 0

    0 0 0 1 0

    0 0 0 0 1

    0 1 0 0 0

    0 0 1 0 0

    And that this permutation matrix P*X(my input matrix) = L*U. However, the ipiv outputs I get from dgetrf have many repetititions such as the output below and P*X != L*U:

    ipiv = 4
    ipiv = 2
    ipiv = 4
    ipiv = 4
    ipiv = 5

    Here is my example program:

    #define M 5
    #define N 5
    int main()
    {

    int i,m, n, *ipiv, info;
    double a[M*N] = { 3, 4, 6, 8, 2, 2, 9, 6, 1, 8, 12, 8, 4, 6, 2, 6, 6, 7, 1, 2, 9, 4, 3, 2, 8 };
    ipiv = malloc(M*sizeof(int));
    m = M;
    n = N;
    info = 0;

    dgetrf(m,n,a,m,ipiv,info);
    printf("info = %d\\n",info);

    for (i=0;i{
    printf("ipiv = %d\\n",ipiv[i]);
    }
    return(0);
    }

    Thanks!

  • RELEVANCY SCORE 2.59

    DB:2.59:Multi Dimensional Arrays And Stringtokenizer cf


    Hello, I am to Java and having some trouble. I need to create a multiple subscripted array of type char 15 rows by 14 columns and use stringTokenizer to put each character on the screen. I also need to bring in values from an html file to populate the array. Do I need to use the getParameter from within the stringTokenizer to populate the array, then in the method where I paint to the screen then refer bcak to the array?
    If this makes any sense.

    right now I have this in my class declaration
    char matrix[][] = new char[15][14];

    and in my init

    for (int row=0; row matrix.length; row++){

    for (int column=0; column matrix[row].length; column++);
    matrix[row][column] = getParameter("line" +(row+1));
    st = new StringTokenizer(getParameter("line" +(row+1)));

    int s=0;

    while (st.hasMoreTokens()){
    matrix[s]= st.nextToken().toString();
    s++;

    I'm not sure if I need to use two subscripts or not. Does this code populate the array, to use later in a method to print the array out character by character?
    Thanks in advance

    DB:2.59:Multi Dimensional Arrays And Stringtokenizer cf

    Even better might be to just a plain String array
    String[] array = new String[15];
    array[0] = "test";

  • RELEVANCY SCORE 2.59

    DB:2.59:Insert Trigger Of Xmltype Table dm


    Is there any way to modify XML document in the insert trigger of XMLType table?

    To preserve unique constraint of @uniqueID attribute in the XMLType table, I declare IDGEN_SEQ sequence and apply it to change the value of @uniqueID attibute by updateXML() function in the Insert Trigger.

    declare
    XMLDATA xmltype;
    begin
    XMLDATA := :new.sys_nc_rowinfo$;
    Select updateXML(XMLDATA, '//@uniqueID', IDGEN_SEQ.nextval) into XMLDATA from dual;
    :new.sys_nc_rowinfo$ := XMLDATA;
    end;

    It lists a error message, "ORA-25003 cannot change NEW values for this column type in trigger".

    Thanks in advance.

    Jin.

    DB:2.59:Insert Trigger Of Xmltype Table dm

    Thank you very much, Mark.
    I hope this bug fixed soon.

  • RELEVANCY SCORE 2.59

    DB:2.59:Storing Multiple Waveforms In A Single Matrix z1


    I collect (say) 10000 points of a waveform and then repeat the proceedure 10 times (for loop). How can I store each waveform as a row or column of a matrix for post processing in Matlab? Using LabView 8.0.Cheers.

    DB:2.59:Storing Multiple Waveforms In A Single Matrix z1

    Duffman (Mike),thanks for the quick response. That is pretty much what I wanted. I am now able to gather a bunch of waveforms, process them in Matlab, and then save the result. Fantastic.Much appreciated.

  • RELEVANCY SCORE 2.59

    DB:2.59:Form Like Matrix,,,,,,,,,,,,,, 1m


    Dear All;

    Can anybody plz tell me who i make the form in form builder like matrix??

    For example

    Waist................... on Row side

    Length................. on column side

    Qty--------------------- us a Data Fields in matrix

    can anybody plz tell me.... thx,.

    DB:2.59:Form Like Matrix,,,,,,,,,,,,,, 1m

    It is very helfil material for me.......... i have done it sucessfully. lot of thx..............

  • RELEVANCY SCORE 2.59

    DB:2.59:Prefix Zero 38



    Hi Gurus,

    I need to check the length of the column is 7 or not in my job. If the incoming column record length is less than the actual length of the column then I need to prefix zero before that.

    For Ex:

    Source Column

    EmpId

    -----------

    12345

    Output:

    Target Column

    EmpId

    -----------

    0012345

    Please help me how can I prefix the zero if the length of the column is less than the actual length.

    DB:2.59:Prefix Zero 38


    Hi Suresh,

    Please use the below functions:

    If i/p is number datatype: LPAD(to_char(COLUMN_NAME), 7,'0')

    If i/p is char datatype: LPAD(COLIMN_NAME, 7, '0')

    Kannan R