StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to make OleDB query read a colon :
text
Body
copied!<p>I am working on a GPS app and I need to parse the exploded string sent to the app.<br> however, SQL query in OleDB doesn't recognize <code>:</code> as a character. - <em>I think that's the error</em> </p> <p>I added a field, <code>Time</code> on my .accdb with text as data type...</p> <p>04T16:18:42Z </p> <p>that is the <em>time</em> data the gps is sending..<br> but I get syntax error if I am using that through (i just made this short, I use vb.net) -<br> <code>insert into myTable(Time) values ('" & txtTime.Text & "')</code><br> that is the query I use. I posted the error yesterday, and it seems that, that is the data that causes syntax error.<br> what should I do to make it work? Or maybe do something like change its time format, split, rewrite? the main goal is for me to save it to the database. thanks</p> <p><strong>UPDATE:</strong> this is my code for saving, could you re-arrange it with <code>parameters</code> --</p> <pre><code>query = "INSERT INTO tblGPSRoutes(Time,Latitude,Longitude,Elevation,Accuracy,Bearing,Speed)" query &= " VALUES ('" & txtTime.Text & "','" & txtLat.Text & "','" & txtLong.Text & "','" & txtElev.Text & "','" & txtAccuracy.Text & "','" & txtBearing.Text & "','" & txtSpeed.Text & "')" databaseFunctions.ExecuteQuery(query) MessageBox.Show("Data Saved Successfully.") </code></pre> <p><strong>UPDATE2:</strong> now I am using parameters :</p> <pre><code>Dim con As OleDbConnection con = New OleDbConnection con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = " & Path.Combine(Application.StartupPath, "markers.accdb") con.Open() Dim query As String = "INSERT INTO tblGPSRoutes(Latitude,Longitude,Elevation,Accuracy,Bearing,Speed) VALUES (@lat,@long,@elev,@acc,@bearing,@speed)" Using cmd As New OleDbCommand(query, con) With cmd.Parameters '.AddWithValue("@time", txtTime.Text)' .AddWithValue("@lat", txtLat.Text) .AddWithValue("@long", txtLong.Text) .AddWithValue("@elev", txtElev.Text) .AddWithValue("@acc", txtAccuracy.Text) .AddWithValue("@bearing", txtBearing.Text) .AddWithValue("@speed", txtSpeed.Text) End With cmd.ExecuteNonQuery() End Using </code></pre> <p>first says, syntax error.. then I removed the <code>time</code> data input. then it works.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload