第255个字符后的字符长度超过255个字符串 [英] Faulty characters after the 255 th character in longer than 255 string
问题描述
大家好，
我有一张基于桌子的记录集。
表中的每个字段都在记录集，以便字段的长度增加5倍！
retreatement在查询中使用这种表达式：
Myf1 ：func（[Field1]）
..........
MyfN：func（FieldN）
你可以想象有超过100个符号的字段..所以函数返回超过500个符号！
在获得的查询中没有任何问题各个字段的可视化 - 所有字符都被核心显示！
问题是当从VB打开此查询时
显示这些字段正确到第255个字符并且只有??? ???和这样的人物！这似乎是从记忆中获得任何一部分，但与该领域的结尾没有任何共同之处！
myr（[Myf1]）限制为255个字符的正常功能！
从现场获取数据的其他方法？
确保有，因为它在查询中正确显示数据表！
非常感谢帮助！
Hi everybody,
I''ve a recordset based on a table.
Each field in the table is retreated in the recordset, so that the length of the field increases 5 times!
The retreatement is using this kind of expressions in the query:
Myf1:func([Field1])
..........
MyfN:func(FieldN)
As you can imagine there is fields that are longer than 100 symbols.. So the function returns more than 500 symbols!
In the obtained query there isn''t any problem with the visualization of the respective fields - all characters are corectly displayed!
The problem is when this query is open from VB
Those fields are displayed correctly till the 255 th character and than only ??? ??? and characters like this! that seem to be get any part from the memory but nothing in common with the end of the field!
myr("[Myf1]") is limited to 255 characters proper function!
Other ways to get the data from the field?
Sure that there is, coz it''s properly displayed in the query datasheet!
Help is greatly appreciated!
推荐答案
首先，撤退和 retreatement 是什么意思？我搜索了六个编程词典，但没有找到任何术语。这个（我假设）函数 Myf1：func 是做什么的？涉及的字段显然被定义为一个文本字段，它有255个字符的限制，我希望在此之后解释垃圾。
First off, what does retreated and retreatement mean? I''ve searched thru half a dozen programming dictionaries and found neither term. And what does this (I assume) function Myf1:func do? The involved field is obviously defined as a text field, which has a 255 character limit, which I expect explains the garbage after this point.
首先，撤退和撤退是什么意思？我搜索了六个编程词典，但没有找到任何术语。这个（我假设）函数 Myf1：func 是做什么的？涉及的字段显然被定义为一个文本字段，它有255个字符的限制，我希望在此之后解释垃圾。
First off, what does retreated and retreatement mean? I''ve searched thru half a dozen programming dictionaries and found neither term. And what does this (I assume) function Myf1:func do? The involved field is obviously defined as a text field, which has a 255 character limit, which I expect explains the garbage after this point.
Retreatement - 使用函数更改字符串
但是我不认为你需要更改字符串的函数因为它工作正常
然而没有pbs可以看到它：
Retreatement - changing a string using function
However i don'' think that u need the function that changes the string coz it works correctly
However no pbs to see it:
要有清晰的视图
查询数据表显示：
$ b $bГЕРГАНА，ЛОЗАНОВА，ЛАКПРОМАД,,, ХИМИЧЕСКА,,, 9963055 ,,,,,,,,СИНЧЕЦ16,,,СОФИЯ,,,,,,,,,,,,,,,,,СРЕЩАНА08; 05; 06.，ПРОДУКТИНАПЕПСИКОЛА; СОКОВЕПРИСАН; ГАЗИ
这是一个很好的信息
直到myr（i）
只给出正确的255人物和他们之后的人物如下：
??? ???? ？ ?? ,,,, ?????直到相应字符串的结尾
对我来说，不是字符串定义长度的问题！
To have clear view
the query datasheet displays:
ГЕРГАНА,ЛОЗАНОВА,ЛАКПРОМ АД,,,ХИМИЧЕСКА,,,9963055,,,,,,,,СИНЧЕЦ 16,,,СОФИЯ,,,,,,,,,,,,,,,,,СРЕЩА НА 08;05;06.,ПРОДУКТИ НА ПЕПСИ КОЛА; СОКОВЕ ПРИСАН; ГАЗИ
that is good information
till myr(i)
gives correctly only 255 characters and after them caracthers like:
??? ???? ? ??,,,, ????? till the end of the respective string
For me not question of a string definition length!
这篇关于第255个字符后的字符长度超过255个字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
