Victor Charles
asked on
Help with error in Query
Hi,
I'm using code in part A but for some reason the third data element causes a syntax error, For example:
Msgbox (query40s) displays:
Fiel1 = 'TextBox1.Text' or Field2 = 'TextBox1.Text; or Field3Field4 = "TextBox1.Text"; or Field5 = 'TextBox1.Text'
The xml file is well formatted, can't figure out why two data fields are combined in the OR statement.
code:
fsLinkAOP40 = New System.IO.FileStream(Appli cation.Sta rtupPath + "\APS.xml", IO.FileMode.Open)
dtsetLinkAOP40.ReadXml(fsL inkAOP40)
fsLinkAOP40.Close()
Dim FilteredDTA40 As DataTable
FilteredDTA40 = dtsetLinkAOP40.Tables(0)
Dim view40ss As DataView
Dim query40s As String = ""
query40s = FilteredDTA40.Columns(0).C olumnName & "='" & FormGlobalMain.TextBox1.Te xt & "'"
For x = 1 To FilteredDTA40.Columns.Coun t - 1
query40s &= " OR " & FilteredDTA40.Columns(x).C olumnName & "= '" & FormGlobalMain.TextBox1.Te xt & "'"
Next
I'm using code in part A but for some reason the third data element causes a syntax error, For example:
Msgbox (query40s) displays:
Fiel1 = 'TextBox1.Text' or Field2 = 'TextBox1.Text; or Field3Field4 = "TextBox1.Text"; or Field5 = 'TextBox1.Text'
The xml file is well formatted, can't figure out why two data fields are combined in the OR statement.
code:
fsLinkAOP40 = New System.IO.FileStream(Appli
dtsetLinkAOP40.ReadXml(fsL
fsLinkAOP40.Close()
Dim FilteredDTA40 As DataTable
FilteredDTA40 = dtsetLinkAOP40.Tables(0)
Dim view40ss As DataView
Dim query40s As String = ""
query40s = FilteredDTA40.Columns(0).C
For x = 1 To FilteredDTA40.Columns.Coun
query40s &= " OR " & FilteredDTA40.Columns(x).C
Next
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER