Posts by Caffé • 17,429 points
254 posts
-
2
votes1
answer1518
viewsA: SQL Server Performance Loss with Sequential Insert
If the Primary key is clustered and a new record has a value earlier than those already in the database (example: last record inserted PK = 10,000, new record PK = 10) the server will need to…
-
1
votes1
answer1986
viewsA: Problem Inserting Into SQLITE Table Using RAD STUDIO XE6
The error occurs because your DBMS (or the user, or the connection...) is set to (or is in its nature) receive comma as decimal separator and not dot. Do not try to change this behavior. The key…
-
2
votes2
answers1876
viewsA: How to use sum with condition relative to another field
SELECT A.id_pessoa, SUM (N.nota) FROM NOTA N JOIN AVALIAÇÂO A on A.id_avaliacao = N.id_avaliacao WHERE ( A.segunda_avaliacao = 'N' AND NOT EXISTS ( …
-
3
votes1
answer373
viewsQ: How to change the language of the exceptions released during automated testing
Using Eclipse (IBM RAD Studio), Maven, and Junit, when an exception is released while running the tests the message is shown in English. I would like it to be shown in English. Example:…