Ben, have you tried the select with the substring?
andre On Wed, Jan 12, 2011 at 11:41 AM, Ben Rubinstein <benr...@cogapp.com> wrote: > Thanks Andre. However, the size of these fields is not that great - > probably less than 1K - and in our test database it's just a few bytes. > > Has anyone else experience with accessing ntext fields from SQL Server over > ODBC - using Rev/LiveCode or anything else? > > TIA, > > Ben > > On 12/01/2011 13:17, Andre Garzia wrote: >> >> Ben, >> >> I have no clue whatsoever what ntext fields are but you could try a >> combination of the following stuff: >> >> You can try executing this Transact-SQL piece on a query to the server: >> >> SET TEXTSIZE 64512 >> >> This will change the amount of text returned by a SELECT into a ntext >> or nvarchar field. >> >> If you the upper limit of the size of your text, you can try selecting >> it as a substring such as: >> >> SELECT SUBSTRING(myfield, 1, 4096) AS myfield FROM mytable >> >> Now, I never faced such issues but then again, I seldon do windows and >> the last time I've dealt with MS SQL Server was in 1999... >> >> Andre > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- http://www.andregarzia.com All We Do Is Code. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
