Komaromi, Steve
2007-07-18T17:54:00Z
Hi,

I'm testing GeniusConnect and our information to sync to Outlook coming from more then one table. I created a view on the server to combine all the data.

On the table assigment screen I am able to see all the fields returned by the view but when finishing up I receive a message "The table must have at least one primary key".

Question #1: Can I use views to select a dataset as a data source at all? Certainly I can see them on the table selection list.

Question #2: If I can, how can I have a primary key in the view, or how can I pass the error message?

Thanks,

Steve

Steve Komaromi

Network Administrator, Systems Developer
Business Risk Partners, Inc.
Tel: 1-(860)-903-0039
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2007-07-18T20:22:00Z
Hello,

yes, you can use a View, but you must specifi a primary/unique field.
It must be a column or set of columns whose values uniquely identify a row in a table/View.

No two rows in a table can have the same primary key value.



Komaromi, Steve
2007-07-18T22:59:00Z
Hello,

yes, you can use a View, but you must specifi a primary/unique field.
It must be a column or set of columns whose values uniquely identify a row in a table/View.

No two rows in a table can have the same primary key value.
Komaromi, Steve
2007-07-18T23:02:00Z

Hi,

Could you give me an example how to make a view have primary field. I'm using SQL 2000 and see no option to set primary fields for views.

Thanks

Steve

Steve Komaromi

Network Administrator, Systems Developer
Business Risk Partners, Inc.
Tel: 1-(860)-903-0039
Administrator
2007-07-24T10:26:00Z
Hello,

you can't set primary key on a VIEW, you must define it in GeniusConnect config dialog.
(Assign Table Dialog->Mandatory keys):

Mandatory Col.png

Click to View Image20 View(s)