Devart Forums

2 issues.
1) I have a datamodule with virtual tables on it.
one of the fields is an integer.
when I create the datamodule, I get an error of 'class tIntegerField not found'. So, my question is, how do I fix that?


2) when searching the forum for 'class tIntegerField not found', it blew up:
Could not insert search results

DEBUG MODE

SQL Error : 1062 Duplicate entry '711219356' for key 'PRIMARY'

INSERT INTO pbb_search_results (search_id, session_id, search_array) VALUES(711219356, '2fd9bc8276da91a4a6c9977f17e089fd', 'a:7:{s:14:"search_results";s:9821:"49, 99, 100, 102, 176, 201, 206, 209, 217, 219, 246, 251, 265, 338, 356, 375, 415, 417, 459, 506, 535, 551, 633, 635, 640, 646, 665, 668, 733, 767, 812, 824, 825, 832, 850, 853, 858, 871, 879, 927, 928, 934, 945, 966, 970, 979, 990, 992, 996, 1005, 1016, 1019, 1082, 1098, 1135, 1142, 1176, 1198, 1210, 1224, 1241, 1249, 1297, 1322, 1364, 1368, 1371, 1389, 1392, 1415, 1580, 1581, 1594, 1629, 1632, 1650, 1653, 1654, 1706, 1707, 1718, 1727, 1738, 1745, 1750, 1772, 1796, 1819, 1829, 1833, 1834, 1876, 1893, 1927, 1946, 1952, 1958, 1971, 1982, 2006, 2017, 2024, 2025, 2026, 2030, 2047, 2111, 2150, 2166, 2167, 2196, 2198, 2227, 2235, 2237, 2242, 2243, 2250, 2264, 2272, 2293, 2389, 2399, 2408, 2433, 2474, 2494, 2498, 2519, 2555, 2572, 2639, 2646, 2689, 2694, 2704, 2712, 2732, 2784, 2785, 2801, 2813, 2857, 2874, 2883, 2886, 2898, 2900, 2902, 2905, 2911, 2929, 2938, 2963, 2974, 3073, 3078, 3110, 3113, 3115, 3125, 3138, 3140, 3159, 3185, 3187, 3191, 3202, 3208, 3213, 3215, 3220, 3251, 3263, 3268, 3275, 3399, 3428, 3536, 3546, 3785, 3803, 3870, 3897, 3950, 4035, 4293, 4312, 4412, 4439, 4517, 4529, 4536, 4540, 4590, 4599, 4622, 4692, 4700, 4736, 4850, 4941, 5246, 5333, 5620, 5634, 5662, 5738, 5756, 5759, 5783, 5798, 5835, 5849, 5885, 5903, 5917, 5924, 5935, 5955, 5966, 6052, 6167, 6283, 6396, 6404, 6408, 6465, 6478, 6544, 6566, 6874, 6936, 7044, 7112, 7179, 7191, 7199, 7204, 7221, 7245, 7270, 7332, 7424, 7436, 7437, 7459, 7472, 7475, 7485, 7510, 7532, 7557, 7578, 7588, 7619, 7658, 7659, 7666, 7669, 7671, 7681, 7726, 7735, 7739, 7743, 7761, 7774, 7778, 7800, 7807, 7813, 7816, 7817, 7821, 7822, 7835, 7838, 7852, 7875, 7899, 7925, 7960, 7989, 8029, 8038, 8044, 8053, 8133, 8141, 8159, 8201, 8202, 8250, 8315, 8373, 8439, 8463, 8557, 8720, 8734, 8758, 8787, 8824, 8825, 8826, 8832, 8842, 8843, 8844, 8957, 8965, 8975, 8978, 9018, 9023, 9031, 9033, 9041, 9055, 9062, 9079, 9081, 9082, 9090, 9106, 9119, 9120, 9122, 9127, 9141, 9166, 9233, 9242, 9245, 9261, 9272, 9273, 9279, 9281, 9282, 9291, 9299, 9310, 9313, 9345, 9349, 9363, 9387, 9405, 9409, 9418, 9420, 9425, 9444, 9446, 9458, 9467, 9480, 9481, 9520, 9521, 9522, 9523, 9537, 9574, 9604, 9616, 9640, 9650, 9665, 9671, 9680, 9681, 9688, 9699, 9703, 9710, 9712, 9735, 9737, 9739, 9740, 9741, 9745, 9753, 9834, 9845, 9848, 9859, 9898, 9903, 9932, 9939, 9948, 9953, 9955, 9970, 9975, 9977, 9989, 9999, 10023, 10024, 10037, 10054, 10065, 10089, 10096, 10132, 10133, 10141, 10152, 10157, 10172, 10173, 10174, 10182, 10200, 10241, 10252, 10270, 10289, 10290, 10292, 10295, 10299, 10301, 10304, 10312, 10326, 10345, 10355, 10356, 10368, 10377, 10392, 10429, 10431, 10435, 10458, 10467, 10477, 10522, 10682, 10683, 10703, 10714, 10723, 10760, 10770, 10776, 10789, 10794, 10795, 10802, 10805, 10807, 10819, 10870, 10890, 10897, 10933, 10944, 10947, 10951, 10956, 10972, 10982, 10990, 11004, 11028, 11033, 11053, 11075, 11087, 11097, 11099, 11104, 11134, 11135, 11157, 11174, 11201, 11207, 11226, 11227, 11252, 11253, 11270, 11276, 11282, 11286, 11303, 11304, 11323, 11358, 11373, 11399, 11411, 11416, 11427, 11430, 11438, 11470, 11473, 11476, 11483, 11489, 11513, 11521, 11525, 11534, 11540, 11564, 11566, 11600, 11609, 11618, 11619, 11652, 11653, 11654, 11656, 11664, 11665, 11674, 11675, 11686, 11694, 11696, 11699, 11711, 11723, 11739, 11744, 11760, 11777, 11783, 11788, 11796, 11809, 11823, 11831, 11832, 11836, 11837, 11839, 11850, 11865, 11886, 11911, 11912, 11930, 11995, 12008, 12026, 12029, 12063, 12065, 12098, 12101, 12137, 12141, 12150, 12167, 12184, 12188, 12189, 12220, 12228, 12252, 12269, 12272, 12277, 12279, 12283, 12294, 12301, 12330, 12357, 12362, 12371, 12383, 12393, 12394, 12397, 12443, 12469, 12482, 12487, 12490, 12491, 12495, 12501, 12519, 12530, 12532, 12572, 12575, 12588, 12592, 12608, 12612, 12637, 12640, 12646, 12656, 12701, 12708, 12743, 12766, 12774, 12775, 12792, 12797, 12804, 12805, 12807, 12810, 12822, 12824, 12827, 12841, 12850, 12852, 12875, 12876, 12892, 12908, 12933, 12935, 12949, 12950, 12956, 12971, 12996, 12997, 13017, 13027, 13031, 13036, 13046, 13060, 13063, 13087, 13108, 13111, 13112, 13132, 13133, 13139, 13149, 13184, 13200, 13201, 13204, 13221, 13222, 13248, 13277, 13282, 13314, 13319, 13322, 13336, 13350, 13353, 13369, 13371, 13376, 13406, 13409, 13418, 13421, 13440, 13451, 13461, 13477, 13481, 13498, 13519, 13523, 13528, 13538, 13572, 13595, 13600, 13612, 13614, 13619, 13622, 13636, 13654, 13665, 13708, 13723, 13733, 13745, 13754, 13757, 13761, 13765, 13782, 13783, 13787, 13808, 13823, 13824, 13828, 13854, 13871, 13873, 13883, 13905, 13921, 13932, 13952, 13955, 13959, 13961, 13965, 13969, 13973, 13981, 13990, 14016, 14019, 14022, 14033, 14042, 14045, 14074, 14083, 14088, 14113, 14115, 14128, 14135, 14143, 14146, 14155, 14156, 14181, 14191, 14200, 14204, 14205, 14206, 14207, 14210, 14219, 14221, 14223, 14239, 14251, 14254, 14264, 14287, 14304, 14305, 14306, 14313, 14314, 14317, 14319, 14326, 14354, 14362, 14381, 14383, 14396, 14418, 14432, 14445, 14449, 14454, 14458, 14463, 14467, 14473, 14517, 14518, 14529, 14532, 14536, 14556, 14560, 14569, 14581, 14586, 14601, 14612, 14616, 14622, 14628, 14633, 14641, 14654, 14669, 14685, 14707, 14723, 14738, 14739, 14740, 14741, 14742, 14744, 14764, 14792, 14794, 14795, 14796, 14801, 14802, 14803, 14816, 14821, 14822, 14837, 14841, 14859, 14871, 14877, 14891, 14892, 14895, 14920, 14938, 14945, 14947, 14960, 14961, 14965, 14972, 14973, 14975, 14980, 14997, 15016, 15029, 15038, 15042, 15043, 15049, 15065, 15079, 15084, 15090, 15149, 15177, 15178, 15183, 15185, 15191, 15192, 15193, 15195, 15196, 15212, 15220, 15221, 15225, 15233, 15239, 15255, 15273, 15276, 15279, 15291, 15319, 15334, 15338, 15342, 15343, 15345, 15357, 15395, 15410, 15416, 15419, 15420, 15423, 15445, 15448, 15451, 15461, 15471, 15480, 15486, 15500, 15551, 15561, 15574, 15576, 15592, 15596, 15597, 15614, 15617, 15618, 15629, 15655, 15661, 15667, 15674, 15677, 15680, 15683, 15685, 15688, 15690, 15695, 15707, 15715, 15726, 15733, 15754, 15765, 15773, 15775, 15784, 15794, 15802, 15818, 15822, 15848, 15855, 15860, 15884, 15910, 15911, 15926, 15936, 15938, 15939, 15947, 15972, 15977, 15984, 15985, 16001, 16012, 16014, 16022, 16053, 16090, 16091, 16107, 16110, 16135, 16149, 16192, 16196, 16213, 16221, 16231, 16273, 16279, 16280, 16327, 16341, 16388, 16393, 16412, 16415, 16416, 16417, 16424, 16436, 16437, 16438, 16439, 16440, 16441, 16442, 16444, 16455, 16467, 16470, 16477, 16480, 16485, 16491, 16503, 16525, 16530, 16534, 16535, 16544, 16545, 16554, 16559, 16563, 16566, 16567, 16568, 16582, 16589, 16606, 16610, 16618, 16620, 16623, 16625, 16646, 16648, 16661, 16673, 16676, 16680, 16697, 16698, 16743, 16753, 16761, 16779, 16791, 16794, 16797, 16808, 16809, 16812, 16813, 16815, 16821, 16829, 16846, 16853, 16856, 16862, 16871, 16875, 16901, 16904, 16916, 16934, 16942, 16952, 16953, 16958, 16976, 16979, 16989, 17001, 17007, 17011, 17023, 17029, 17031, 17033, 17034, 17035, 17044, 17071, 17077, 17085, 17092, 17095, 17096, 17114, 17120, 17132, 17136, 17138, 17162, 17174, 17177, 17179, 17180, 17186, 17188, 17191, 17194, 17196, 17216, 17229, 17235, 17244, 17247, 17252, 17254, 17272, 17329, 17330, 17333, 17335, 17348, 17350, 17365, 17377, 17393, 17397, 17418, 17420, 17432, 17447, 17454, 17466, 17467, 17483, 17490, 17501, 17507, 17543, 17544, 17557, 17570, 17572, 17593, 17607, 17608, 17619, 17624, 17640, 17643, 17660, 17666, 17681, 17696, 17728, 17741, 17790, 17794, 17801, 17808, 17809, 17831, 17837, 17848, 17862, 17882, 17906, 17913, 17917, 17921, 17927, 17932, 17937, 17944, 17960, 17962, 17967, 17979, 18003, 18004, 18005, 18028, 18031, 18032, 18033, 18063, 18070, 18072, 18076, 18080, 18081, 18099, 18101, 18102, 18103, 18110, 18133, 18138, 18142, 18147, 18148, 18161, 18171, 18179, 18197, 18208, 18212, 18219, 18228, 18231, 18232, 18237, 18253, 18257, 18263, 18274, 18275, 18288, 18298, 18330, 18334, 18338, 18370, 18373, 18392, 18437, 18438, 18444, 18445, 18448, 18463, 18471, 18482, 18534, 18541, 18585, 18587, 18588, 18590, 18591, 18592, 18612, 18669, 18679, 18691, 18692, 18697, 18701, 18709, 18722, 18727, 18730, 18733, 18736, 18743, 18753, 18759, 18819, 18820, 18825, 18831, 18835, 18845, 18847, 18872, 18878, 18905, 18912, 18949, 18993, 19003, 19021, 19027, 19034, 19046, 19048, 19059, 19068, 19069, 19070, 19071, 19072, 19074, 19100, 19105, 19110, 19111, 19115, 19122, 19124, 19125, 19126, 19128, 19132, 19152, 19160, 19168, 19178, 19197, 19229, 19231, 19236, 19238, 19239, 19240, 19244, 19250, 19251, 19265, 19269, 19273, 19274, 19283, 19284, 19293, 19298, 19301, 19307, 19309, 19327, 19331, 19359, 19366, 19380, 19386, 19393, 19398, 19405, 19406, 19407, 19411, 19414, 19421, 19444, 19449, 19469, 19478, 19483, 19502, 19504, 19519, 19524, 19534, 19541, 19550, 19556, 19575, 19583, 19585, 19599, 19600, 19601, 19619, 19620, 19622, 19623, 19624, 19625, 19632, 19633, 19642, 19643, 19655, 19656, 19664, 19681, 19685, 19688, 19690, 19693, 19696, 19709, 19725, 19734, 19761, 19767, 19773, 19785, 19786, 19787, 19791, 19792, 19794, 19795, 19796, 19797, 19798, 19801, 19804, 19811, 19814, 19815, 19819, 19821, 19839, 19857, 19861, 19864, 19866, 19871, 19872, 19885, 19886, 19888, 19896, 19899, 19903, 19914, 19921, 19950, 19956, 19962, 19967, 19968, 19979, 19981, 19987, 19995, 19998, 20000, 20001, 20005, 20008, 20022, 20032, 20038, 20039, 20049, 20068, 20069, 20083, 20087, 20088, 20100, 20115, 20119, 20130, 20136, 20141, 20142, 20151, 20170, 20183, 20197, 20205, 20212, 20220, 20229, 20236, 20244, 20246, 20282, 20285, 20293, 20294, 20312, 20313, 20318, 20346, 20363, 20372, 20381, 20388, 20403, 20405, 20406, 20411, 20412, 20432, 20461, 20484, 20485, 20524, 20533, 20539, 20560, 20565, 20576, 20584, 20624, 20629, 20630, 20631, 20637, 20649, 20657, 20678, 20683, 20693, 20714, 20717, 20719, 20732, 20757, 20770, 20826, 20827, 20828, 20834, 20835, 20836";s:17:"total_match_count";i:1468;s:12:"split_search";a:3:{i:0;s:5:"class";i:1;s:13:"tintegerfield";i:2;s:3:"not";}s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}')

Line : 728
File : search.php

Hello,

This is a known problem with the TVirtualTable component. If you create fields (via Fields Editor) and add data at design-time, fields are removed from the *.pas file. To avoid this problem, you should create fields using the TVirtualTable.FieldDefs property in the following way:
- remove all persistent fields using Fields Editor;
- remove all fields from the TVirtualTable.FieldDefs property;
- add fields using the TVirtualTable.FieldDefs property;
- add data to the TVirtualTable component.
We will investigate this problem.

not sure that's the problem, but will readd the tables from scratch.

The code is pre-existing.
I copied from a working sdac project on another machine, and modified to use unidac components instead.

I had the same problem, and it's rather annoying ...

Besides that, my code saves data using .SaveToFile method, and restores it on program startup using .LoadFromFile of the TVirtualTable component.

This component is connected to DevExpres TcxGrid, and normally it would show the column labels, that I've set in design time. After I do the .LoadFromFile, the labels are erased and the default fieldnames are shown as column headers instead. But this has probably got to do with the DevExpress component, right?

We have changed the behaviour of the TVirtualTable component, it will not change created persistent fields. This improvement will be included in the next builds of all DAC components.