The primarykey in my general_billing table is autoincrement but when i call the function to add to the database, thy primarykey column wont autoincrement. Can some please give direction?

call from UIClass
   g_billing = new GeneralBilling(Nothing, "test","test", "test")

Dim connection As New Connection
        connection = New Connection
        MsgBox(getID)
        Dim sql_insert As String = "INSERT INTO general_billing"
"(serviceID, service_name, measurement_unit, cost) VALUES (" & _
           getID() & ", '" & getName & "', '" & getUnit & "', " & getCost & ");"
---------------------
general_billing.vb

connection.ConnectToDB(sql_insert)

__________________
gbilios

if the primary key is autoincrement, you dont need to pass the value in the sql statement.
Regards
Ganesh

I get a syntax error. Since i omitted the USerID(primary key), the insert statement fails. I am also using Ms Access and i tested the insert statement and didn't work. I added the insert statement in case anyone can tell me what is wrong.

Dim sql_insert As String = "INSERT INTO t_user(EmployeeID, username, password, level) VALUES(" & emp.getID() & ", '" & username & "', '" & password & "', " & level & ");"
connection.ConnectToDB(sql_insert)

heres the problem. the system didn't like the names username and password and so i changed it to t_username and t_password and level to a_level.

that worked.

you can put the field names as [UserName] and [Password] to solve that issue, if you want to use the same names

Regards
Ganesh