cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with "select" from table view into database

Former Member
0 Kudos

Hello,

ive a problem with submiting parameters into database from table view. This table view comes from stored procedure saved in SQLserver. It works fine, but i want to select item in the table view and pass it into another stored procedure to get details of the selected item.

The problem is that in the select method i cannot assign a dynamic parameter that comes from the table. I can assign olny static value( string) for the field that is passed. When i assign the filed reference i become following error: "Field references are not allowed in this expression"

Does anyone know how to define "assign" field for submit procedure to get dynamic value from table view?

One more thing..In the layout view of VC, i cannot choose what fields should be visible in the table? Is the only way to define it by editing stored procedure in SQLserver?

Thanks for help!

Best regards,

Karol

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

fields has to be defined