multiple primary keys

[João Ribeiro]

how can i put multiple primary keys on a class
I have this propertys as primary keys..

Property Edificio As %Integer;

Index EdificioIndex On Edificio [ PrimaryKey, Unique ];

Property Planta As %Integer;

Index PlantaIndex On Planta [ PrimaryKey, Unique ];

Property Sala As %Integer;

Index SalaIndex On Sala [ PrimaryKey, Unique ];


but this make an error...(multiple primary keys).


Thanks,
João Ribeiro

[Tom Fitzgibbon]

Why do you need multiple primary keys?

--
You received this message because you are subscribed to the Google Groups "InterSystems: Zen Community" group.
To post to this group, send email to InterSys...@googlegroups.com
To unsubscribe from this group, send email to InterSystems-Z...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/InterSystems-ZEN?hl=en
Zen Community Terms and Conditions: http://groups.google.com/group/InterSystems-ZEN/web/community-terms-and-conditions
---
You received this message because you are subscribed to the Google Groups "InterSystems: Zen Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-z...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[peter cooper]

Hi João

 

Just have one primay key and make the other one just

Index SalaIndex On Sala [Unique ];

 

Peter

--

[Ayumu Tanaka]

You can define one primary key index on 3 properties.

Index MultipleIndex On (Edificio, Planta, Sala) [ PrimaryKey, Unique ];

http://docs.intersystems.com/cache20131/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_indices#GSQL_indices_std_multprop

Ayumu

> Joao Ribeiro

[João Ribeiro]

thank you it worked

2013/5/23 Ayumu Tanaka <ayumu....@intersystems.com>