This error is usually due to a User Query (in list window, menu select).

Short term solution: Select the Standard Query.

Long term solution: Check that the order field is in the displayed fields

1. Error:E090: 23000 [Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: No primary key value for foreign key ’Product’ in table ’Dyelot_ColorRecipe_Line’ STMT:insert into Dyel
2. Exception EDBE Engine Error Invalid string or buffer length. You use a Sybase engine (not Sybase Server/Client) and no user is defined in BDE Administrator
3. Error BDE: Database not connected. General SQL error. [Sybase][ODBC driver][Adaptive Server Anywhere] Syntax error or access violation: Request to start/stop database
4. Key violation! Sybase ODBCDriver Adaptive server Anywhere Integrity constraint violation. Column ’Prodctrloperation_Id’ in table general sql error ’combprocess_treat_oper_crtloperlist’ cannot be null
5. Error 3070 when reading Black Trap
6. When I start Sybase server, I get the following error message: I/O error Fatal error: Unknown device error -- transaction rolled back
7. General SQL error. Sybase ODBC Driver Adaptive Server Anywhere Syntax error or access violation: Commit/Rollback not allowed within atomic operation
8. How to load Chroma-Calc under DOS or Windows
9. Error BC453RTL.DLL. Floating Point Invalid
10. Error: Start_IP.exe - Entry Point Not Found. The procedure entry point @Easysize@initialization$qqrv could not be located in the dynamic link library ITM_DataAccess.bpl.
11. Running Color Tools 1.3r3 or 1.3r4 on a Windows NT can cause error message : “Newlocale.dll not found.”
12. Hardware Problem or No security key Found
13. Unable to open file USERS.BTR
14. Cannot load BPROP20.DLL
15. The dyelot generation does not match with the combined process. Why?
16. Error: Start_IP.exe - Entry Point Not Found. The procedure entry point @Udmitmsecurity ... could not be located in the dynamic link library ITM_DBCommUnit.bpl.
17. When doing support over modem with pcAnywhere and opening Sybase central 4.0, Sybase central windows don’t refresh properly.
18. Error BC520RTL.DLL
19. When I am waiting for a generation preview, I get the error message: Exception violation ... in module RBRCL66.bpl ...
20. I am getting Paradox errors, when trying to retrieve a sample from my database, in ColorTools.
21. Error message = Please connect or reset your instrument !
22. How do I create and use a palette in Lab Paintmaker?
23. How can I print a RGB color?
24. What is ResetRegistry ?
25. E099 Invalid floating point operation
26. SQL Error : Integrity Constraint violation : column "NoOfWeights" in table "DyeLot_Bulked Recipe_Out" can’t be NULL
27. When I create a new dyelot, I get the error message Index does not exist !.
28. Error: PDOXUSRS.NET when creating a new record
29. The following message coming when the customer try to store the formula in the formula input : DCPPI provocó un fallo de protección general en el módulo MFC250.DLL de 0001:00001866 .
30. Unable to read white tile data ! White tile data failed !
31. Units kg/l (liquor ratio) and °C/min don’t appear in the pop up menu of the ITMRegistry. Why ?
32. How do I edit PFs in Lab Paintmaker?
33. Error AfxthrowDCIDBE Exception
34. I am using ColorTools with one instrument, how can I add a second spectrophotometer
35. After weighing products: Error Message: SQL Error: General Error: SELECT returns more than one row.
36. No match found!
37. Error messages while running DM 1.7.2 or earlier Formula Input, after storing the amounts,etc, then hitting save and the message shown is : "No valid Illum/Obs information. Please check your setu
38. Floating-point : divided by 0!
39. I have defined a query in table DYELOT but it doesn’t work (empty result).
40. Units kg/l (liquor ratio) and °C/min do not appear in the pop up menu of ITM Registry | System settings | Prod unit. Why?
41. I have done a user query in Dyelots but the result is always empty. Why?
42. Problem in correction options in DM PPI. When the customer try to put all the add in zero, and these numbers not changed!.
43. How can I test the alphanumeric value of a parameter?
44. We cannot delete one auxiliary. It will shown the error message: Delete not allowed! Auxiliaries : ARO-BLN--> 1 Inventory Operations ... We have checked all stock operations but none uses it. I get
45. Green tile fail in DM PPI
46. Unable to generate a dyelot or to customize a production form
47. When I start ITMRegistry, I get the error message:ExceptionEDBEEngine Error Invalid string or buffer length
48. Temporary files appear on the desktop during ITMProcess utilisation.
49. Floating-point : invalid.
50. I have loaded an ITMProcess expert level certificate but my ITMProcess is still in entry level
51. Some dyelots appear twice in SmartWeigh.
52. The calculation of OperTotTime does not work properly. It doesn’t calculate the time for heating or cooling.
53. When starting SmartWeigh3 Setup, I get the message: Data source name not found and no default driver specified
54. How to use the minimum and maximum fields of parameter or products records?
55. When I have done additions or corrections, how can I test the original recipe in a formula? Use of KuseOrigConc and KuseOldConc
56. The calculation of OperTotTime does not work properly. It doesn’t calculate the time for heating or cooling.
57. Data location not found in DCIGLOB.INI
58. SmartWeigh does not display the same number of decimals than ITMProcess. Why?
59. A column / field is missing in one ITMProcess window. On the other workstations, it is visible.
60. The sofware can not calculate the right cost in matching
61. When generating a dyelot, I get the following error: Constraint violation: Column Amount Reserved in table Products cannot be null