SQL Server compact Edition 4 (Inner Join)

Question

I'm moving from MS Access database to SQL Server compact Edition 4 database.

Can someone give translate the SQL statement below into SQL CE format?

Dim m_sSQL_Base_DR As String = "Select * From tbl_Records_DR AS Records_DR " _
& "INNER JOIN tbl_Records_DR_ExplainAction AS Records_EA ON Records_DR.DAutoID = Records_EA.DRefer_ID "

Thanks,

ADawn

---

ADawn

Answer 1

I believe you just want the T-SQL and not the C# code?

Select * 
From tbl_Records_DR AS Records_DR INNER JOIN tbl_Records_DR_ExplainAction AS Records_EA 
ON Records_DR.DAutoID = Records_EA.DRefer_ID 

Select *
From tbl_Records_DR AS Records_DR INNER JOIN tbl_Records_DR_ExplainAction AS Records_EA
ON Records_DR.DAutoID = Records_EA.DRefer_ID

---

David Dye My Blog

Answer 2

Jjust the T-SQL statement translated to SQL CE.

"Select * From tbl_Records_DR AS Records_DR " _
& "INNER JOIN tbl_Records_DR_ExplainAction AS Records_EA ON Records_DR.DAutoID = Records_EA.DRefer_ID "

---

ADawn

Answer 3

Select * 
From tbl_Records_DR AS Records_DR INNER JOIN tbl_Records_DR_ExplainAction AS Records_EA 
ON Records_DR.DAutoID = Records_EA.DRefer_ID 

---

David Dye My Blog

Answer 4

Isn't that what I had? So what I was using should work?

---

ADawn

Answer 5

SQL CE supports ANSI joins so it should work.  Are you getting an error??

---

David Dye My Blog

Answer 6

Yes.

OleDbDataAdapter internal error: invalid row set accessor: Ordinal=28 Status=UNSUPPORTEDCONVERSION.

---

ADawn

Answer 7

Is is not the query, but rather the provider:

http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/ce6a36c2-14e5-4e1c-93de-d261a667e8f0

---

David Dye My Blog