14 Replies
Yes, this is parameterized.
I would make the
cmd
variable local instead of using a shared variable.
What does GetDatabaseConnection1
do and why are you calling it at the end of the method?to be honest im not entirely sure this is just me cutting and pasting different CRUD tutorials together
ohhhhh nvm
it literally just finds the database like for the connection?
Do you need to do that again? It doesn't sound like it but I dunno.
ill probs remove it but also upon actually testing it
it doesnt seem to actually insert anything into my database
What makes you say that? How are you validating that the insert worked?
opening... the database?? in access
It looks like you are missing a
)
at the end of your insert statement. You aren't getting an error when running it?nvm I wasnt even running the subroutine
early morning coding is the death of me
It happens. š
mmmmm okay now im getting that the number query values and destination fields are not the same
I think thats cause Ive skipped the ID of the table as a query but I thought that was auto assigned by access
or do u have to make ur own when inserting?
@studentId
, if that is auto-assigned you don't need it in the second part of the statementyep that definitely could be it
System.Data.OleDb.OleDbException: 'Data type mismatch in criteria expression.'
welp thats a new exception atleast
hahaha
check where you are adding
@yeargroup
I don't think you want to add a textbox
šohhhhhhhhhhhhh
lmao
tho that is something I need to fix anyway cause year group would be 7-13 whereas form group is 7-13 + letters
p sure technically what im modelling should only have every other letter up to O? but I cant really remember and the examiner doesnt know that haha
its still when I check it in the database but ima leave it for a bit tbh
thank you for ur help