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. Error 3070 when reading Black Trap
5. 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
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. The dyelot generation does not match with the combined process. Why?
15. Cannot load BPROP20.DLL
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. Error message = Please connect or reset your instrument !
21. E099 Invalid floating point operation
22. I am getting Paradox errors, when trying to retrieve a sample from my database, in ColorTools.
23. How do I create and use a palette in Lab Paintmaker?
24. How can I print a RGB color?
25. What is ResetRegistry ?
26. SQL Error : Integrity Constraint violation : column "NoOfWeights" in table "DyeLot_Bulked Recipe_Out" can’t be NULL
27. 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 .
28. How do I edit PFs in Lab Paintmaker?
29. Unable to read white tile data ! White tile data failed !
30. Units kg/l (liquor ratio) and °C/min don’t appear in the pop up menu of the ITMRegistry. Why ?
31. I have defined a query in table DYELOT but it doesn’t work (empty result).
32. Floating-point : divided by 0!
33. When I create a new dyelot, I get the error message Index does not exist !.
34. I am using ColorTools with one instrument, how can I add a second spectrophotometer
35. Error: PDOXUSRS.NET when creating a new record
36. After weighing products: Error Message: SQL Error: General Error: SELECT returns more than one row.
37. Error AfxthrowDCIDBE Exception
38. Problem in correction options in DM PPI. When the customer try to put all the add in zero, and these numbers not changed!.
39. 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
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. No match found!
42. I have done a user query in Dyelots but the result is always empty. Why?
43. 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
44. How can I test the alphanumeric value of a parameter?
45. When I start ITMRegistry, I get the error message:ExceptionEDBEEngine Error Invalid string or buffer length
46. Unable to generate a dyelot or to customize a production form
47. Floating-point : invalid.
48. Green tile fail in DM PPI
49. Some dyelots appear twice in SmartWeigh.
50. I have loaded an ITMProcess expert level certificate but my ITMProcess is still in entry level
51. Temporary files appear on the desktop during ITMProcess utilisation.
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. Data location not found in DCIGLOB.INI
55. When I have done additions or corrections, how can I test the original recipe in a formula? Use of KuseOrigConc and KuseOldConc
56. How to use the minimum and maximum fields of parameter or products records?
57. The calculation of OperTotTime does not work properly. It doesn’t calculate the time for heating or cooling.
58. SmartWeigh does not display the same number of decimals than ITMProcess. Why?
59. The sofware can not calculate the right cost in matching
60. A column / field is missing in one ITMProcess window. On the other workstations, it is visible.
61. When generating a dyelot, I get the following error: Constraint violation: Column Amount Reserved in table Products cannot be null