class tIntegerField not found

ccmcbride · Post by **ccmcbride** » Sat 23 Apr 2011 00:45

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

AndreyZ · Post by **AndreyZ** » Tue 26 Apr 2011 08:01

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.

ccmcbride · Post by **ccmcbride** » Fri 29 Apr 2011 20:12

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.

davort · Post by **davort** » Tue 03 May 2011 11:46

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?

AndreyZ · Post by **AndreyZ** » Fri 13 May 2011 07:16

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.