?
Solved

error 0x80040E14 when using Data Shaping

Posted on 2004-04-02
2
Medium Priority
?
335 Views
Last Modified: 2008-02-01
Newbe to ASP and DataShaping Help!

Trying to do the following:

strSQL = "SHAPE { SELECT ArtId, ArtName, ArtDescr FROM Art } APPEND ({ SELECT AttribId, AttribContentId FROM ArtAttribute } AS AttCont RELATE ArtId TO ArtId )"

Getting the following error message:

Feltyp:
MSDataShape (0x80040E14)
Kolumnen (ArtId) finns inte i korrekt raduppsättning.
/articles/articles.asp, line 27

Swedish and means someting like 'The colomn (ArtId) does not exist in the correct table'.

I've checked over and over again and I can not see any misspellings etc......
0
Comment
Question by:dojan
2 Comments
 
LVL 12

Accepted Solution

by:
dfiala13 earned 1000 total points
ID: 10745672
You don't have an ArtiD column in ArtAttribute defined.

Try this...

strSQL = "SHAPE { SELECT ArtId, ArtName, ArtDescr FROM Art } APPEND ({ SELECT ArtID, AttribId, AttribContentId FROM ArtAttribute } AS AttCont RELATE ArtId TO ArtId )"
0
 

Author Comment

by:dojan
ID: 10747666
Thanks dfiala13! It did the trick.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question