Results 1 to 3 of 3

Thread: vb6.0 script requirement

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2012
    Posts
    2

    vb6.0 script requirement

    Hello every one i need help on following requirment /..

    Database table

    BugID Name Date Comments
    1 X 01/04/2012 Entered a new record
    1 Y 02/04/2012 Updated the record
    1 Z 08/04/12 Fixed the record and updated the source control with new code

    Asuming this is the way i have details for a specefic bug id in bug id details table.

    I want to create a text box which shows these details in sequential order and has the scroll bar feature. This is if we have say 20 users who have worked on this, then the text box should provide details of all 20 records and we should be able to scroll down to the last record.

    The output format that we are looking at would be

    Date , Name
    Comments

    Date , Name
    Comments

    Date , Name
    Comments

    for the above examplet it may be like :

    01/04/2012 X
    Entered a new record

    02/04/2012 Y
    Updated the record

    08/04/12 Z
    Fixed the record and updated the source control with new code

    The above output should bein a text box that is scrollable both upwards and downwards The S/W version : VB6.0, Backend Database : SQL Server 2005

    -------------------------
    Thanks,Suhas Vallala

  2. #2
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: vb6.0 script requirement

    Why a textbox? A grid or listview would be a the common choice for such a thing.

    Anyway you could use a textbox you'd just have to set the multiline property to true and set the scroll bars to vertical or both then in your code you would need to loop through the resulting recordset and append each row to the text box and add a vbCRLF to the end of each row.

  3. #3

    Thread Starter
    New Member
    Join Date
    Jul 2012
    Posts
    2

    Re: vb6.0 script requirement

    The comments that are updated by the team is a multi line text box. This is fine with insert of data.

    While reterieving the data, currently we have used the Flexi grid to display all records and a click function on the grid row to display the details of that specefic row.

    Hence we are trying to check if we output these records in text box with the vertical scroll on and then provide the users with the scorll down function so that they see the entire data instead of clicking the grid row.

    We are also ok with the Grid view but can the gird auto expand itself to multiline. ex if we have a user who has entered 10 lines in response. While displaying in grid, it displays the first line only. So can we show all the lines in the grid by having a auto expand of grid to show the complete data. This would make our view more effective. We have set the feature of wordwrap on the grid but we have to manually drag / expand the grid row to view the full data. Is there a mechanism wherein this can be acehieved...

    Thanks in Advance
    Suhas Vallala
    Last edited by suhas vallala; Jul 5th, 2012 at 03:19 PM. Reason: correction to statement

Posting Permissions

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



Click Here to Expand Forum to Full Width