Back to General and Gameplay Programming

mySQL programming: Field not updatable?

Sand_Hawk · 2002-06-07T08:15:56

I created an application in VB for school. I use an mySQL database. But when I try to write to at least 2 tables(Haven't tested the others yet) I get the error: Runtime error '3113': Cannot update 'Leveranciersnummer'; field not updatable This are the settings of the field: Type: BigInt Length/set: 10 Default: 0 Unsigned, not null The other field in another table is a varchar(40) with NOT NULL set. When I try to paste in the SQL code generated by the program in the mySQL console it works fine. I'm logged in over ODBC as use root on the localhost. [EDIT] Here is some source: 'Open the database: Set DB = OpenDatabase("Posthuis", dbDriverNoPrompt, True, _ "ODBC; DATABASE=Posthuis; DSN=Posthuis") 'Create a Query, it's the smallest I have for you guys: strSQL = "INSERT INTO Brochure(LeveranciersNummer, Naam, Voorraad, " & _ "Opbrengst1000, MinVoorraad, AutoBestel, Actief) VALUES(" & _ LeverancierNummer & ", '" & txtNaam.Text & _ "', " & CInt(txtStartVrd.Text) & ", " & CDbl(txtOpbrengst) & ", " & _ txtMinVrd.Text & ", " & AutoBestel & ", " & Actief & ")" 'Execute the Query: call DB.execute(strSQL) I use an myODBC driver wich logins as root. Reading the userset for the program from the database works, but adding is a problem. Has this something to do with table locking? [/EDIT] Sand Hawk ---------------- -Earth is 98% full. Please delete anybody you can. [edited by - sand_hawk on June 5, 2002 4:45:52 PM]

General and Gameplay Programming Programming

Started by Sand_Hawk June 05, 2002 10:48 AM

9 comments, last by Sand_Hawk 21 years, 10 months ago

Sand_Hawk

108

Author

June 07, 2002 08:15 AM

*ashamed* It found the problem. We opened the database as readonly. I walked thru the code with a teacher and found out the DB was opened as Read-only. *smacks himself on the forehead*

Thanks for all the time you guys spend on me.

Sand Hawk

----------------
-Earth is 98% full. Please delete anybody you can.

----------------(Inspired by Pouya)

mySQL programming: Field not updatable?

This topic is closed to new replies.

Popular Topics

Recommended Tutorials

mySQL programming: Field not updatable?

This topic is closed to new replies.

Popular Topics

Recommended Tutorials

Reticulating splines