Problem pri SQL prikaze accesovej databaze... – Visual Basic – Fórum – Programujte.com

Zdravim,

mam taky problem.

Mam modul a formular s niekolkmi textboxami, ktorych obsah chcem ulozit do databazy v accesi. Databaza je spojena s programom cez DSN a ODBC

Modul:

Public cn As rdoConnection



Sub main()

    Set cn = rdoEnvironments(0).OpenConnection(dsName:="NovaDatabaza", Prompt:=rdDriverNoPrompt)

    FormMain.Show

End Sub

Private Sub cmdUlozit_Click()

Dim strSQL As String

    strSQL = "INSERT INTO Pracovnik "

    strSQL = strSQL & "(meno, priezvisko, titul, plat, poznamka) VALUES ("

    strSQL = strSQL & "'" & Text1.Text & "', '"

    strSQL = strSQL & Text2.Text & "', '"

    strSQL = strSQL & Text3.Text & "', '"

    strSQL = strSQL & Text4.Text & "', '"

    strSQL = strSQL & Text5.Text & "');"

    cn.Execute strSQL, rdExecDirect

    Unload Me

End Sub

Run-time Error 40002:

2205: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria exxpression.

Chcem to zmazaaaaaaaaaaaaaaaaaaaaaaaaaat... Problem bol jednoduchy. Do stlpca s ciselnym datovym typom sa zapisovali znaky abecedy...