CODEWITHSUNDEEP
sqladvantage-database-server
Nuno Agapito
Nuno Agapito

Reputation: 230

Advantage SQL INSERT error

I'm trying to insert a row in a table on an Advantage SQL Server and I keep getting this error:

Error 7200: AQE Error: State = S0000; NativeError = 2124;
[Extended Systems][Advantage SQL Engine]Invalid operand for operator: 

INSERT INTO CardExe
  (COD_EXAME,COD_MED,DATA_EXAME,DNT_NUM,ESTADO,HORA_EXAME,NUM_EPS,NUM_MARCA,QTD_EXAME) 
VALUES
  ('C40315','2854',{d '2011-10-17'},'420929F2','R',{t '11:40:00'},'45,0','2006116583',1)

What am I doing wrong?

Upvotes: 0

Views: 2135

Answers (1)

Sparky
Sparky

Reputation: 15085

What type of data field is NUM_EPS? It appears you are putting 45,0 into it.

MIGHT be the cause of the problem

Upvotes: 4

Related Questions