PDA

View Full Version : MultiTenant Exemplo



bobfalcoes
26-Aug-2020, 07:45 AM
Senhores, Bom Dia.
Fiz um sistema web tipo o MultiTenant (Um DB MySQL para várias empresas), tudo funciona bem, tenho 85 tabelas mas em duas ou três tabelas, quando tento abrir me retorna o erro abaixo.
Alguém mais experiente poderia me ajudar a contornar isto ?

https://support.dataaccess.com/Forums/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfAAAACgCAYAAAD zVT6lAAAgAElEQVR4Ae19CXBW53muAAmtxIlr9h2EE9u9cey6v U3aO53eJL0zd5mkndsmM3GcNNPem6TtdHrTNo7juHHaaZzEju0 aYsCYXQvaFySBACEhNgmx74hdmN1gsPGCl fOe9CLX16 c/7zb5KOeJn5 N79 3S 5/ f853//OfPeKHlMqzZMTAMGAYMA4aBOxUDjzzyCHY99feh24FfP433374 G vf61s1eHvX0j zkD1uPxk70uGckmmh59mI3DBgGDAOGgcGAgXgJnMj50G9 eZPE3714/iZ5kz0seVOcEbhdRUj4DG4wvPjsbzASMQwYBpLBQCIEziT 4fXrHnlTHy95G4EbeRt5GwYMA4YBw0ASGEiUwM tbfLI 6OPPgI10uPZfRuBJ7FoyZyxWa6d8RsGDAOGgcGBgUQInMn7w vv4eyaBlBP/ IlcbuEbiRuZ9 GAcOAYcAwkCAG4iXwnuoij6zpv PF87xdN/X8j/xhd IDhsAzMjLSDiA5hpTjORNONC eMSx2cJyZ2zraOhoGBj8G4iXwK4f2elytiZqJnfz9QuAucnPZX KAOG fKDWuTY0g5bD7FBeWRT7Z46g7EWPm3sDwQ52lzGvxvkrbGtsYD FQPxEvjun/0jTpYvcpI02clvBO64HEIkxCCQMtvC9EF52qf1MPUHUkzU5z QjqXNxQjIMDA4MRAvgYcl5zBxKb2E7nrDlzaSZZOAlnaZwzHSz zbqpT1WnvRLWdeR9bVP58lY7WNd9izrurKO9lEO58meZR0va3E M9SzLeBmrZRnv55N1OV7a5Fjs51qs63j2Wz843/BsXW1dBxMG/uCPvoh1//y90LvmMMQcNobGTvRY3vYgF35DlgWlTcoUI3Upa5 sp31BeWF9YeP02EHzkrFUP2gMGatlrbtqUYxsciwd79JlrpRlH WknWdcJsslcWdNVQ8aafOu62vGw42EYGHgY LtfloKIlHbDfdloTBo7UUwYgQcQJx1UJivu5YHWNqlLWdbRsqw nZZkvZVe 9us65OemfVJ31XbZ5HhS1rVMH3hvVLYmtiaGgcGDgT4lcCYR7h lImgSkLmWKl7qWSZctTH2O4V7m6/ocw730k03qUo7lk/Uoj5u0s6xrufSg2Fg PW9XfRkjZVnb5MHzJmFraWtpGBiYGOgzAtdv9FKXMgFF6lIO8u k4CTjt03pQLPtcOdrm0snmsnNd7oNignyUr/1cMxGfq5a2SV3KclyTB YL3tbF1sUwMHgw0C8ETm/68o1fygQuqUs5yBc2TtfQYNZ12O ya5vUpcw1uHf5pI1krXMu9dLn0oNiY/l0bVd9GSNlWdvkwfMmYWtpa2kYGJgYuI3AaaHoTVk2uXj6DVvq UuY6OpdjuPeLc VRjszTuezXMRwX5OfxXLmczzGy96sp7SxzXtAY7OPeNbb0ufw8 DvsoXjb26zocz37Zu/KD4mWuyQPzxW/rYutiGIg2BpwEbouankV1EaYd6/QcazuudlwNA4aBwY4BI3B1F3qqFtxF1i5bqsazOvZmZRgwDBgG 7iwMGIGnicDphSQvOxt531kvLHsjtfU2DBgG0o0BI/A0Eni6F8/q2xuEYcAwYBi4czFgBG4EnvBTgOyN485947C1t7U3DPQ/BozAjcCNwA0DhgHDgGEgghgwAo/gotmZb/ f doa2BoYBgwD/Y0BI3AjcDvzNgwYBgwDhoEIYiDj0qVLsGbHwDBgGDAMGAYMA9H CgBG4ncDYCZxhwDBgGDAMRBADRuARXDQ7S47WWbKtl62XYcAwk A4MGIEbgduZt2HAMGAYMAxEEANG4BFctHScyVlN2yEYBgwDhoF oYcAI3AjczrwNA4YBw4BhIIIYMAKP4KLZWXK0zpJtvWy9DAOGg XRgwAjcCNzOvA0DhgHDgGEgghgwAo/goqXjTM5q2g7BMGAYMAxECwNG4EbgduZtGDAMGAYMAxHEgBF4B BfNzpKjdZZs62XrZRgwDKQDA0bgRuB25m0YMAwYBgwDEcSAEXg EFy0dZ3JW03YIhgHDgGEgWhgwAjcCtzNvw4BhwDBgGIggBozAI 7hodpYcrbNkWy9bL8OAYSAdGDACNwK3M2/DgGHAMGAYiCAGjMAjuGjpOJPjmhkZGaFeyGHjuO5g6Pvzb05mb MrlFoV14LnKv9lli8Lfkuwc5TEIqhU2LqiGny9dtV1r6rL5zSv d9qC/O8iX7nnJ kbgSRK4BBzL8gBHSY4HlPHExnsMdG0 rtzremznnv2sc8926tnGvfT5yRSrfS6brO K5zG51zGcL 1 48gYP9kvN167rs/z5z7I7/Jpm9bl/KTsigszB1cNzuNe1yadfa58HR9PrKyt67AeZkyuwzl vZxb2Lpha/uNGcYu5yLlMLnpjAmaS5AvnXPStY3AU0Dg qCanvjnXfTCkC8OKfNxlTYps596l51t3MeKj WnOrFqab/W5Rgsh6nLsWF6vzHjtcux/HI5Rvtj6Zwne5kjZb8Ysuu4dOvxzEXG6rnqeWq/znXprhoyTvu1LmP7UpbzkHJfzsE1VtBcgnyuWumyDRgCv3z5Mr q7u9HS0oK1ra1Yv2EDNmzahE0dHdjc0YGOLVvQ0dmJzs5ObNq0 CRs2bPDiL168eNuuKF0Hy1U3aCHZR72UqY60SZ3jXGOxjXNl7/KxjXoZ6xpD nWezNcyxwbls49j/XqeF/ex4sgfK1bWCIoN8rnG4XjueRyt61yXn3NlrCvOZZO5frJfXiy7 y8827l1j vmkXcquGmSTMVLmeJct3jxdQ pS5jGDeh2vdZnr8mmb1vlvI7ufT46h5Vg57Jf1pczjy7qcwzaO d9k538/Hfq7FPcdzbWlnX6xc9usa2h5Uj3O553n0Z9 vBH7u3DmPjJubm7G5sxMnz5zBuStXcOLsWRw9eRJHjx7FiWPH0 HPiBE719OD0qVM4e/EiLr/9Nq4DePfDD3H46FF0dXV5xH7q1Kk J3O54HohXQvtZ5O5sWr6xeo8qUuZ8qUuZZdP 10xrjnpPK3LHFkzbBznx4oPExerhp9f27Uu/y6WKYYbz417zuee7Zwr9bCyqxbX0z7S2ca9HEfapOwX42f3y40 n3q GtEuZa0ublMkvdSlzbqyec7j3i3f5tU3rupb2az1WPPllDslS5 3xpk7Irn3NcPp3LsdIuZemXdpK1rseTuX4 l91VN1Ycj9Uffb8Q L59 9DU1IQNGzfixJkz6O7pwfYtW9A8fz5qf/g4qr7xKMq /Ccoevh3UPTQwzf6h38HxQ8/gvIvfxm1j30LzU/9CzoqKvDa8eN4Fzf nTp9Gm1tbdixY0efETmDiXu5iBIMbA9jc8X45ctYKVO81KWcjM 81D13bFaPH5BjuZQ0ps597P5 fPVYe WPlBsXoXK3rXO2Xup8c5m/gGFcv67Kfbdz72aVfyjqedepdcdruF NXxxXvsoUZR aRLJvf NIeJPvV0jlyDuzTNq1zHPfar3WO497llzYpcw712s469xwbpGs f5 j6rjhtC9Klz0/2GztoLrKWjpP1 lruUwI/ceIEGhsbsWXrVhw dQpbt2/H8pkzUfIXX8OS5H2fgJqBg5ClWjx6B2/ATUTJyMaq9NQvXESaihNn4CKkePQfk9I1E5fgJK7rsfdY8 io2LFuHS6697TP72uivb0dBw4cSDuR64WVC jyhbG5Yriu9kmdZN1SneeqJ fAfuq1Xescq 1a94tjO/eJ5PnlcE3u/eK0XeuU77LpujpG6646FMNN1nPZ2M 9rM8y93Isl41rcC9jZC77uZdxUma/7mWMlDnOZSOftEvZlaf9Upcy5wb1Ol7rMtfl0zatUz7ZZItVM5 ZfjiHloDyO455jSddN ljWvawjZY7TtiBd qRMtUh32XgcjmFdxkrZFeeqzXXS2fcZga9ZswatbW3oPnECHR0 dqHrqKSx55HdRNmYcakaPRc2kKaicMhUVU6d5rby3Z93rp01Dh WxTp6Jm8hRUjx6DZaPHoPT3/jNW/fznuHDunEfkZ86cwerVa9JK4nph5WK5fGFsrhhdl2J0nNZ1jp8 eTx7XkDlSZj/12q51jiW7q7HfVUv6pKzH0HpQrPRp2a Otmud6rhsXJ991Lsax8WqI O0zGNIu7SxzL0cy2WTdVgOExcmhuvJOWiZY2Q9tulYV4y0STlM rhxHy0G1YsXqsVOhxzumnj/nazvr3PvFsZ16Hevnc8VpW5AufVIOO57M8ZNj/T1yrHTLaSfwCxcuoL6uDjt378aO/ftR9eyzWPTw76Bq1GjUTpiIyik3CDuQqKdNR4XXiMBZvrWvnDb d26GX3TMSJY/8LjbOn 99Tk5M3traimPHjqWFyOUi68Vy cLYXDFcOx6fjJUy1ZK6lGP5XPPwy/ezcw2/PtG8sHPXcX7zkHY9J/a57NImZde42h 2LseF6V1jaFuQTj7t1 Nqf7y6rke6rCFlGavtfa2nai563vrv1zrF6xyty7np/DA657vqhrHJGClzXe6lT8ouP9l0jEvXNq6l83Wc1P1kXUPW7ms 5rQS f/9 75L5/sOHsXbVKrz61T/1dsp1Eybe3GnfJG65s/bkWwlaE3fltELoVtFrq50wGWWjRqPyL76GY/v3e7vxHTt2eje6pfoA0yLrxmNIAATZyCdrcKyrl3Esyzi2Ua/tsXTODYpjn6u X77LznVcvazNubrnvLB2jqM8lnXPNV09xcZrD8rhsV01yebKdd n88qXdladtieiUw02OxzL7dG3ySx/LnMe9zJMy 7nnfFeM9CXipzFkDR7Trw KDRrfVS9WvPZrXdckv2wuv7aR7qrrsnEsjyFr cVzDse64rQtlq5rsk55Olf7tF/qnM89z7k/ 7QR M6dO9HU2Ii9R46gdsECLPjsg6gdPQbVU6bi5uXxW0jbn7A1Ucf SicirpxWiZtQYLP1Pn0VHTS0 BHDw4EGsW7fO Ubcn4uQ7NgSZMnWsnz3d9gHwjFOdA6J5kksJFODchPJlzlSlvM azHK8f3O88QPl2Ml5SzmZ SVaJ9G8ZOaaTG5aCHz37t3eXea7u7ux7FfPYunkKaijG9T4c 0YxB2LoOPx102YhKJJk7Hm5dne3eoHD3V7d6onc9D6M9cFMJet P c4WMfuz OczNjJ5NJaJpvPeKA68dSSsVLmendCH/bvDhs3EI ZnLuUE51rMjWSyU10vsnkpZzA6U7z5cuXY/ehQyh 5hkUTZiMuomTUN6HpC0JnnbjtZOmoHz8BKyd Ru89f4H6Ozcgu3bt0d2J04gky0ZAFiue8ftOi79 eJOZuxksJLMuK5jGMbmmq/LFqZW1GPCHv wcQPpeLjW1GWLZ87JHodk8 OZaypiU0rg165dQ011NXYdPIjyF19E0cRJqJs0WZC3uEzeuxuX ZJuUPHW6d0Mc1ahSjWx1k6eidPwENM95BVfeu46WlrU4efJkZE k8FYtvNcKTtx0rO1aGAcPAQMNASgm8srIS2/fsQX1pKRbNuFfsvAVxT5uOsomTsGziZJROmIQK vrY9Bm33ZAWi8xvIemp01E fiLKp0xD2biJtxE4xXokPmkKiqZOx/rlDbj81jWUlZUbgSf5LPggQCdzNptMLs JanBjWzJ9KuaUzPjpyu3vv6u/x0/XcU207p12PIL 3iBf0PGNJy e2KAx 8OXMgLfsmUL2tevR9uGDZj/h/8FdePGoVx95YtItHTMONT9wR/ieEMjDi4rw7Lf/izKxk0IJPBbyFrtrqumTMOysePR eOfoGdtK1q30UjxyNqqnTnUReP24Cln7 C9i3dz OnehBY2NTUiROi6 b30LqONb94snOMdzLWLbJXvr7W6Z5JTqHZHL1mLKWlDnOZWOf7 MPGyZwoyP39d nxSeeWquOnx C6PI6fn PC9mHqxIqJ5ee5UJxu7ItSH/T3BvmC/sZ48uKJDRqzP3wpI/Cy8nJs27sXi77/fVSNHgv6XjZ/9Yt308vooS2//wW8vm f99Uu u/EunYU3/fAbSQeSNpM4lOmoXT0WGx5 md4H/DuNL/2zjtY/f2/QTE90Y1IfHrhLa16eiFq6MEv/ e7OHXxEpqaViZ1KT2ZxY V6/JLm5T7Azyxxkxmfsnk6nnJWlLmOJeNfbIPGydzoiD3998lx5cy HTutJ3o8XXW0TeuJjBWmRqyYWH6eV9g4jh ofTr jnhqxhM70I5hSgh85cqV6Ni6FXXFJVg6dRpq6ati06bfsqv mLxvfC/7JoMTibe3o S B1A boJz1 wk86nTUDpmLDqf/hne/eADEHFfuXIFV99 G5evXEHz976H4tGjUTV9OqoKC29pddOnoWTiJKxeVo6TZ85h2b Jl/bJTTAQ4MkfKYYFFObpxrrSzjfuwPo6jPJI5n3Xplz4tx5PLNWU v68laUuYYaZM1pJ1ig/SgPM7lGNe4HMM qXMe9zLGJXMc9dIfZOc4V472cR1pd VxnPZxnu7DxPnVlHZdx XTMbHmouNlTc6VNh3PMdS7fGFzY9VhP4/BdaWdfdqmY8nPsdrHOvu5FuewP4xdxkhZ12CdexnrkilO2v10r se9zCGZ7bHyOc8vnv2p7JMm8LfeegtVVVXo3LkTC77yVdSOGef tvHnXTX35xMmo/fwf4PV9t5M3EzmReGkQifNOmsh46jQsGzcOm59 Gm 99x6uvPmm9xx0 mnR8 fP48KlSzh7/jxWfvd73o1rVYUzIFtl4Qzva21F//N/4dCJHqxcucr7adJEDqxcLL3AQfXiiZV1ZF68Y8tcqil1KafDF1 Rf/n0sy3gpxzO3MLXiqSfnIWVdQ t sX52Pe9YcRyvx5V6UA3pk7LMZ1n6SdY6xXEsyy5d liWtdgme 2XupQpJ15djhMrX9eWuUE jtMxsXTO073Ok37ySb9L53gZRzap6zzt17rM5fquPpE4naN1PY 72l dv23aZ3ygnJ1vJ5fKvSkCZyecb55yxbULl6MkslTUEN3g4unpF XQjWXTZ BsRydztW9/C4kzYVMvd9DTbpD3pp/ FG9cu4aLly55pH327FmcPn0ar732mndJvOfMGZw8dQp1f/ZnKJ8wEdWFM242IvPa6XRiMQkrFi7G4ROnUFqa2C481gL6LZLO 84uTdp0TS5e5JAfFp9sXVF/PU881KDfIx3VljJTD GU8y9xzvp6v1nW81Fn263Utl042blyHde61Xep MuWG9cUby/OSvRxL2lnWfqlLmeLj1XkM7oPytY9zXONKH8s6P5bOebqnPNmk P1ZN6Zcy1ZC6lLm tkldyhzv6hOJ0zlaDxqHY3VPOWzjfKlLWcdqn/a7dB4jVX3SBF5eXo6u3bux NFvombs FvI2yNy vrWvZ/BxcOHncT90Ucf4cMPP8QHH3zg Y 2taHk/gdQMWGCR9xEvES4Xk93sI8bj01P/RSvX72CsxcueKRNvwNOXwmj76DTM8 PHDni/U74sbNnUfHYY16OJHCW68aNR9Gffw0Hjp/07kin57Yne2Bdi6prholJJEfWJZkb15J skldyunw8VxkL fFdmlzyfHMzZWv/8546vEcY9WIt6aM59rcSx/JLp3tQT5ZT8dJn5SD4rRP60F1KNbVdI6OIb9uHKNz49W5Dvdh8 nUM5bpsXJN7HRNL5zzd6zzp174gPR4fjUHxuumxdU1Xnszxk2U dKXM9vzy2c45f76rDsewjXTZdm/VY8TIuVXJSBH706FE0rViB1SubseSBB1A3ZdrtBE53no fiGV/8t9w6dQpj6SZtN9//31cv34d7733Ht555x28/fbbeA9Ad0sLlj3w26icMBE1hTNuNLopziPvp3Du0iXQb38TaR8/fhw0DyLt7u5u73GpBw4exJGeHtQ98wxemTQZNdMLb 6 mbypr59eiOJ7P4O25tVo37A5JY9ZlYvvt0hhYmRu2PgwcRTDLW gMWUvKlOPSY9XUOXJslyzjpRzP FxX5ks5jF/G 8l c3LV17Fc06/X8S6dxwnycX2OlbqfrOvJOO3TeqxYnofsdY706fqxfLpWLD3ee hwfb13X35FIDVcdnpPLFzRGPD5XbTmulGVdKfdlDR7Xr3fNhWN dPr /j 0yl23p7JMicHri2rbdu1H i1 gMuCrYPRc8uJ7RqHky3 Ciz09 AjwCPudt98GPfzlzTffxNWrV/HGG2/g0uXLuHr9OvY3N6P8gd/2fge8jm6IGzceG5/8CU6fP4/jJ096pH348GEcOnToBmkfOIA9e/Zg9969OHTsGOp /nPMHjMW1XRZnwhcNbLRyQH97njl0/ KA8dOYuHChc6dQdAC6AWLpVMtHSPra5/WE41NZlw9B6lLWc5Nj6fjtJ5obqw6seYRyy/rSzlVebpOIjrlcPObo59djxc2TudpPagOz9XVB Ul6tNz43GTqRemRtiYoHlwDVev82SM9gXp8fhojKB4vznIHJKl LnO0LOOk7JqHzmU9Vl6QPx6fa046n eUqj4pAq oqMCW3btR/M3HUDNm3G27b3n3 E0S/9KXcebYMbzzwQceYVfNl78 Eb0M6dOwf6He8LV69iT2MjKu5/AJWjRmPjk0/i5OnT3qVx lESanv37vUaPXudfjxl 44d2NvdjdKn/gX/np2Nebl5mFswArN728sFI0Bt9ohPYO5dn8S8T96NpXn5KPrKn2 LnwSNYsqT45hthPAeYFombztMLqPWgeK6pe5kjfdLukmUsyzKO bdRLO8l PmlnWebKWuyXNhmrZRnnlyvtLAfVIR/HcS/jyeanax/Xkj3n6lgeS9vD5nJdV7z0sZ/Hkz62xZqDjJOxUuZxdH3WY8VynKuX42u/ny/MeJwra7JN51OM9Em/tMtaLLNf6ixTL2uxnXO4Z3tQz7Gy53iysUx9kC7zg J0Pc4LY c5cH3uZa5LlnFS5nquHG2LlRfGTzGx4nhcjtXx7E9lnzCB0665 uroa7Rs2YPHv/T7q6YlqvTevSeKWMu2Ci0eNQsmXvoyeQ93eTWhE2PIGtJ6eHu zbLo03nP PLaVlWHdU0/h6IkTOHDokEfYtNPetWsXduzY4T3TfOvWrdjS1YWd /ej Mmf4KlhmXhx HD8R14 XszNwwu5eXg Nw /zs3Dc7l5eDY3D7/KzcMvyZ6ZhVnTpqNj8xZUVtd5u/hUHuCBXisdIEtHzXiOox5f6/HUstiPd/d2LAbnsbDXR3TXNWECp8 cG5qasHr5chTT59S9n39Lwr4p8x3lhYWoLZyB0tFjUPrFL HI3r04 /rrt9 A1ntpnH5P/ODhw6DfE9 9Z4 3y2bSpie/Udu8eTM2bd6MrXv2oOjHP8bTwzIxa3g2fpOXj5l5 XhJ9C/m5eOFvHw839uey8vHczm5mPWJu7CqvAqrW9uxdu3aW85cB9Obl uuF6rLF8ze78l22eGrGE saS9u0Hk99i43um1vU145w69dS bfZ6yO6GE YwDs6OrCxowM1c agYspU30eXek9CK7xxExnfkFZXOAPlvSR YMcOnHjttY9vQDtwAPv27fN2wrTLpkvjRNpdXV1e6 zshDf2xo1Yv3699/jWjh3bsfSJJ/CvmZl4OTsbs/PyvfZyXr5H5EzmTOi0Mycip0a78tnZuah67gV0bN8Fuqs lS OgVZLvyGkYn7pqBnPvPzGl/Z46llsdN/QbO3iXzt6ndhxi/ 4DYRjljCB09PXtu7ahWX//nPUTJx0O4GLXTfd8e3dMEY3jdFDVApnYHnhDFSOGYuyL34Je7q 6cPDoUdBn2UzadFncuzS ZQuItDdt2oSNGzdiw4YNaG /sVOm3fKGri4sefxx/HtmJuZmZ OV/HzMyc/H3N5 dv4NMp/VS bUSyKnS uzhg5D2Y9/gu17D2LBgvhvZBsIC2lziOYL0NbN1s0wYBhIFAMJEzh9/r3jwAGU/ gJVI0Zd sjUG8 fOXG97eZvIm463tbQ EMrLj306gZNRpLv/AFbFm3Djv37bu5y/YujfeSNu2029ra0Nra6l3iXr16NZpXrULbpk1Y8sMf4pnMTMzL zsar flem5efD2pE5prIeVdORE6X1 my syMISj5/t9i2/5uvPzy7JScjfbXWW06xw2qHeRLFJx3Yl4qjmMqatyJx/5O/ZsTxUuieXfqcU7H350wgdPjU73f/f7Rj1AxZuwNAg/YdRNxE4ETcTfOuBdN0wtRO3Yciu66C7MyMjDrwQfRvnw5Nnd23 rg03t5 k7RbWlrQ3NzstRUrVqCxsRErVq7Eon/4f/hlVhYWZOdgYX4B5ucXYIHX52O IHMi8lvIXOzGicRfzshAybe g60HDuPFF/9j0BM4vfD8WhDIgl6wQb6gmon45NwTyXflpHv YevLOPl3SjvPX/rZRr0rVvqDZFkzmTpBY/SXT/5teg7S5/q7Y/mpnozR9f10mRNmXI7hXtd12cmmm8xz5Ui/n5xonl89s8d/JSI5Aj90CBVPPHGDwAN23XzJvIGIm3bg4yeg6K5P4pW8PMzJy8 O83Fy8lJGBqscfx/rOThBh0y571apVN0m7oaEB9fX1qKurQ019PapLSvDrMWOxYMgQ LCkYgcX5BVjU24jMqTGZO3fkRNy9l9PneAT l jafwjPP//CoCdw UKJ50UYFBvkk MlK txtJ5o/VTV8Rs/TH0ZI2WuKW1SJn8snWsE9bpGUGzUfPpv62vd73jFOw qQzk6j u77C4bxyfTp6tuMnO603JTQOA/RuXYcb3PK7/x2FN5yZzJm3bdDZOnYtndv4V53k1med6umMh77tChqPvrv8a69 eu9S O0yybClqRNl wrKytB3z2nXw8rr6lB9bPPYsHIUVicmYWl QUeiS/p7YnQJZHz5XXeidOldfp8nEicCLz87/4eXXsP4n6zzfIAABf1SURBVKWXZsZN4ARkbgwgDW72u ycQ73Lz7k6zmWXMWFkPR7PwVWbbdzL roOx2i7zIlXDlPLb1xp13X8fNLOc3Xlso96vxyXXeZxrrZJXY4 tZVeu9ss6fnKsHPJzkzV0ntRZ1nmss5/r dnZn0ivx Aa0i7lMH4ZL2XODdu7cqVNylyTbdxrO vc6zi2U08 6Wedexkr4/38Ot70 HfV8RyzhAmcLmPv2LsXFc/84sZNbN4O/OOb1fjz7uUz7kUjPct8zFgsLCjA7Lxc73Np2hW/mpuLV4YORc1f/RXWrl PxhUrQE93o512TU2N9ytnRNp0ZziRdklJCYqKirBkyRIsWrQIx VVVqHruWSwaOQpLM7NQlF/gNSJzJnS5K6dL7HxpnYicbnabTVcA6Ca2J55Ex449mDv3lbgIX IKfAS5712LIHCnrPO3jWtqudY4L08fKlX4pB801KE7PiWJ10zG s67ps5177pS5lik9UD8rTPp6XazzpYzkoX9fQsbF0HiNWr twvLZLXcqueQb5ZXysOJ4L51C8bNIvZV2XfdIu5TB GS9lzg3bu3KlTcpck23cazvr3Os4tnMv/VImv9SlrH1cy/r0ErY vgkTON1YRr8BvnzePO9rZPSQFr3zpkvmy6dMRemn7sZc rpWXt4t5D1v2DDUfOc7WNXWhlq6LF5dfQtpl5aWori4GEuXLr1 J2kTcixcv9mxkL6uvR 3zL2DxPSNRnJmFkvwCFAsipx0578qJzG9cVi/wbnbzSDw3F4vz8lD96xfQurHTG0cfpCBdg5pj/ezklz4px/L51dY1OC5MHytX qUcNNeguDBz8ovRdXWc9ktdynruYXQeK6iO9nGOq770sRxvPsX LxnXCjifjpeyah7ZJXcp6bO3T/qBxXbkyPqzsV0fapcx1pY1k2TiGehkn7WFkV660yTFZ5royLmg enMc953Mv60hZ1wzycS3rI0Lg9F3tlXQneHMzimfcC3peOX9Fj G5YI/KuGTceC nxpbm53m6XCNO7lJ2bi1eHZaLq299B05o1qKyuvmWXzaRNRL2Q CHvJkpukTT7aiRO5l5WVeXm1zc1oeOklLB05CiWZWSjNL7hJ5J LM XNy/nyc57LoU5/CqrJK1DasQG1tbVI7cAawC xk4xYUxz7qdby0sY96mROP7MqVdaVfyjwPHkv6dL70cTz38cZy nqsPqqXnEK/O44XJ0zGU67JxTe79YvzsnOeqHyZH5mtZ5wfp8fhcc WxqY5u7NO9jtNzkPF PmmXMudKm5TJL3Upc27Y3pUrbX4y12c/92yXfZCP4qRfyvH45Hgm9x2JJ7wDP3/ PGpqa9FJ38P /c jccpUj8Dr6bPuwkKUjxzl7bpfphvVeu8CJ8Kcz T9rW jbsUKlJaXo6S4 JZL494ue9EibzdcVlHhEXVZZSWWlZZ6hE2fg9Nd8LRjr6ut9W5 sW9nWhubZs1E0chRKM7OwLL/Aa0zmdHmdL6vz5 N0SX3x8OFY/OlPo719IxYvKfa Yx4PADXgOVfapUx qUtZ 7iWtuscGRevrGsF6WF9Oi7eOfnFx6ob5Ne eHWeU6y8eOM4nnpd288mc/xiXLV0Xixd1pCyHjMen86Vc9B1pC8Z2a utEuZx5I2KZNf6lLm3LC9K1fapKzHlbqOk MH WQNLWtd19G6HNPkviHxhAmcFoh2wXsOH0bZt/8S9ePGg8h7 bTpKP7U3Xg5N /GDWIO8q547Fuoqq/HkqIib2dNhC0vjdPn3MUlJahdsQIL/ ZvMfOzD2J5aSlqGxtRQ6RdV d9Tk43udENbyuprVyJto4OtMybh KRo1A2LBNlisR5N86X1GknviRjCMr 9M waftuzJr1MugXzuIBnwYx69xTLS1rXY4nfX52HaN1mRdL1rlSJ 1nrsp6fT9opXuuyRryyriV1Ketxg3w6NkiPVYf/nrBxHB80pozRsh6H/dpOurZxrF8v46VM8VKXciyf9ks9qA7FJdNi1U6332/u8Y4rj5eUZR0py5gwcwjKDfL51TZ7criNdfySInC6uWz/kSOoff551E2chPrJU7D4rk/iNwHkXf7oN707yBfSZfHeXTZ9lk2XxumEgG5WKysvx/JVq7DkBz/A7KwsLMvIwJIHH8TK6mqsaGlBU1OTR9j0NTP6yhk1eiobPexl8 86daF 4EMX3jMSyYZko7yVx2pHz5 O0EycSp8/Ei4dlovqpp7F5x17vK2TeT5rG WZBwOYmD7gEvPRLO8Wzj3uuwbqO1zkcn0gfVJvH4bpyPn55rli 2paqX89A1/Xx6vlqnOpzLNVnXsdIufdLONWTPfmmTsl8tzpN ytO6Xy22B8VzPb xtJ9rci/z5DhS5tigWrKOjE FHFRb lxzjuUP puC5h6rrmsuPBbX1TGxdM7jXsZLWY/DOsVw4xrWp5eo/Y5vUgROzydf29aGTRs2oPi72f5pzZS970FS3 zHt Xh7mE5l 8zFU1NZicVERihRp08kA3XFeRSS9di2K/vEfMScrCzU5OagvGIGKIUNQ9LnPYW1DA9Zu3OiRNhE23UxHj1e lRk9vo ek7zh0EJuKilByz0iUZ2ahIr/g5m5cknhxdg6Kx47H2qaVqF2 AiUlpUmd5fsdZLP3D7ijdtz1m2cy83fVctmSGcNyDdeGgf7FQF IETj8pSjeUHTp5EkXfeNT7PjX9cAiRN33Pmr4q5pH38GxUfOMb qFregOLS0ps3oNFn2UTa9Fk2fW2srr4eq9vbUfLP/ yRd61H3gWoLyhAQ0EBqumBK5/7HDY0N2Pztm3es9GJsOlXyei56du2bfNGTnrp04ePIkuuhGt7H jUJGd45E478bpc3H6THwZXT7/33 OzTv3YtasOV6 AbJ/AXmnH/9UkKyrhst2px/rvvj76bj7tb4Y38YY3O9nSRE4gYNuJtt76BBaKisxp2AE5mbne Deted/zzs/HgpxcLLhnJFZWVaGspsZ7EAvlEGHTHd/0nW/67ndjUxNaN21C6Q9/iLlZWajLycHyXuJu7O2bCgpQm5GBZQ89hM7WVuzYv98jXfrFMv qNcLoznn6C9MCBAzhw8CBOXL6Mhse 5V2Cr8ovuIXEl XmebvylQsXo33zVu/y euvv2478Dg/PrA3iNS QaSCaFNRw9Y1tetqx9OOZzowkDSBHz9 3CPj7p4eLP7KVzA/I Pj3Tc9DS0vH6/m5KLsH/7BuzRO3/cm0qYb0OizbLoJjX6YpH3LFpT96Ed4JSsL9Tk53o6bdt1E3it6 28qCAjQXFKCOnpz20EPYsXEjDh475hE3kfbBgwdvtmOnT6OzuR kLpk1D9fBs1OQXgEmcbm6rHjIUVf/9f6Br137Mn78YTU0rjLyNvA0DhgHDgGEgMhhImsDprIJuQOs dgxtjY2Yd/fdWND7y2D00BS6UWxxTh5mDx Oin/6J7Rs3IiVvT9MsmbNGu/ms03bt6P8iSfwSmYmlufkeKRNu21qRN5E2tRW9farCwqwnJ6d/vDD2NPRgcM9PTeJm0icyHtLczPmTp2KimHDvM/Qa kSfH4BKom86YTiE3dhTWkZNnZux69 9Su89tprkVm0dJzJWU3bIRgGDAOGgWhhICUETrtwugmt5 JFVP7gB1iYkYEF fnes8jpO9d013dRdg5eyRqOmsd/hI1bt6Jt3Tq0r1 Prt27Ufnkkx55NwjyZuIm0ibCpramt5HcQrvzjAxUM4mfPOldO j/aS97zpk5F9dCh3kkAXYqvKyhATS J12RkoOb/fhfb93dj7tz53pUAA260gGvrZetlGDAM3OkYSAmB00Gkz7R37t 6N/YcPY9HnP4 ijCEegdPXteiGMbr7uzQ7B69mDUf9Ez/Gzu5u7Dx8GFU/ cltO2VM7kTcRNhL22t5FMrZV26ETGvSTe8 ab3s57/tSpqBs61Nu10y6eLsXTjXC0C28cOgwVj/wuOrdsw qWdd5n32fPnrXdt102MwwYBgwDhoFIYSBlBH7lyhUsWLAAp86e RUdLCxaOn4CSYVne963pASp05zd99lyenYNFubmo vZfovTRR/Eq3ayWk PtlIlsmbx5183ETWTd5mjr6LL6kCGoe ghND/ OJYWFqJh6FBvt06X3WknT5 j0y58xfDhqBw9Cm01dejauQ/PPPNLu/PcXrCResHe6TsO /tt120Y BgDKSNwOqh0Ixk9n/zCm2 itagYS 76JJZlDfd XIQInL7G5X0GnZePEvpKWEYGlufn3/zMm8mbdt6066YdNxE3NSLq9pttBNoLbjTPPmIEWujmt4wMrM7O xtoRI7xL7lSHatKJwarsbG8Hvmr2bOw8dBRzZs/zrhpcvXrV3sCNxA0DhgHDgGEgchhIKYETibe2tmL16tV4/do1EFkuGfEJVGQN955LzgROd4TTZ9L8NTF5s5omb9p1E3GvLxi BDb1tY8EIcCMb ahRHMUT8dPOnXbxtAtfk52Nhrw8rHruOew71oOiolK88sorsEv nH5/J2VmtHQvDgGHAMBAtDKScwAkA9P1uekrapXfeQevCRSi6 7dQRZ89936VSxI4f02M7zLnz7s/3nXfIGci7E29bXPBCHAjGxM7kTjtyJnEqVZbZibq7roLrbNmee RdU9uAF154ESdPnozc2Za9uKL14rL1svUyDBgG0omBtBA4TZge 1rJu3Tq8 f51dDU1oeQz94Hu/q7NzfO k81PV PdN9 wxjen3dh53yBnJu OghGg1jmit/XqROZM5HRpnUh8XX4 1mVkoK5wOtaVluLAiddQVVWL559/Pu4fLEnnAlhte4EbBgwDhgHDQCIYSBuB02RoJ04Pa7n2/vs4cugQqv/ia6gYlomGYZneZ990dzgROO2athdPlbXjYn8iaCZuLeMmIEukQ jnQidYviy uasLLQMG4bGr34V2zd34sDxU1i8uBgzZ85Ed3e37bztsy7DgGH AMGAYiDwG0krgROJ0KZ1 bezSlSu48t572LRoMSo1nUDxmC5sxMrMjP9240YwLnS d0OVzuvImoqW0dMQLbRCMy93z5Begano31GRlovO8 tM/6DQ6fOo0dew5g5sxZ3s W2mVzO8tN5CzXcgw3hgHDwEDEQNoJnP7ovXv3Yv78 d5Xtj4AcP7CBax/4QVUP/gg6rOysDojA61093hennP3TTtsImom7x0jRsBr fnYlZuLbUOGYP3w4Wi6/360Pv0zHDhwEMfPXURD40r84he/8n569Ny5c5E/2xqIALI52RubYcAwYBjoHwz0CYHT4l64cMG7pE678eMnT4L 0a68q6QETV//OmonT8aqnBy0ZGR4n113ZmZhy/BsdGXnYFtuLnbm5GBXTg72ZmVh15Ah2JaRgc68PLRMnozWr38d m cvwJGjx/Ha5avY3NmFF198ybvTnE4e7Kti/QMue1HbcTcMGAYMA nDQJ8ROC8ifQZdWlqKoqIi7D940CNy u/yhQvY29CAzf/2b2h99FGs eP/ihX334 Vn/4MVk cgFWf QxW338/2v7oj7D G99Ax09/iq0VlTjWfRjnrr6F05feQGvbesya9Rvvs276fXDbdacPOLye1t sxNgwYBgwD/YOBPidwWuhr1655d4LT74DPnTsXDY2NOHLs2E0yJ E6gHfefdeLvXD6DK68cQVvXLmKS29dw X3ruPKBx/h9MVL2NixBcUlpXjuuV97l np98HPnDljl8vtBhXDgGHAMGAYGNQY6BcCl2dr58 fR1dXl/c74a irmzJmD6poatKxdi82dnV7bum071m/YiLVt61C/vAFLliz1vstNd5UvWrQILS0t9tUwe6EO6heqfM2Y3D 7HTvudtwHGgb6ncD1ATl16hR27dqF9vZ27 Yz t1w2qnTb4jTV9KIrInwDx8 7O2033jjDXvjNvI2DBgGDAOGgTsOAwOOwDWhm25nvYYBw4BhwD BgGLgdA0bgdtZ6x5212hvB7W8EdkzsmBgGoocBI3AjcCNww4Bh wDBgGIggBozAI7hodqYcvTNlWzNbM8OAYSDVGDACNwK3M2/DgGHAMGAYiCAGjMAjuGipPouzerYzMAwYBgwD0cOAEbgRuJ15G wYMA4YBw0AEMWAEHsFFszPl6J0p25rZmhkGDAOpxoARuBG4nXk bBgwDhgHDQAQxYAQewUVL9Vmc1bOdgWHAMGAYiB4GjMCNwO3M2 zBgGDAMGAYiiAEj8Agump0pR 9M2dbM1swwYBhINQaMwI3A7czbMGAYMAwYBiKIASPwCC5aqs/irJ7tDAwDhgHDQPQwYARuBG5n3oYBw4BhwDAQQQwYgUdw0exMO XpnyrZmtmaGAcNAqjFgBG4EbmfehgHDgGHAMBBBDBiBR3DRUn0 WZ/VsZ2AYMAwYBqKHASNwI3A78zYMGAYMA4aBCGLACDyCi2ZnytE7 U7Y1szUzDBgGUo0BI3AjcDvzNgwYBgwDhoEIYsAIPIKLluqzOK tnOwPDgGHAMBA9DBiBG4HbmbdhwDBgGDAMRBADRuARXDQ7U47e mbKtma2ZYcAwkGoMGIEbgduZt2HAMGAYMAxEEANG4BFctFSfxV k92xkYBgwDhoHoYcAI3AjczrwNA4YBw4BhIIIYMAKP4KLZmXL0 zpRtzWzNDAOGgVRjwAg8SQLPyMiAbqlepGTq0dx0ftB8g3xUR/qD6mqf6fbmZRgwDBgGUosBI/AUEPhABSWTrZwf2aROMtu4l35pk7LM07JLlzVNTu2L2I6nHU/DwJ2JASPwNBI4Ex71UqYXm7RJneP4Bcm6K55jXL3Mc/mljWOljWXpkzL5pS5l7eNa1t ZbzK27rbuhoH0YMAIPM0E7iI2l00CXPpJljrHuWzsk32YuKAY7 WOdex4rls5x1qfnhWzH1Y6rYeDOw4AReAoInMiLm3wRaVIjXxi bjJGyrB1WjpUf5Hf5yMZNz4Ht3Gu/6XfeG4ytua25YSB9GDACTwGB wGUiEz7wthkjJR1rTB6UH68Ph2vdTmfIJ MMzl9L247tnZsDQODGwNG4HcogQcRrJ9P27XObxZ dvZbP7jfVGx9bX0NA32DASPwiBJ4WJJ0xbls/IKLx eKddm4tvV986K242zH2TBwZ2DACDwFBE6kJRu/eFxk5rJRvCuf7VxP9n51ZIwrX44jZY6VNpZlTbZRL 2cr22m3xlvJLbOts6Ggb7HgBF4kgRuoO170Noxt2NuGDAMGAYu wQjcCPy2nbS9MOzN0TBgGDAMDHwMGIEbgRuBGwYMA4YBw0AEMW AEHsFFszPjgX9mbGtka2QYMAykGwNG4GkmcNfNXuleVKtvbxyG AcOAYWDwY8AIPEkCj0XQsfyJvsiormx dVzjB Wxz1WPfa6arnizDf43EFtjW2PDQP9hwAg8zQSeDnC7CNTPpu1B uvRJmf6GWHo6/k6r2X9vDHbs7dgbBgY BozA00jgRHqS FjnXr9A2C5zOMZlYx/12s869xzrp2u7qybXiOWTcSYP/DcBWyNbI8NANDFgBJ5GAqcXhSRGKcfj07GuF5tfbT8712A/92yPNaYrXuaaHM03BFs3WzfDQHQwYAQeEQIPelFpMpW6lLkG2W Qju18c53DPeaxbH50Xu62VrZVhYHBhwAh8ABE4kyP3YV5smnhj 6bomx3Mv/S4b 4N8HGP94HqzsPW09TQMDCwMGIEPIAKP98XhIlGyuZqrtsyXMse 6bGF8HGP9wHqx23rYehgGBhcGjMAHKIFr8oyl 70wdR7HuezSJmXKiaVzXesH1xuEraetp2Fg4GLACDwFBE7kJps EvCQ KVOMS c6soaO5Rjd6xydx349Lts53s8vx5M5Jg/cF7itja2NYWDwYsAIPEkCtxfH4H1x2Nra2hoGDAMDGQNG4Ebg9 iMGhgHDgGHAMBBBDBiBR3DRBvIZoc3NdiyGAcOAYaBvMGAEbgR uZ96GAcOAYcAwEEEMGIFHcNHs7LZvzm7tONtxNgwYBgYyBozAj cDtzNswYBgwDBgGIogBI/AILtpAPiO0udmOxTBgGDAM9A0GjMCNwO3M2zBgGDAMGAYiiAEj 8Agump3d9s3ZrR1nO86GAcPAQMaAEbgRuJ15GwYMA4YBw0AEMW AEHsFFG8hnhDY327EYBgwDhoG wcD/BzhpZYRc/vhCAAAAAElFTkSuQmCC

Grato
Walter13923

bobfalcoes
26-Aug-2020, 08:28 AM
Desculpem, a imagem do erro não foi.
segue aqui...
13924

Salvadori
26-Aug-2020, 01:32 PM
oi Bob tudo certo, tu já verificou estas tabelas no mysql se realmente elas possuem o campo de id_empresa?, outra pergunta, quando você diz "quando tento abrir" você se refere a abrir elas no explorer? dar um Open dentro do teu código?

abre teu studio, no menu Database seleciona "Refresh table" encontre estas tabelas e clica em OK, para o dataflex atualizar o int e o fd.

bobfalcoes
26-Aug-2020, 01:46 PM
Oi Salvadori, agradeço o retorno.

Sim, existe o campo Id_Empresa.
No Explorer, vejo os dados perfeitamente.
O erro se dá quando abro uma "view.wo" e tento o prompt, já refiz a lookup_web etc....
Já fiz refresh de todas as maneiras possíveis.
Dentro do Workbench do MySQL tá tudo certinho e vejo tudos os campos também.
A maneira que encontrei para contornar isto foi:
1 - Deleto a tabela.
2 - Removo do Filelist.
3 - Refaço a tabela toda de novo (Com os mesmos campos, indices e relacionamentos) no mesmo local que estava a anterior (Mesmo número de tabela).
4 - Releio todos os dados para dentro desta nova tabela.

Estou à procura de uma solução, pois fica inviável fazer isto com todas as tabelas que retorna este erro.

Grato
Walter

Salvadori
26-Aug-2020, 01:53 PM
Oi Salvadori, agradeço o retorno.

Sim, existe o campo Id_Empresa.
No Explorer, vejo os dados perfeitamente.
O erro se dá quando abro uma "view.wo" e tento o prompt, já refiz a lookup_web etc....
Já fiz refresh de todas as maneiras possíveis.
Dentro do Workbench do MySQL tá tudo certinho e vejo tudos os campos também.
A maneira que encontrei para contornar isto foi:
1 - Deleto a tabela.
2 - Removo do Filelist.
3 - Refaço a tabela toda de novo (Com os mesmos campos, indices e relacionamentos) no mesmo local que estava a anterior (Mesmo número de tabela).
4 - Releio todos os dados para dentro desta nova tabela.

Estou à procura de uma solução, pois fica inviável fazer isto com todas as tabelas que retorna este erro.

Grato
Walter

show entendi, existe sim uma solução melhor com certeza, só precisamos chegar até ela.

me diz outra coisa, nessa lookup que está abrindo com o prompt, como tu filtra o tenant? por sqlfilter?

Samuel Pizarro
26-Aug-2020, 04:09 PM
O erro pra mim é claro Junior.

Ele esta reclamando que a coluna utilizada na expressao WHERE, 'CentCust,Id_Empresa' não existe.

O erro acontece para todos os Tenants , ou apenas pra 1 ?
Se apenas pra 1, diria que a estrutura dos seus N bancos nao está 100% igual. Isso é imperativo para utilizar esquema multi-tenant com varios bancos. A estratura de todos eles precisa bater 100%, sem excessão.

Se o erro acontece parar todos os Tenants, certifique-se que o CASE do nome da tabela e coluna combinem. alguns DBs sao Case-Sensitive para o nome das colunas e tabelas.

Por exemplo, na foto do erro ele mostra:



... Table = Centcust (20) ...

Mas na Expressao where,
... 'CentCust.Id_Empresa' ...

Outra coisa é o delimitador de nomes de campos e tabelas. Talvez seja melhor vc delimita-los pelo padrao do MySql. Eu nao sei qual é...
MSSQL eh [ ] [Table].[Coluna].
DB2 eh " " : "Tabela"."Coluna"

Eu nao me lembro qual delimitador o MySql utiliza,, {} talvez ?

[]'s

Samuel

bobfalcoes
27-Aug-2020, 08:15 AM
Oi, Salvadori.

Como estou usando o exemplo da Revista 4Developers, existe um pacote (MultiTenantDb.Pkg) onde são feitos os filtros, segue trecho destes filtros só de duas tabelas.
O interessante neste caso é que existem 15 tabelas que usam estes filtros, só duas me deram problemas.rsrsrs


Global_Variable Integer giCurrentTenant


Procedure ConstrainTenantDb Desktop Integer iTenantId
Move iTenantId to giCurrentTenant

Set_Attribute DF_FILE_SQL_FILTER of Centcust.File_Number to (SFormat("Centcust.Id_Empresa = %1" , iTenantId))
Set_Attribute DF_FILE_SQL_FILTER_EQ of Centcust.File_Number to True
Set_Attribute DF_FILE_SQL_FILTER_ACTIVE of Centcust.File_Number to True

Set_Attribute DF_FILE_SQL_FILTER of Clientes.File_Number to (SFormat("Clientes.Id_Empresa = %1", iTenantId))
Set_Attribute DF_FILE_SQL_FILTER_EQ of Clientes.File_Number to True
Set_Attribute DF_FILE_SQL_FILTER_ACTIVE of Clientes.File_Number to True

Grato
Walter

bobfalcoes
27-Aug-2020, 08:22 AM
Olá Samuel, obrigado pela sua atenção.

Como já solucionei refazendo as tabelas, vou verificar mudando se Case_Sensitive nas tabelas e nos campos e verificar se o erro retorna.

Grato
Walter

bobfalcoes
27-Aug-2020, 08:32 AM
Grande Samuel Pizarro.

Foi na "MOSCA", alterei o CASE nos filtros e o erro retornou.
CentCust é diferente de Centcust, na linha abaixo.

Set_Attribute DF_FILE_SQL_FILTER of Centcust.File_Number to (SFormat("Centcust.Id_Empresa = %1" , iTenantId))

Agradeço.

Walter

Samuel Pizarro
27-Aug-2020, 06:33 PM
Feliz em ter ajudado

Dë uma olhada depois na funcao SQLStrFileFieldName (https://docs.dataaccess.com/dataflexhelp/#t=mergedProjects%2FVDFClassRef%2FDataDictionary-Function-SQLStrFileFieldName.htm&rhsearch=sqlStrfilefieldname&rhhlterm=sqlStrfilefieldname&rhsyns=%20)

Ela ajuda nesse sentido, pois ela pega o nome correto da tabela e coluna respeitando o case do banco e tambem cobre os casos onde os nomes sao diferentes, ja que normalmente os bancos tem limite maiores que o DF.

Por exemplo, voce pode ter uma tabela com 50, chars ou coluna com 60 chars no banco, mas no DF o limite eh menor.. entao essa funcao tras o nome corretos utilizado no banco, que teoricamente pode ser diferente do nome no .FD da sua entrada do filelist do dataflex.

abcs

Samuel