Getting data from SQL Server table with composite key

Like (0) Share

Report

Posted on 30 May 2017 09:36:55 by gax700

Hello everyone,

I'm trying to get data from a SQL Server table that has a primary composed key (3 columns). The new app procedure builds the interface correctly but doesn't fetch any data.

I've tried to change the primary key to a single autoincrement ID column and everything works like a charm.

Is this behaviour by design? Anyone else experieced this?

Thanks,

Cris

Categories:

Connecting to Data

All responses (2)

Answers (0)

gax700 24 on 31 May 2017 at 06:21:37

Like (0)

Report

Re: Getting data from SQL Server table with composite key

Hi Mabel,
this is the table definition. No way to show data into the app.

Thanks,
Cris
v-yamao-msft on 31 May 2017 at 04:12:02

Like (0)

Report

Re: Getting data from SQL Server table with composite key

Hi gax700,

What are the column types of the three columns? Do you have entered data for each column?

I am using SQL Server On-Premise, to test this issue, i set a column(column type int) as primary key, then when i create an app based the table, I found that all the data in the table are shown on the app. I can also write back to the table from the app.

Before you change the primary key to a single autoincrement ID column, which column were you using as the primary key?

Best regards,

Mabel Mao