怎么样用程序修改 DBASE V 的 DBF数据库结构 怎么样用程序修改 DBASE V 的 DBF数据库结构 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Dim MyTable As TableDef, MyField As Field Dim MyDatabase As Database Dim MyPath As String Dim Name As String MyPath = "d:\data" Name = "Rs200112.dbf" Set MyDatabase = OpenDatabase(MyPath, False, False, "dBase 5.0;") If Dir(MyPath & "\" & Name) <> "" Then Kill MyPath & "\" & Name End If Set tdfNew = MyDatabase.CreateTableDef(Name) tdfNew.Fields.Append tdfNew.CreateField("ZGBM", dbText, 10) tdfNew.Fields.Append tdfNew.CreateField("BMNO", dbText, 10) tdfNew.Fields.Append tdfNew.CreateField("SKRQ", dbText, 10) tdfNew.Fields.Append tdfNew.CreateField("SKSJ", dbText, 50) tdfNew.Fields.Append tdfNew.CreateField("ZGKH", dbText, 6) tdfNew.Fields.Append tdfNew.CreateField("BZ", dbText, 2) MyDatabase.TableDefs.Append tdfNew 'open text fileopen "text1.txt" for input as #1'read data line #1,m_strclose(1)'create databaseset db_exp=workspaces(0).createdatabase("path/filename")'create tableset tb_exp=db_exp.createtable("tableanme")'create fields'create index'thendb_exp.execute "INSERT INTO tablename " _ & "(fields list[,])" _ & " VALUES(" & m_str & ");"'close databasedb_exp.close 请问,如何用sqldmo得到字段的默认值及说明? 有谁使用过VerticalMenu控件? 帮帮忙!关于用VBS提取index.dat 日历壁纸制作工作VB版源代码 请问如何在菜单中放入图片 关于VB控制驱动类问题 有关vb中spread的问题 关于编写一个机房管理程序的问题 vb中的sub如果要提前返回应该怎么写? MSHFlexGrid拷贝问题!送分哦! ADO执行SQL时的错误,进来看看吧 什么是EVB?
Dim MyDatabase As Database
Dim MyPath As String
Dim Name As String
MyPath = "d:\data"
Name = "Rs200112.dbf"
Set MyDatabase = OpenDatabase(MyPath, False, False, "dBase 5.0;")
If Dir(MyPath & "\" & Name) <> "" Then
Kill MyPath & "\" & Name
End If
Set tdfNew = MyDatabase.CreateTableDef(Name)
tdfNew.Fields.Append tdfNew.CreateField("ZGBM", dbText, 10)
tdfNew.Fields.Append tdfNew.CreateField("BMNO", dbText, 10)
tdfNew.Fields.Append tdfNew.CreateField("SKRQ", dbText, 10)
tdfNew.Fields.Append tdfNew.CreateField("SKSJ", dbText, 50)
tdfNew.Fields.Append tdfNew.CreateField("ZGKH", dbText, 6)
tdfNew.Fields.Append tdfNew.CreateField("BZ", dbText, 2)
MyDatabase.TableDefs.Append tdfNew