Hi Andre,
Tried it, no success.
Thanks,
Ben
On 12/01/2011 13:55, Andre Garzia wrote:
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
_______________________________________________
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
