Compound key using DAO? 1

[gwar2k1]

Hey, how can I make a compound key for a relational database using DAO in VB6? It wont let me append more than one key per table... is it possible?

Thanks in advance

~*Gwar3k1*~
"To the pressure, everything's just like: an illusion. I'll be losing you before long..."

 

[Schroeder]

You're not creating multiple Primary Keys, just one that includes several fields.
Create the index and set it as Primary, Unique, what have you. Add the fields to be included in your Primary Key to your index then add the index to the table.

 

[gwar2k1]

Ah bravo. Commer seperated i take it? Cheers and thanks for the speedy response!

~*Gwar3k1*~
"To the pressure, everything's just like: an illusion. I'll be losing you before long..."

 

[Schroeder]

Well, I'm not 100% sure what you mean by comma separated but, you don't add multiple fields to an index by separating them with commas. More like:
Set idxPrimary = tdfTable.CreateIndex("PrimaryKey")
Set fldField = idxPrimary.CreateField("Field1",dbInteger)
idxPrimary.Fields.Append fldField
Set fldField = idxPrimary.CreateField("Field2",dbText, 10)
idxPrimary.Fields.Append fldField
idxPrimary.Unique = True
idxPrimary.Primary = True
tdfTable.Indexes.Append idxPrimary

 

[gwar2k1]

ah fair play =D yeah i think you got the jist of what i meant

.append ("x", "y", "z")

thanks =D

~*Gwar3k1*~
"To the pressure, everything's just like: an illusion. I'll be losing you before long..."