Results 1 to 4 of 4

Thread: usememosize VT property

  1. #1
    Senior Member
    Join Date
    Oct 2012
    Posts
    205

    Question usememosize VT property

    What value should I specify for the "usememosize" property in the VT definition? What does this value depend on and what does it affect? What happens if this property is not specified in the VT definition?
    I did not specify this property when I created VT. If I query now, the cursoradapter returns a variable value. In 2 cases out of 6 queries, the value is 0, 1x 1255, 1x 1741, 1x 1922 and 1x 989922050!

  2. #2
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,068
    Hi Strato,

    Are you hitting a Lianja table or a SQL Server table?

    If using a SQL Server table on the backend, do you have it defined as varchar(max)? (You should.) If not, what do you have it defined as? If it returns a number result rather than a character, perhaps the backend is defined as a varbinary?

    I assume you have looked at what usememosize does: https://www.lianja.com/doc/index.php/CursorAdapter

    And that you have looked at this (the datatypes, what they hold, etc.): https://www.lianja.com/doc/index.php/Appendix_A The short story: if it's CHAR and could be long, use Memo in a Lianja table. If it's numeric and isn't "just one number" use Object.

    Hank

  3. #3
    Senior Member
    Join Date
    Oct 2012
    Posts
    205
    hi Hank and thank you,
    The basetables are mySQL tables. In the basetables there are 'mediumtext' or 'longtext' type fields represented as 'memo' type in Lianja's VTs. The VTs was created with "Create virtual tables from ODBC ..." in Linaja 5.0.

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,219
    If you turn DEBUG on you can see what's happening in the debug_client file.

    When reading varchar fields Lianja will limit them to 64k so not sure where you are getting that large number from. In fact it will report and error.

    Check the debug file to make sure your ODBC driver is behaving as you expect it to.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us