web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... MSCRM, sql select erro...

Customer experience | Sales, Customer Insights,...

Answered

MSCRM, sql select error invalid column name

(0) Share

Report

Report

Posted on by petrtim

20

Hello, we are trying to get some data from Account entity in MSCRM 8 onpremise

we have sql query something like this (It is called from c# application):

select distinct top 100 acc.accountid,acc.OwnerId, ...,  acc.v_ownerid 
from account acc
where acc.statecode = 0 and (1=0 or acc.accountid= xxxx)

When I Try to run this select from my C# code I am getting an error:

System.Data.SqlClient.SqlException: Invalid column name 'acc.v_ownerid'.

The field 'acc.v_ownerid' for 100% exists in DB

If I will run this select in Sql Management studio it will give me result
If I run SQL profiler I will get sql query, which also returns result
If I will run it from C# code, It will give me error above, if this field is removed it will work, but I need it..

Please where can be the problem?

Petr

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

I work with Dynamics since 2008 and v 4.0 and I did some DB-side work as well. I never heard or seen v_ownerid field.

Question - what is stored in this field and why do you need it?

Was this reply helpful? Yes No
petrtim 20 on at

Like (0)

Report

It is custom field...

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Can you please provide code where you build SQL Connection, where you use SQLCommand and/or SQLAdapter and so on including your SQL Connection string?

Was this reply helpful? Yes No
Verified answer

petrtim 20 on at

Like (0)

Report
Well, the solution is to use this select

Select distinct top 100 acc.accountid,acc.OwnerId, ..., acc.v_ownerid from X.dbo.account acc where acc.statecode = 0 and (1=0 or acc.accountid= xxxx)

instead of:

select distinct top 100 acc.accountid,acc.OwnerId, ..., acc.v_ownerid from account acc where acc.statecode = 0 and (1=0 or acc.accountid= xxxx)

Then it returns all columns, do not know why, but it is working...

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Tom_Gioielli 170 Super User 2025 Season 2

#2

#3

Gerardo Rentería Ga... 52 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans