Didier
2005-12-14T11:15:00Z
Hello,

After installing the demo version, i have been able to map (very easyly, thanks !) a my_contacts Folder to my Oracle table (which has an ID column as Primary Key).

but as soon as i try to map that folder to a View to the same Table (View that includes the ID column but has no PK) i get the message "the table must have a least one PK".

what can be done ?
Thanks in advance.

Didier GEORGES.
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2005-12-14T11:26:00Z
Hello,

please click the "Mandatory Key" button and specify the primary key.
In case of VIEW it is not real "primary key",
but the column or set of columns whose values uniquely identify a row in the result set.

If a table is used, ODBC is able to detect the primary key, but this is not possible if using VIEW.

Please note:If you are using a VIEW, you will not be able to save Outlook Items back to the database, or you have
to specify instead of triggers on your view. (not every database support this)

Please see also:
http://support.geniusconnect.com/topics/14- 
Didier
2005-12-14T11:44:00Z
Thanks a lot, it works ok now !

best regards.