Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Cyclonik
Posting Yak Master
114 Posts |
 Posted - 2000-11-25 : 16:28:55
|
| I am trying to use the MSDatashape provider.. i am wondering if you can't append data from the same table.. or maybe my syntax is offSHAPE {SELECT Fname, Lname FROM tblUsersT where lanid='blah'}APPEND ({SELECT Fname, Lname FROM tblUsersT} AS Team RELATE lanid TO managerid)This is the error i receive.. i have tried a few variations of the above code..MSDataShape error '80040e14' The referenced column (managerid) does not exist in the appropriate rowset. managerid is a foreign key to lanid in the same table-=:SpasmatiK:=- |
|
|
|
|
|
Data Shaping...