POST, Analise dan Share Code di sini - VBers

[positive+]

Tweet

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+

[Dewaputra]

Tweet

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 ]

[positive+]

Tweet

@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+

[positive+]

Tweet

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 ....

[positive+]

Tweet

Database Function [ Searching ]

Now, build this function as fit as u need

'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.

[positive+]

Tweet

Different way to make an Array ::.

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

[positive+]

Tweet

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

[pds]

Tweet

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.

[positive+]

Tweet

@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+

[positive+]

Tweet

Simple Custom Message Box ::.