Cannot join on Memo, OLE, or Hyperlink Object (proje.projeAdi=calisan.proje).[Answered] RSS

• • Reply
  OnePage

  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

• • Reply
  Mikesdotnett...

  All-Star

  192738 Points

  27928 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

  ASP.NET Tutorials | Learn Entity Framework Core | Learn Razor Pages | Learn Dapper