I’m using: SWI-Prolog version ???
I want the code to: insert an average to mysql, but it btings out an error.
What I’m getting, my ODBC and MYSQL is:
My code looks like this:
conexion12:-
odbc_connect('tienda_swi',_,
[user(root),
password('root'),
alias(tienda_swi),
open(once)]).
insertar_registros(X,Y):-
odbc_query(tienda_swi,"INSERT INTO promedio(apellido, prom) VALUES(`~w`,`~w`)"-[X,Y],
affected(F)).
parcial1(X,A,B,C,Y):-
Y is round((A+B+C)/3),apru(Y),
insertar_registros(Y,X).
apru(Y):- Y =< 10.4, write('Desaprobo.').
apru(Y):- Y >= 10.5, write('Aprobo.').