We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
Cannot join on Memo, OLE, or Hyperlink Object (proje.projeAdi=calisan.proje).[Answered]
1 reply
Last post Jul 14, 2014 08:11 AM by Mikesdotnetting
Member
1 Points
9 Posts
Cannot join on Memo, OLE, or Hyperlink Object (proje.projeAdi=calisan.proje).
Jul 14, 2014 06:07 AM|OnePage|LINK
Database: MS-Access
This is my database table and column. I give the error. Error Messsage is write the question header.
proje Table
Field Name Type
id Integer(Auto Increment)
projeAdi Long Text
sirketAdi Long Text
calisan Table
Field Name Type
id Integer(Auto Increment)
gun Date/Time
isTanimi Long Text
kulID Integer
basSaat Date/Time
bitisSaat Date/Time
proje Long Text
istipi Long Text
// Sql Query sorgu.Connection = baglanti; baglanti.Open(); sorgu.CommandText = "SELECT * FROM calisan INNER JOIN proje ON proje.projeAdi = calisan.proje;"; oku = sorgu.ExecuteReader();ms access c-sharp asp.net
All-Star
194832 Points
28099 Posts
Moderator
Re: Cannot join on Memo, OLE, or Hyperlink Object (proje.projeAdi=calisan.proje).
Jul 14, 2014 08:11 AM|Mikesdotnetting|LINK
As the error message says, you cannot join on MEMO fields. LONG TEXT is a MEMO field. Instead of using a JOIN, you can use a WHERE clause instead: http://improvingsoftware.com/2011/03/15/how-to-join-on-memo-fields-in-microsoft-access/
ms access c-sharp asp.net