如何更改firebird3中的列类型(How change a column type in firebird3)
由于firebird 3我不能修改列类型
在我使用这种更新之前:
update RDB$RELATION_FIELDS set RDB$FIELD_SOURCE = 'MYTEXT' where (RDB$FIELD_NAME = 'JXML') and (RDB$RELATION_NAME = 'XMLTABLE')
因为我得到ISC错误335545030。
也许火鸟3有另一种方式?
Since firebird 3 I can't modify a column type
Before I use this kind of update :
update RDB$RELATION_FIELDS set RDB$FIELD_SOURCE = 'MYTEXT' where (RDB$FIELD_NAME = 'JXML') and (RDB$RELATION_NAME = 'XMLTABLE')
because I get ISC error 335545030.
Maybe there is another way in firebird 3 ?
原文:https://stackoverflow.com/questions/48267131
满意答案
目前还不清楚你打算做什么,但代码完全按照你的要求去做。
AC“string”是一系列以null值结尾的
char
元素。 无论什么后面的空值不是字符串的一部分。通话前的字符串:
“9210070627”(后跟一个空值,以及一系列可能属于缓冲区或调试器工件的空值,我们不知道)。
你的来电:
strcpy(buffer, "")
(将空字符串复制到缓冲区,并以null值终止)通话后你的字符串:
“” - 一个空字符串,后跟终止空值(加上“210070627”和前一个内容中剩余的空值作为工件,如上所述,这些工件不属于字符串的一部分)。
因此,您的缓冲区现在包含一个空字符串,如您所指示的那样。 它还包含原始数据的剩余部分,但
buffer
确实指向空字符串。strlen( buffer ) == 0
。It is unclear what you intended to do, but the code does exactly what you told it to do.
A C "string" is a series of
char
elements that ends with a null value. Whatever comes after that null value is not part of the string.Your string before the call:
"9210070627" (followed by a null value, and a series of null values that might be part of the buffer or an artifact of the debugger, we don't know).
Your call:
strcpy(buffer, "")
(copy empty string into buffer, and terminate with null value)Your string after the call:
"" -- an empty string, followed by the terminating null value (plus the "210070627" and null values remaining from the previous content as artifacts which aren't part of the string as mentioned above).
So, your buffer now contains an empty string, as you instructed. It also contains remains of the original data, but
buffer
does point to an empty string.strlen( buffer ) == 0
.If you are intending to erase the contents of the buffer, i.e. zero-out the whole buffer, you should try
memset()
.
相关问答
更多生成依赖于字符串散列的随机数(Generate random numbers that depend on string hash)
字符串结尾时的PHP字符串比较可以包含随机数(PHP string comparison when string ending can contain random numbers)
strcpy将随机数添加到空字符串(strcpy adding random numbers to empty string)
如何在python中打印100个随机数的“set”并将它们添加到空集()(how to print 100 random numbers of “set” in python and add them to empty set())
向数组添加随机数的问题(Issues with adding a random numbers to an array)
添加时如何选择两个没有进位的随机数(How to pick two random numbers with no carry when adding)
生成随机数,将它们添加到数组中,然后使用冒泡排序对它们进行排序(Generating random numbers, adding them to an array, and then sorting them using bubble sort)
将随机空字符串值添加到对象的日志(Log adding random null string value to object)
添加随机数会使它们更随机吗?(Does adding random numbers make them more random?)
在JavaScript中生成字符串中的随机数(Generate random numbers from string in JavaScript)
相关文章
更多ServletOutputStream cannot be resolved to a type
Create a Bootable MicroSD Card
Becoming a data scientist
maven项目使用SOLR时报 previously initiated loading for a different type with name "javax/servlet/http/HttpServletRequest" 错的解决方法
Spring Data: a new perspective of data operations
Solr: a custom Search RequestHandler
HTML 超链接(a标签、锚)
按钮样式
Securing Solr on Tomcat access using a user account
最新问答
更多您如何使用git diff文件,并将其应用于同一存储库的副本的本地分支?(How do you take a git diff file, and apply it to a local branch that is a copy of the same repository?)
将长浮点值剪切为2个小数点并复制到字符数组(Cut Long Float Value to 2 decimal points and copy to Character Array)
OctoberCMS侧边栏不呈现(OctoberCMS Sidebar not rendering)
页面加载后对象是否有资格进行垃圾回收?(Are objects eligible for garbage collection after the page loads?)
codeigniter中的语言不能按预期工作(language in codeigniter doesn' t work as expected)
在计算机拍照在哪里进入
使用cin.get()从c ++中的输入流中丢弃不需要的字符(Using cin.get() to discard unwanted characters from the input stream in c++)
No for循环将在for循环中运行。(No for loop will run inside for loop. Testing for primes)
单页应用程序:页面重新加载(Single Page Application: page reload)
在循环中选择具有相似模式的列名称(Selecting Column Name With Similar Pattern in a Loop)
Copyright ©2023 peixunduo.com All Rights Reserved.粤ICP备14003112号
本站部分内容来源于互联网,仅供学习和参考使用,请莫用于商业用途。如有侵犯你的版权,请联系我们(neng862121861#163.com),本站将尽快处理。谢谢合作!