在线更新字段属性 [英] Updating Field Properties Online
问题描述
早上好。伙计。
我想知道我是否在合适的地区找到能够帮助我解决问题的Access大师。
我有一个数据库驱动的网站我希望改变其中一个表字段默认属性而不必下载整个数据库修改字段并再次上传。 （打扰访客）。我知道有一个DBS脚本参考，但找不到任何信息来帮助我。
1.表名是VILLAGE
2.字段是E_HOUSE（数字数据类型）
3.我需要设置默认值属性1
4.修改所有记录，使它们为1
我看到一些与此类似的脚本，并想知道是否有人可以提供正确的脚本：
[ALTER] VILLAGE ALTER＃E_HOUSE＃int＃NULL＃1＃ALTER＃E_HOUSE #default＃1＃END
我通过网站控制面板试过这个脚本它没有做我需要的。控制面板与提供的其他DBS脚本一起使用。
非常感谢任何帮助
rgds andy
Good morning folks.
I wonder if I am in the right area to find an Access guru who could help solve my problem.
I have a database driven website which I am looking to alter one of the table field default properties without having to download the whole database amend the field and upload again. (upset the visitors) . I understand there is a DBS script reference around but can not find any info to help me.
1. The table name is VILLAGE
2. The field is E_HOUSE (number datatype)
3. I need to set the default value property to 1
4. Amend all records so that they are 1
I have seen some script similar to this and wonder if someone could provide the correct script:
[ALTER] VILLAGE ALTER#E_HOUSE#int#NULL#1# ALTER#E_HOUSE#default#1# END
I have tried this script through the website control panel and it does not do what I need. The control panel works with other DBS script provided.
Any help would be greatly appreciated
rgds andy
推荐答案
大家早上好。
我想知道我是否在适当的地方找到一位可以帮助我解决问题的Access大师。
我有一个数据库驱动的网站我希望改变其中一个表字段默认属性而不必下载整个数据库修改字段并再次上传。 （打扰访客）。我知道有一个DBS脚本参考，但找不到任何信息来帮助我。
1.表名是VILLAGE
2.字段是E_HOUSE（数字数据类型）
3.我需要设置默认值属性1
4.修改所有记录，使它们为1
我看到一些与此类似的脚本，并想知道是否有人可以提供正确的脚本：
[ALTER] VILLAGE ALTER＃E_HOUSE＃int＃NULL＃1＃ALTER＃E_HOUSE #default＃1＃END
我通过网站控制面板试过这个脚本它没有做我需要的。控制面板与提供的其他DBS脚本一起使用。
我们将非常感谢任何帮助
rgds andy
Good morning folks.
I wonder if I am in the right area to find an Access guru who could help solve my problem.
I have a database driven website which I am looking to alter one of the table field default properties without having to download the whole database amend the field and upload again. (upset the visitors) . I understand there is a DBS script reference around but can not find any info to help me.
1. The table name is VILLAGE
2. The field is E_HOUSE (number datatype)
3. I need to set the default value property to 1
4. Amend all records so that they are 1
I have seen some script similar to this and wonder if someone could provide the correct script:
[ALTER] VILLAGE ALTER#E_HOUSE#int#NULL#1# ALTER#E_HOUSE#default#1# END
I have tried this script through the website control panel and it does not do what I need. The control panel works with other DBS script provided.
Any help would be greatly appreciated
rgds andy
嗨Andy
此脚本是否实际更改了默认值。即如果添加新记录，则字段默认为1.更改现有记录将是不同的脚本。
Mary
Hi Andy
Does this script actually alter the default. i.e. if you add a new record does the field default to 1. Changing existing records will be a different script.
Mary
嗨
我使用了代码，似乎什么都没有用，而且我在脚本之后做的就是更改默认值并将所有记录修改为1
任何帮助都是赞赏。
andy
Hi
I used the code and nothing seems to work, and it is what I am after the script to do both changing the default value and amend all records to 1
Any assistance would be appreciated.
andy
早安的人们。
我想知道我是不是我在正确的区域找到一个可以帮助解决我的问题的Access大师。
我有一个数据库驱动的网站，我希望改变其中一个表字段默认属性而无需下载整个数据库修改字段并再次上传。 （打扰访客）。我知道有一个DBS脚本参考，但找不到任何信息来帮助我。
1.表名是VILLAGE
2.字段是E_HOUSE（数字数据类型）
3.我需要设置默认值属性1
4.修改所有记录，使它们为1
我看到一些与此类似的脚本，并想知道是否有人可以提供正确的脚本：
[ALTER] VILLAGE ALTER＃E_HOUSE＃int＃NULL＃1＃ALTER＃E_HOUSE #default＃1＃END
我通过网站控制面板试过这个脚本它没有做我需要的。控制面板与提供的其他DBS脚本一起使用。
非常感谢任何帮助
rgds andy
Good morning folks.
I wonder if I am in the right area to find an Access guru who could help solve my problem.
I have a database driven website which I am looking to alter one of the table field default properties without having to download the whole database amend the field and upload again. (upset the visitors) . I understand there is a DBS script reference around but can not find any info to help me.
1. The table name is VILLAGE
2. The field is E_HOUSE (number datatype)
3. I need to set the default value property to 1
4. Amend all records so that they are 1
I have seen some script similar to this and wonder if someone could provide the correct script:
[ALTER] VILLAGE ALTER#E_HOUSE#int#NULL#1# ALTER#E_HOUSE#default#1# END
I have tried this script through the website control panel and it does not do what I need. The control panel works with other DBS script provided.
Any help would be greatly appreciated
rgds andy
以下代码已经过全面测试并且确实有效。有一些假设：
__ 1。数据库名称：My Village.mdb
__ 2。数据库路径： C：\Test \ Myy Village.mdb
__ 3 表名：VILLAGE
__ 4。字段名称：E_HOUSE
The following code has been thoroughly tested and does work. There are certain assumptions made:
__1. Database Name: My Village.mdb
__2. Database Path: C:\Test\My Village.mdb
__3 Table Name: VILLAGE
__4. Field Name: E_HOUSE
这篇关于在线更新字段属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
