vb program insert into >>problem

[skeptic_rob]

---

Private Sub cmdsave_Click()
Dim rs As New ADODB.Recordset
Dim sqlstr As String

rs.Open sqlstr, Conn, adOpenDynamic, adLockOptimistic

sqlstr = " insert into user_act(id,password,uname,date)Values ('"&txtid.text&"','"&txtpassword.text"','"&txtunam e.text&"','#"&txtdate.text&"#)"


unsa sayop ani bro...dli man maka save cya data sa database? expert i need ur help

[dodie]

You have to be careful with QUOTES single ' or double " . Make sure they are not in conflict.

Proper use of concatination and string manipulation. Use escape characters like \" or \' depends on which QUOTE container you are using.

*SQL itself is using QUOTES for values.
*Programming language like VB is also using QUOTES to manipulate strings.

Be sure that your syntaxes are not in conflict at the final output. Use logging or debugging techniques to monitor your activity.

I see something missing here..

('"&txtid.text&"','"&txtpassword.text"','"&txtuname.text&"','#"&txtdate.text&"#)"

[pridi]

try to manually insert through your code... kanang sure jud ka nga maka insert ayaw sa nang via textboxes or unsa, then ayha i hinay2x ug replace... and yes, usually, ang quotes maoy mo dala ug yagaw...

[emmhai]

i limpyo gamay imo codes bro.. malipat jud ka ana kay sigkit ra kaayu... pahamak sad baya kaayu na ang quotes... mao jud na masayupan nako... then pag open nimo sa imo recordset mas maayu sa form load na nimo ibutang para kaisa ra

[skeptic_rob]

Dim rs As New ADODB.Recordset
Dim rsRet As New ADODB.Recordset
Dim sqlStr As String

If NewEdit = 0 Then 'Insert New record

sqlStr = "SELECT * FROM user_act WHERE id='" & txtid.Text & "'"
rsRet.Open sqlStr, Conn, adOpenForwardOnly, adLockReadOnly

If rsRet.EOF Then
rsRet.Close
sqlStr = "INSERT INTO user_act(id,password,uname) VALUES '" & Val(txtid.Text) & "','" & Left(txtpassword.Text, 20) & "'," & Left(txtuname.Text, 50) & ")"
rs.Open sqlStr, Conn, adOpenDynamic, adLockOptimistic

MsgBox "One record saved!", vbInformation, Me.Caption
rsRet.Close
MsgBox "Duplicate Stock Code. Please review your entries!!", vbCritical, Me.Caption
End If
End If

[skeptic_rob]

iyang error data type mismatch daw in criteria expression...im not to familiar with the syntax error..

[skeptic_rob]

Private Sub cmdsave_Click()
Dim rs As New ADODB.Recordset
Dim sqlstr As String

rs.Open sqlstr, Conn, adOpenDynamic, adLockOptimistic

sqlstr = " insert into user_act(id,password,uname,date)Values ('"&txtid.text&"','"&txtpassword.text"','"&txtunam e.text&"','#"&txtdate.text&"#)"


unsa sayop ani bro...dli man maka save cya data sa database? expert i need ur help

syntax error in INSERT INTO statement

[pridi]

Private Sub cmdsave_Click()


sqlstr = " insert into user_act(id,password,uname,date)Values ('"&txtid.text&"','"&txtpassword.text"','"&txtunam e.text&"','#"&txtdate.text&"#)"

try force insert daw, sqlstr = " insert into user_act(id,password,uname,date)Values ('a','b','c',2010-06-2 kung mo sugot ba cya... more on the datatype sa imong i insert ang ga conflict...

[tynum]

Private Sub cmdsave_Click()
Dim rs As New ADODB.Recordset
Dim sqlstr As String

rs.Open sqlstr, Conn, adOpenDynamic, adLockOptimistic

sqlstr = " insert into user_act(id,password,uname,date)Values ('"&txtid.text&"','"&txtpassword.text"','"&txtunam e.text&"','#"&txtdate.text&"#)"


unsa sayop ani bro...dli man maka save cya data sa database? expert i need ur help

bro... see dodie's post... and try it... or try this sqlString

sqlstr = " insert into user_act(id,password,uname,date)Values (' "&txtid.text&" ',' "&txtpassword.text&" ',' "&txtuname.text&" ',' "&txtdate.text&" ')"

[sunduwu]

Private Sub cmdsave_Click()
Dim rs As New ADODB.Recordset
Dim sqlstr As String

rs.Open sqlstr, Conn, adOpenDynamic, adLockOptimistic

sqlstr = " insert into user_act(id,password,uname,date)Values ('"&txtid.text&"','"&txtpassword.text"','"&txtunam e.text&"','#"&txtdate.text&"#)"


unsa sayop ani bro...dli man maka save cya data sa database? expert i need ur help

unsay gamit nimo ani nga database?

try to change the date sa imo dbase like sDate... kay nag.sa mag.conflict na sila sa dbase command ug ang field declaration

i hope makatabang ang ako idea