Last post Jul 14, 2014 08:11 AM by Mikesdotnetting
Member
1 Points
9 Posts
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.
Field Name Type
id Integer(Auto Increment)
projeAdi Long Text
sirketAdi Long Text
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
184884 Points
26709 Posts
Moderator
MVP
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/
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
184884 Points
26709 Posts
Moderator
MVP
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
ASP.NET Tutorials | Learn Entity Framework Core| Learn Razor Pages