POST, Analise dan Share Code di sini - VBers - Page 5
Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the CHIP Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

+ Reply to Thread
Page 5 of 51 FirstFirst 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 ... LastLast
Results 41 to 50 of 506

Thread: POST, Analise dan Share Code di sini - VBers
  
Bookmark and Share

  1. #41
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    First, mean what database is --> which DBMS
    so, ur database name is Material DB, ok then

    from what u explain here, i don't see any relation between table 3 to 1 and 2
    this statement of mine ( i think u already know it )
    to linked ( Relation ) between one table to other - must have same data type and values instead ! ( consider to re-construct )
    so, u got ur own reason to make ur database design to look like that, i can't argue with that, in fact i know nothin to ur problems

    but, if u want it :
    ==========================
    Make [table 3] as detail table
    contain : id3,id1,id2, [child field ] . . .
    now, from that IDs, [ id2 linked to Table 2 ] and [ id1 linked to Table 1 ]
    so, [Table 1] and [Table 2] is Master Tables
    ==========================

    from ur design, u can make [Table 3 ] not relation to any tables in ur DB.
    so, da only way u can do is Hard Coding, check one by one, split da [Id3] values, to sync values from other tables [ Table 1 ] and [ Table 2 ]

    [ id1 = MA ] - [ id2 = 02 ] - [ id3 = MA02 (gabungan id1 dan id2) ]

    u see, how about if [ id1 = MA ... MZ or AA ... AZ , etc ] If [ id2 = 99 ] then u lost ur path there - [ id3 = MZ99 ]

    you'll make new problems in da end. ( but, i know nothin about ur problems .. so, consider it obey ur self )

    ( truely i hate relations - but, if i want to chase ma database i should to do data analizing first, about what will i get, then design da tables )

    =============================================
    about db code ::.
    =============================================
    If this is ADODB Classes and their trees Classes
    =============================================
    ADODB <--> Engine Drivers <--> Databases
    |
    < connection link classes >
    (0) Connection Classes <-- Recordset Classes (1)

    < subtrees of Recordset Classes >

    (1) Recordset <--(2)Class Tables <--(3)Class Fields <---(4)Class Data Type, etc --

    =============================================
    Then u can choose which Classes are quicker to use for certain sql statement of yours, etc

    I'll wait ur comments, later

    Regard, Positive+
    " A man's felicity consists not in the outward and visible blessing of fortune, but in the inward and unseen perfections and riches of the mind "

    thomas carlyle

    where i used to go when surfing :
    site1 site2 site3 ...


  2. #42
    Join Date
    Oct 2005
    Location
    Jakarta
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: POST, Analise dan Share Code di sini - VBers



    positive+

    I see u'r point, by the way I'm using SQL Server 7 for my DBMS

    but I still have 1 question, cause I don't quite understand with what you mean I loose my path?

    u see, how about if [ id1 = MA ... MZ or AA ... AZ , etc ] If [ id2 = 99 ] then u lost ur path there - [ id3 = MZ99 ]
    Dedi Dermawan Putra

    = IT Support =

    Information Technology Department

    PT. PolymatechIndonesia, Mfg.

    Industrial Town MM2100Block O/9

    Cikarang Barat -Bekasi

    Telp. +62 218980170 / 71

    Fax. +62 21 8981314

    Email. dewaputra_82@yahoo.com

  3. #43
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    @Dewaputras,
    da meaning is from da records side
    if da record in [ id1 = MA ] ma opinion da increment values is [ MA..MB..MC..till MZ ] when da record reach [ MZ ] what will u do ? do you have to restart from [ MA ] again or what ? so do to [ id2 = 02 ] ma opinion same like [ id1 ] records, da increment things if reaches [ id2 = 99 ].
    da indexes like we all know must be unique can't be indentical, when that problems comes to u, what will u do ?? course, that will affect your [ Table 3 ] records too, CMIIW that's what i mean you'll lost ur path ... from da records side.

    but, if u think da records will not reach that values or u have other reason, i still stand from ma statement above - i know nothin bout ur problems there.
    so, considerations is belongs to u now.

    da coding things, you'll know which coding faster or not if u understand more about database contexts u using ( ADO, DAO ,etc) try to make ur own classes that act like that, then you'll know da secret of them. when u discovered all those things, there's no way coding can beat u up coz u have some point that break their point.

    Open to me, than i'll open to you more
    Best Regard, Positive+

  4. #44
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    Story of ::.

    When i got 1 thing ... just 1 thing, then i'll thinkin for 1 thing only
    but, when 1 becomes 2 or greater than 1, then i should to think for billion things.
    how can i think from billion things to be 1 thing
    then from 1 thing, i can get much possibilities
    where all of those possibilities refer to other linked possibilities
    but in da end, i should to make all of those possibilities to 1 canonic thing.
    When i got 1 canonic thing, then i try to make from horizontal building to vertical building, yeah ... that's must be hight !

    not a bunch barricade of childrens without parent.
    where all childrens must know their parents, so do da parents.
    When da parent meet each other to other parent in a different home, da parents will tell their children each other, so da children no need to re-introductions.

    When da parents like to make gathering, so da parents made one special place where they can meet each other. From that place parents can make a call to their children at home, at anytime they want...parents, they like to do that, talk about their childrens and random things

    Childrens, they have a different attitudes and characters...childrens

    Continued ....

  5. #45
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    Database Function [ Searching ]

    Now, build this function as fit as u need


    Code:
    'Positive+ - [ Databases ] Sub Modules
    
    Public Function search_dyna(iKey As String, iTbl As String, _
                                sCompare As String) As Boolean
    '**********************************************************
    'Params Descriptions :
    '**********************************************************
    'iKey     = Field Name in table _
    'iTbl      = Table Name in DB _
    'sCompare = Values to match at curr Key [ iKey ] and curr Table [ iTbl ]
    '**********************************************************
    Dim TempT As String
        TempT = "select [" & iKey & "] from [" & iTbl & "] where [" & iKey & "]='" & sCompare & "';"
        'Return True if [ Not EOF ] and False if [ EOF ]
        Exit Function
    End Function
    
    da function will search at any tables, any field u want and any comparison values u need

    u see da comparison values is a [ String ] how about da [ iKey ] values not a [ String ]
    see da main structure and if u made better, u can post here.

  6. #46
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    Different way to make an Array ::.

    Code:
    Option Explicit
    
    Private Sub DiffArray()
    Dim at As Variant, i As Integer
        at = Array("AA", "AB", "AC", "AD", "AE", "AF", "AG", "AH")
        For i = LBound(at) To UBound(at): MsgBox at(i): Next
        Exit Sub
    End Sub
    
    Private Sub Form_Load()
        DiffArray
    End Sub
    
    



  7. #47
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    Load and Unload an Object - Still with arrays

    See da sample project - all code has been commented




    combine this sample concept to Harno's SimplePuzzle sample
    Attached Files
    Last edited by positive+; 26-01-2006 at 14:46.

  8. #48
    Join Date
    Aug 2005
    Location
    jakarta
    Posts
    3,542
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    28

    Re: POST, Analise dan Share Code di sini - VBers



    Bro positive minta tanggapan soal Visual Basic 2005 donk. Lebih bagus ga dari VB 6 skrg ini?
    Pengen install cuma makan tempat ampe 2 Gb, jadi masih ragu2.

  9. #49
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    @pds :
    First, for what purpose ??
    do you want da program of yours to be commercial or just for self satisfactions only ??
    VB 6 dan VB 2005 mempunyai kelebihan dan kekurangan masing2. Seperti yg saya tanyakan di atas, for what purpose da product you'll make later ? commercial or satisfaction ?
    For commercial, stick with VB 6 - it's powerfull enought
    VB 2005 support for net application but uses more resources, is that for you when designing program or for your user later. da resources, course from da storage size and memory size.
    Not all Indonesian peps have computer with hight specs. Terutama di kantoran, banyak komputer dengan specs rendah, pertimbangan akan ada pada hal ini :
    - Apakah pengguna harus menaikkan specs komputer mereka utk program kamu bisa berjalan ? ato ngga ada program yg akan jalan sama sekali karena tersangkut masalah biaya upgrade komputer ?
    Goto microsoft support
    you'll get more detail informations about what u askin for

    Tapi untuk sekedar ingin tau, ngga ada salahnya untuk install VB 2005, di situ kamu akan mendapatkan lebih banyak gambaran mengenai konsep2 baru dan akan memperluas pola pikir kamu, baik dari segi coding, prosedural structure-nya, interface design, pembuatan modules / classes yg rada berbeda dari VB 6, dan lainnya.
    Yes, dan pada saat kamu nantinya akan men-developt kembali menggunakan VB 6 - you'll got a lot of new thing and concepts to try. ( This words will come to you .. WHAT ... WHY ... CAN I ... )

    Personal answer : saya lebih memilih menggunakan VB 6 - krn pertimbangan dr segi commercial-nya utk kepuasan pribadi saya akan selalu mengikuti perkembangan-nya VB, but ... hanya utk sekedar tau dan mempelajari penerapan konsep2 baru dari Master Mind of VB it self.

    Dan, ngga ada salahnya juga bila kamu ingin mencoba C++, Delphi, Pascal, Clipper etc.
    Di dalam C++ kamu akan lebih disiplin dalam penggunaan variable, jangkauan type variables, memory management, dan structural yg baik. Pada Delphi kamu akan banyak mempelajari konsep dan pengaturan modules / classes. Pada Pascal, kamu akan melihat dan mengerti jelas logic dari pemrograman ( view of interpreter and compiler it self ) serta akan merangsang daya khayal kamu dalam membuat design program pada visual nantinya. Pada Clipper kamu akan lebih mahir dalam bermain indexing dan array.
    Then, in VBs try to implemented all combinations of that concepts and knowledges to make a great program

    Hope my explanations clear enought,
    Regard, Positive+

  10. #50
    Join Date
    Jan 2005
    Posts
    908
    Thanks
    0
    Thanked 9 Times in 8 Posts
    Rep Power
    21

    Re: POST, Analise dan Share Code di sini - VBers



    Simple Custom Message Box ::.


    Attached Files


 

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

     

Bookmarks

Posting Permissions

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