The opinions expressed here are my own and are not necessarily those of my employer, partners, customers, friends, family, or pet dog.
All content is presented AS-IS, with ABSOLUTELY NO WARRANTY expressed or implied.
I need a solution to a problem and I guess you’ll be able to crack it. Any help is appreciated.
I get this error when I run my VB Program.
“The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.”
•What my program should do is
1) User inputs text into a text box and hits the search button.
2) Result is populated into the GridView (Access database is being used). Result being – Contains the entered term in a string.
Private Sub Button2_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button2.Click
Dim dtATG As New DataTable() ‘ Create New Datatable
dbDataAdapter = New OleDbDataAdapter ( “SELECT FROM ATG WHERE Term Like ‘*” & (TextBox1.Text) & “*'”, _ ConnectString)
DataGrid1.DataSource = dtATG
The answer is easy but it looks like it would be a long discussion and spoils the purpose of a guestbook.
Forums are more appropriate for such Q/A & discussions.
Can you please create a thread here and PM me a link to the thread? VB Forums (VB.NET section)
Me or anyone else there would be glad to help you out with your problems. My user handle on that forum is pradeep1210
I was hoping you could help me, I need to run a console app when clicking a button in a form and need it to write the output into a .xml file, not sure of the best way to do this.
Also i need to replace a line of text in the file created that is always the same as the output while is formatted for xml does not have the xml opener at the top.
This is the code i have so far which will run the app with the arguements need.
Any chance you could help me?
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim process1 As New Process()
process1.StartInfo.UseShellExecute = False
process1.StartInfo.FileName = “app.exe”
process1.StartInfo.Arguments = “-x a default.ext”
process1.StartInfo.CreateNoWindow = False
process1.StartInfo.RedirectStandardOutput = True
I have been using your query Executing a set of SQL Script Files (*.sql) on a Group of SQL Server Databases in my production environment since a month recently i found out that if we omit
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
in a stored procedure the and execute your script SET QUOTED IDENTIFIER is turning OFF
can u plz let me know where i have to modify to make the old settings as it is?
Many Thanks for your query it is saving lot of my time
(update statement looks like above)
there are several Procedures kept in a folder without mentioning SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
in old procedure QUOTED_IDENTIFIER is ON in updated procedure the QUOTED_IDENTIFIER is OFF