No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
invalid sql statement,expected "delete","insert","procedure","select" or "update" it a run time error which i recieve when an saving a record to the database. and this is the code. [B]rsord.Open "order", cnnord, adOpenKeyset, adLockPessimistic[/B] cnnord.Execute "INSERT INTO order(OrderId,DateOrdered,CustomerId,QuatityOrdered,ProductTitle,PurchasedUnitPrice);" _ & "VALUES('" & txtoid.Text & "','" & txtod.Text & "','" & txtcid.Text & … |
|
hi brother i have a code which saves arecord but it gives an error syntax in insert in to statement. this is ma code. arequest for a collection or an alternative code. Private Sub cmdsave_Click() Dim findpas As String Dim cnnadd As ADODB.Connection Dim rsadd As ADODB.Recordset Set cnnadd = … |
|
dear brothers i have a problem in saving ma data in the database.so i need help thanks. |
|
[B][B]hi brothers i need to know how to save and delete records i adodb[/B]. |
|
[B]hi brothers i want to know how some one can design a form to allow a user to login and use his system and also how to change the user accont for other users[/B] |