首页 \ 问答 \ 如何更改firebird3中的列类型(How change a column type in firebird3)

如何更改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
更新时间:2023-11-16 19:11

最满意答案

目前还不清楚你打算做什么,但代码完全按照你的要求去做。

AC“string”是一系列以null值结尾的char元素。 无论什么后面的空值不是字符串的一部分。

通话前的字符串:

“9210070627”(后跟一个空值,以及一系列可能属于缓冲区或调试器工件的空值,我们不知道)。

你的来电:

strcpy(buffer, "") (将空字符串复制到缓冲区,并以null值终止)

通话后你的字符串:

“” - 一个空字符串,后跟终止空值(加上“210070627”和前一个内容中剩余的空值作为工件,如上所述,这些工件不属于字符串的一部分)。

因此,您的缓冲区现在包含一个空字符串,如您所指示的那样。 它还包含原始数据的剩余部分,但buffer 确实指向空字符串。 strlen( buffer ) == 0

如果您打算擦除缓冲区的内容,即将整个缓冲区memset() ,则应尝试memset()


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().

相关问答

更多

相关文章

更多

最新问答

更多
  • 获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
  • 如何通过引用返回对象?(How is returning an object by reference possible?)
  • 矩阵如何存储在内存中?(How are matrices stored in memory?)
  • 每个请求的Java新会话?(Java New Session For Each Request?)
  • css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
  • 无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
  • xcode语法颜色编码解释?(xcode syntax color coding explained?)
  • 在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
  • 从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
  • 从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
  • 西安哪有PLC可控制编程的培训
  • 在Entity Framework中选择基类(Select base class in Entity Framework)
  • 在Android中出现错误“数据集和渲染器应该不为null,并且应该具有相同数量的系列”(Error “Dataset and renderer should be not null and should have the same number of series” in Android)
  • 电脑二级VF有什么用
  • Datamapper Ruby如何添加Hook方法(Datamapper Ruby How to add Hook Method)
  • 金华英语角.
  • 手机软件如何制作
  • 用于Android webview中图像保存的上下文菜单(Context Menu for Image Saving in an Android webview)
  • 注意:未定义的偏移量:PHP(Notice: Undefined offset: PHP)
  • 如何读R中的大数据集[复制](How to read large dataset in R [duplicate])
  • Unity 5 Heighmap与地形宽度/地形长度的分辨率关系?(Unity 5 Heighmap Resolution relationship to terrain width / terrain length?)
  • 如何通知PipedOutputStream线程写入最后一个字节的PipedInputStream线程?(How to notify PipedInputStream thread that PipedOutputStream thread has written last byte?)
  • python的访问器方法有哪些
  • DeviceNetworkInformation:哪个是哪个?(DeviceNetworkInformation: Which is which?)
  • 在Ruby中对组合进行排序(Sorting a combination in Ruby)
  • 网站开发的流程?
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 条带格式类型格式模式编号无法正常工作(Stripes format type format pattern number not working properly)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。