ODBC Error
lazarus / 16-Databases

----------------------------------------------------------------------
Ylmith · 2025-01-27 12:05

Hello,
i work on an app connecting with an Access database, i've been stuck
for 2 days with an error message from the ODBC driver
"...SQL error; record 1: SqlState : 42000; native error -3503..."
It is an update on a table, the ODBC doc says that it is either a
violation access or an error in the sql string.

I have another table for test and i can perfectly make the update with
the same code.
Can you see a difference between the script of the 2 updates...?

(It's a Case Of)

-- works perfectly fine
 'Test' : Result:= 'UPDATE t_ach_TEST SET
t1=:UP1x,t2=:UP2x,t3=:UP3x,t4=:UP4x,t5=:UP5x,t6=:UP6x,t7=:UP7x,'+ //7
  't8=:UP8x,t9=:UP9x,t10=:UP10x,t11=:UP11x,t12=:UP12x,t13=:UP13x,t14=:
UP14x ' + //7
  'WHERE lignes =:UP0x '; //1  

-- error message
 'Para' : Result:= 'UPDATE t_ach_PARA SET annee=:UP1x,mois=:UP2x,jour=
:UP3x,topic=:UP4x,items1=:UP5x,items2=:UP6x,moypay=:UP7x,' + //7
  'magasin=:UP8x,adresse=:UP9x,tel=:UP10x,mail=:UP11x,guar=:UP12x,euro
s=:UP13x,note=:UP14x ' + //7
  'WHERE lignes =:UP0x '; //1    

Thank you so much...

----------------------------------------------------------------------
Zvoni · 2025-01-27 13:26

And i'm pretty sure, that after the "native error -3503" there comes a
lot more information in the error message.

Because the SQL-Statements themselves look good.
What are you using for the Parameters?
An idea might be sending a String, where an integer is expected

And what ist that "Case of"?

EDIT: And which driver do you use?