我想取一条SQL语句中字段名和表名的值放到数组中。如:
select frist,second,third from table where frist='***'
把frist,second,third和table放置到数组中,where子句忽略
谢谢各位高手!!!!!!
select frist,second,third from table where frist='***'
把frist,second,third和table放置到数组中,where子句忽略
谢谢各位高手!!!!!!
解决方案 »
- 能否让MDIChild为另一个FROM的MDIFROM,另一个FROM为他的MDIChild?
- 谁知道Imail密码加密的算法啊?
- VB中打开和关闭文件的错误处理方法!(散分)
- XPsuite 和 Codejock 有在中国销售吗?
- 请教VB打包安装问题
- 用VB数据管理器建的ACCESS,怎么在WINDOWS下打不开啊 。反过来也是一样.咱们搞的啊?
- 如何取得本地机器的名称,不一定有IP的!
- 在VBA中加DATAGRID控件,在窗口中用时,报错????!急,在线等待
- Visual Basic 插件开发人员指南(Gene Swartzfager)附带的CD有多大
- 我的感觉VB很cool,但总有些人对VB说三道四的,认为只要不太傻,都能学会VB,
- 小问题:如何将TXT文件中的数据读取到数组中?
- 我的是中专文凭,会计专业,,,,自学VB,成功开发过工资管理和进销存管理
arr(0) = rs.fields(0).name
arr(1) = rs.fields(1).name
arr(2) = rs.fields(2).name
表名不知道怎么取
rs.fields(0).name錶示第一個字段名!
rs.fields(0).value錶示第一個字段的值!
不同的!
我需要把字符串select frist,second,third from table where frist='***'
截取出来。我并不需要求出结果后才把字段名求出来!!!
Private Sub Form_Load()
Dim arrField, arrTable
Dim strTemp, strField, strTable As String
Dim intStar, intEnd As Integer
strTemp = "select frist,second,third from table where frist='***'"
intStar = InStr(1, strTemp, "select")
intEnd = InStr(1, strTemp, "from")
strField = Mid(strTemp, intStar + 6, intEnd - intStar - 6) ' 6是select的长度
arrField = Split("frist,second,third", ",")
strTable = Right(strTemp, intEnd - 4) '4是from的长度
arrTable = Split(strTable, " ")
For i = 0 To UBound(arrField)
Text1.Text = Text1.Text & arrField(i) & " "
Next
Text1.Text = Text1.Text & arrTable(0)
End Sub
然后用rscon.fields.item(x).name去取出相应的字段名啊!如果你还是觉得麻烦的,倒不如建立多一个表里面就放一些你想要的字段名,那样的话修改或者使用起来都方便,不需要经常对字段名进行修改。
Dim s1 As String, a As String
s1 = "select frist,second,third from table where frist='***'"
a = Trim(Mid(s1, InStr(s1, "select") + 6, InStr(s1, "from") - 8))
Dim i As Integer, j As Integer
i = 0
j = 0
For k = 1 To Len(a)
If Mid(a, k, 1) = "," Then j = j + 1
Next
Dim s2() As String
ReDim s2(j) As String
Do While InStr(a, ",") > 0
s2(i) = Left(a, InStr(a, ",") - 1)
a = Right(a, Len(a) - Len(s2(i)) - 1)
i = i + 1
Loop
s2(i) = a
Dim s1 As String, a As String
dim arraystr() as string
s1 = "select frist,second,third from table where frist='***'"
a = Trim(Mid(s1, InStr(s1, "select") + 6, InStr(s1, "from") - 8))
arraystr=split(a,",")