如何将字段插入现有表中 [英] How to insert fields into an existing table

问题描述

我试图通过在现有表中按设定顺序插入一些新字段来更新一些现有数据库表。我遇到的问题是它将新字段插入现有的位置计数而不是基于累积计数的新位置。


例如，当插入所有四个新字段时，字段24被插入到表的末尾，该字段实际上是字段28。如何刷新表格以便在正确的位置插入字段

（希望这很清楚）

I am trying to update some existing database tables by inserting some new fields in a set order within the existing table. The issue I am having is it inserts the new field at the existing position counts and not at the new positions based on accumulative count.

For example field 24 is being inserted at the end of the table which is really field 28 when all four of the new fields are inserted. How can I refresh the table so that the fields are inserted at the right location
(Hope this is clear)

<跨度类= codeLink 的onclick = 模糊（此，this.parentNode.parentNode，的getChildren（本），TRUE）;>展开 <跨度类=codeDivider > | <跨度类= codeLink的onclick = 全选（本）;>选择 <跨度类= codeDivider> | <跨度类= codeLink 点击= 自动换行（在此）;>裹 <跨度类= codeDivider> | <跨度类= codeLink 的onclick = LineNumbers（本）;>行号

推荐答案

一点帮助......任何人???

A little help...Anybody???

你好蒂姆，


我会在周末试着看看这个。你正在做什么看起来应该可以工作，但无论我如何重新配置​​你的代码或M

Hello Tim,

I will try and look at this over the weekend. What you are doing appears like it should work but I get the same problem no matter how I reconfigure your code or what M

做什么，我都会遇到同样的问题。


如果只有一个字段的序数位置发生了变化，但任何后续的序数变化都没有达到预期的效果，那么它就有效。


就像我说的那样我会把它看过去周末 - 我只想确保订阅，所以我不会丢失此消息。


欢呼，

says to do.

It works if only one field''s ordinal position is changed but any subsequent ordinal changes don''t work aas expected.

Like I said I will look over it over the weekend - I just wanted to make sure I subscribed so I don''t lose this message.

cheers,

这篇关于如何将字段插入现有表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！