User Profile

Collapse

Profile Sidebar

Collapse
ibrahim2008
ibrahim2008
Last Activity: Jan 18 '09, 06:45 PM
Joined: Nov 6 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ibrahim2008
    replied to Delete Null Rows From a Grid
    in Visual Basic
    Thanks Vijay,

    I need this one only.

    Regards,
    Ibrahim
    See more | Go to post

      Leave a comment:

    • ibrahim2008
      started a topic Delete Null Rows From a Grid
      in Visual Basic

      Delete Null Rows From a Grid

      While filing in a grid,total i am getting 19 rows,from which all 14 rows are
      filing(datas exist),then 15,16,17,18 rows are blank(means null),but then 19th rows are filing.but i don't want these 15,16,17,18 rows.but i need 19 rows

      so how to delete those blank rows,can any one tell how to merge those
      15,16,17,18,19 rows in one rows,but it has to show 19 row data.


      Regards,
      Ibrahim
      See more | Go to post
      • ibrahim2008
        started a topic Sql
        in Oracle

        Sql

        Give me some idea on index & cluster.if possible give me details/gimme some sites where i can download this.


        Regards,
        Ibrahim
        See more | Go to post
        • ibrahim2008
          started a topic Sql
          in Oracle

          Sql

          Can anyone tell the difference between view & materialized view
          See more | Go to post
          • ibrahim2008
            replied to Oracle Query
            in Oracle
            Hi
            Just Try this query with RANK() Function,Enter Value for N and you'll get
            Top N salary and one thing for descending use NULLS LAST and for
            ascending use NULLS FIRST.But if u are omitting this NULLS FIRST or
            NULLS LAST,then for salary which is having null values,you'll get.

            Still using other queries you can also get top N salary like subqueries.

            SELECT Empno, Ename,...
            See more | Go to post

              Leave a comment:

            • ibrahim2008
              replied to select query
              in Oracle
              The query you have written is right,but there may be some duplicate records,so that's why you are getting such records.i don't know what your tables are containing/just give your table details.


              Regards,
              Ibrahim
              See more | Go to post

                Leave a comment:

              • ibrahim2008
                started a topic Error while filling In a combo box
                in Visual Basic

                Error while filling In a combo box

                I am trying to fill data in a combo box(comwork) from a record set,but that record set is retrieving nearly 44000 records.While executing this error is coming,"invalid item index."i think that newindex is going to upper bound(32767),th at's this error is coming.

                My code

                rs.open"select wono,woid from workorder,conma in
                do while not rs!eof
                comwo.additem rs!wono
                combo.itemdata( combo.newindex) =rs!woid...
                See more | Go to post
                • ibrahim2008
                  replied to Column Settings
                  in Oracle
                  I know all this what you all have described,but any other method.


                  Regards,
                  Ibrahim
                  See more | Go to post

                    Leave a comment:

                  • ibrahim2008
                    started a topic Column Settings
                    in Oracle

                    Column Settings

                    In my table,Let's say EMP,there are three columns EMPID,ENAME,DEP TNO,LOCATION(in this order),but i want it to be EMPID,DEPTNO,EN AME,LOCATION(pe rmanently).
                    Can it be possible,please help me.

                    Regards,
                    Ibrahim
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...