Solved

error 0x80040E14 when using Data Shaping

Posted on 2004-04-02
2
309 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 250 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

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…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 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