PDA

Ver la Versión Completa : MxCalendar


camino
05-10-2011, 21:31:02
Saludos
Quiero retomar un hilo de enero del 2008. He logrado usar MxCalendar pero no puedo hacerlo desde una base de datos.
en esa oportunidad el sql era:

sql := 'select * from tbEventos where nEmp = ' + IntToStr(gblnEmpresa) + ' and dFecha = "' + sFecha + '"';

y yo lo modifique asi:

sql := 'select * from ingresos where Fecha = "' + sFecha + '"';

siendo Fecha el campo de la tabla Ingresos.

Al compilar me da este error:




http://www.clubdelphi.com/foros/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkAAAACmCAIAAAC9eqfXAAAgAElEQVR4nO2deVxU1f//zwyChpaWvz6lLR8ts++nVbPUtBKyTFzJckvFJZcs1FSoTBBcMBSBQkkNlUDJFaFR1EAWERAjZN9EFHfxgxgqmvrJ9++PK7dh7jJ3 FhgGXvfxfPC499xz3+f9fp8z58W5c2eGETZs2LA1si0pKcnSLmAjIqq6cv56deWN6sob16tqbly9WfPnrVvXb/914/btW3fv/nX37u27d2///fede/fuclRdOV9ZUUxEZWdSi0oPJRyO2h+/s/7cY8KidVvc/cJmAgAAAI0E/QLmFzZzw7YF8UeDUrPWZhRtyTnxS86JXwrLo0vPak5djjt1Oe7StSOXrh2puHak4tqRyzVHpaiorQOaJzJjAzR5LD78gGURjgdON fi/UnAqo01heXRheXRG0ZaUrLUh2xcIZYxpq1dk7PL4o0EHUv3TstZmFG3hNazg5K6Ck7tKz2rKLx7g4dvQLgQAANBsKT2r4dA+5HSI WwtxasJTWB6tfcgpDg8nQ5yApWSt3ZPip6NhjFevrTHem3d77kny1eZAqn/ckYDEjKC0rLUJRwOTM4OTM4O5/bSstXwht8MVpmatTc1ay9UEADQ3EjOCQLOFGwCcLnCiwBGfHhiXHhh7JOBAqv++NP+9KX4xaf57U/z2pvjtS7tfwuvOr0m+e5J896b4Rcb7RMX7RMX7/Jrk+2uS77Z93tw6rHWHVRz3BWx1uNu6Le5bNV48kbFLow4u42WMI+5IgBQHUv1jjwTw8JcAAABotmiS/DRJfr8mrvw1YXlk7PLI2OU7Y5fuOFCHbfu8ObbGeG+N8Y7QeEVovMKjPMOjPDdFevCEbF8QFO7mvmJKTs5pDkZEK0Jm+YXNXLfFf fNuTw5tDeNljGN/ih+PznJNWz9Bc4YbNgCAZsjO2KU6cCq199BGIqq59bdBzxly295DG4PC3YLC3VaEzFoRMmv2onHLQxKXhyQyInL3d1kRMmt1uNuG bQv0CpiQqIPLfk1YruO9jsACAABo8vBrKe1DblFFRDfPnjz1o+cJ31klXlOKF4wrdBuZ/6VzwbwRBXOGFswZmuc6KM91UM6M/jkz+udM6XdsQu/fR3c7NPndyuP5RBQQOm9FyCzvoBnfrpiiX8C27fOWETCunNOtyNilkQKxBc0ZfhCDZgh3Fwg0c7QHA3c/kIhOr1t8Yee6i7s3nNsSUL7O+2TQgpMBbmWr5p1YMbv0O9fS5Z8fXzKtxPvTYo8JhV+Nzp8zLHv6u0mje2wf81bNrb85AVsS/MW8ZRNcvhpeR8D8wmYGhbutFwgYJ1Hc3/u3BxOWaxdqLxgxfwEALD51AssSofHSOeQFrMxv7kVN6KW9YecifjgdsuxUsMfJ778p859/wm/uiRWzT/jOKl028/jiacUeE4sWfJI/78OczwYkj+21weEZbgXmHzpPTsA2RXroLL84ubpP4kpuJzJ2ufY9Q9w2BDpYfA4FFsTiEyhoVERovLZovLZovIjo+JJp5yJ+uLDj x7OhK06tWXgy0L1s5ZelPp+XLJ523HNysYdL4ddjC78aUzBvRP6cYXlfOGVPfy95/Jub3nuOiILC3fxD5/mFzhMXsJDtCzZFekRovLbt895Ze/OwjoYlrtR+kiQyVnIFBgAAoHlSR8D2eW/d580LWInnxNMhS89sXH5qzULu6YwSr2klCycVfT2uYP7H+bOH533hlPfZB9ypnKkOx6Y6pLj0Df3gBSJat30BJ2DfrpgiLmDhUZ5 bY7x3HFi6M3Yp//jH7Ts3T507dl+9auE1jHsmcmfs0kuVZX/dvmnx3HHoPMHSkE1f+fP8lT/Pm+h8atZOYThG+3Dxv2VExJWY7p65jAAAmjCcdOkIWPGCcaeCFpwKXngy0J2fn2vVa1jeF065M97jy3M+ffvY5LdTJugKmPgKbGO UZ3iU57Z93jsOLI06uIwz4ehgP3RIhwsXTt6oqZYSMG4pxtX/4INHLJ64HbUzvqODPU/9tVVYlnK95gp/eOXP8yfKckeO6Wyi8xsjvhWGY4QPJ878QUQeiz52dLAfOaazce6ZPUYAQNNGVMAK3T4u859/MtC9bOXc0mWf81qV/+WHBbOG5M0c8I96TeqdPalP1uS3Dk94M3TAfzgBC9q2QHIFxgkY17a2gO1J8k06Gk5EMTGhMan+Man+nIZxH0/j0TvJNiQN6QzX1nDnDnzJyDGdTRew6uqqsJ2eCsOR8YG/dk3o50a7Z/YYAQBNG169IuoKWOl3rqW+s0u/cz2+eMZxj8m8YuV94cTvZ7u8kT3+9WyXnscmvZkyvnfYB/9HROsjPfQIGHf/kHtni5/49qf6x6T6E9H582Wz3d+OSfUvv5jNnT11PltHwM6fLyOiklOpkfE+HFy5cP9SZRkR3b5zs6r6Qm5pvExh2blM7sKyc5k6ZsvOZV6 vqeILdc46OtjzJWcvFRBR8rGIyHif5GMRRHT2UkFkvE9uafz1mioiul5TxZ2Vb5GrfKmyTLuQj0t7X8bO2UsFt+/c5OzsT10j6rxGs6GkJGvTLjedcIQ2ZXyQd080dq5E27f6iBEA0IT5R8lil/IyRkT5swYfXzytdNnM0qUzS7ymlXhOKvp2PNXdcqf0zp38Rs6E7jkTX8+e1DPlk9fD3u9KROsjPbhFmHfQDBEBi9jnvePA0sjaL5 7iJ03u60C4ww9HPHHuUi4Rbd25cv68QUSUciRaZwW2JtidiPbu/4n7Diu+XHu/orKMiDy9Pp4+rQ8R5eQeXrhksGjhyXOZRPTLdl+uucNpUdpmvbzGBa2dPdy5Y1TtV2Zpn+U2vrDi8tnq6qq14bNu37l5tbrC0cF+ 1+4fiCgpZcdw546JCbt+Dlv2w4ap8i3yASYkbNcp14mx5FQqEW34eSFn57eD4dr1F3gMcXV1IKK8/NSfd7kJnXd0sD99pign97Bym0IfZE7llcYLY+esDXfuOHbMC0R08mQe55vpMXJKDABohnALMiLKm/lBiYfLce+px72nlXhNLV44sXjBuMKvRvLTdf6Mt/Km9sqb3CPXpVuuS7fsiT1Sx3YP69+FiDZEenCLMPEVGCdgnHrtqStgsUcC+MM7d25xO98FjiGi6uqqOe5v769VOEcH++gkXyI6f7 7MY+nQaC072vv8zvpfZnP7LpNfFC3k/ot3dLBfumok15zr/L7aplYGuwRtmh6d5KuN9oTLNR2d5Jv4RyifJldXh+Efdrx+s4qr5ubxXnSS7/TPe3gsHaq3RW5ftFz7kLezMtiFq8+1wlcI2/01H6ao83sPB16/fjUhcbtymzoWZE6Jxh6d5Hvy/DGuFW4bNfaZ+ogRANAc0JYxIsqZ6lj4zdjjiyaXeH1aumhKiefE4m/HUd2tYHrv/Cmv5bm8kufySvaEV1JHvxzm2ImINmq81kd6rN4huwLjBGxvyj8rqrj0wMPHNhJRcXEmrz3a28CBj+zXUjj+WucPn9C2o71/4+ZVIpo+rU9yVhhvWbRQtDkds0KkzhaeSCUijWaDo4P9hu1filZT0qKMJ/yhkvoyDnCFB9N/4t1QaFO+CVFTPJerThHRxjDPgQMfMdSIQTGCJsweAFL89qT46YgZEWVN6lswb0Txt+NLPCeWeEwq9nDh57cityH8fsHUHgWTXs53 eTFn/AupH/9fuMNTRBQe471R4xUS5SkpYJG16rVXa95JyAgqOhVPROvXLRw7vsudu/dXYNpoC9i+NH+9+4mZIbyv5y4Wjx3zwuhxz4oW8v/ja6NjVojoWW37i5eP2pfmzxvXrqakRSKqrq4S9YQ/1DYuVV/UT53ClAyRFZhCHxS6J2w6YP1kQ42I+hNTdx8A0HzQkTEiyprQM3/2kEL3kcULxxcvnMBPyEVff1g0f3DRl+/zJYWTXsp3+U/O2K6pzs+Ev9WBiLYdXBYe4y0pYDvifSLjfTj10p6D0nJ+vnP31sVLZY4O9t/5jTx17ggRrV+3sPR00p27t8ovZCRkBMWlB/L1C8piiSgxYZejg31sekDNratENHbMCxmFO/k6f16/SETTp/Xh5GHypy9vj/EQLSw5ncw1V1AWe/vOzZPnjsamB8Sm/6OX3KEOomdrbl3963bN9Gl9qqurzp8v0zYemx5wsbKYM663RS5AjWbDwIGPxKYH8JO4TrWT544SkZfXOK5+RMQqrr62b6J+CguLS tLkbUr5ILTGH4rGfuZSDtdZnH1uvz5iBAA0eXgZ25vmvzfNn4gyR3fL/WxA/pfOhe6j/9Eq94+K3Z05ASue9Q5fXjCuS86oTilDnwrr8ygR7Yj34TRsRcgsMQGLXRoV78OpF7+iIqKaW1cLjh90cmr/yfjnuJ/FTEjaXF1dRURX/6yYNKm755LByZnBnGjdl9OSI44O9jNn9YxLD8wp2XPt2lUiOnM+j5/LLlaWkNZWc+tqTske0cK49MC4xDCuuaqrlyZO7L7Aa6C2XsalBwqhultceuDZSzlEtNJv+sCB7ZOOhBHRgd82c8a5Jydrbl318HL mjMu0yFXOyj3o6GA/96t3uAD5VnQcS8+I4Q6PZPzq6GAv9Fw0CtHC8tOFMjZlfNCxVudQLPbUI78SUWHpoazcg0Q0f96gHTGeZo8RNGWOguYLJ138Dsf+ 9ID96QFElDHiP9mT38n7win/S2duZih0+7DQzblw/pDCLwcWznm36Iu+RZ+9wZ3K/6Rz9kdPHR74+M+9HiGiyCTfbQeXbYv38Q+dJyJgO+N9opN8OQGLSw9MyAjib6CN+OjJ7/xGcj+1zP0Q83d+I52c2nOnomOXcL/C6ehg7zq7N3eJ6+ze/C+0/rhpOleZP3s0L3zDxgXcPvfA27VrVzfvWCAs/HHT9OTMYJ+VH91vbsT95pIzg7maUj8Lq3MPMDkz2O0bR0cHe87gj5umOzrYu33jyBkfMeJJHePCFvmJmKvMXcsHqO2M9j7XqKODP SfzwgqiUYgWfjL+ORmbMj7oWNM+FI2ds++5ZDC3E7p1Tn3ECJoqFp9DQWODkzEi+t25a9aEntnTHPI+H1gwe0jBnCH5swcVzHYqm PVBgeu7hZ+/XTijZ+G07oWTXioY1yVv9L+zh3dIHvBoaM+HOQHbEe+zLd4nQEbAuOUXJ2AJGUGJGatTstam1pJWF67QiCFeVX3m9u2bO6KXJWcG l5QnEFFxcWZmZqKw0MmpvcVfkBy8gFncEwAAaMyIyhgRpQ7qdPTjl/+Y0Dvz035Z0/pnf/Ze1jTHrOmO2dPfyZ7WJ/fTnjmTuuVOeDFnbNeckZ2ynJ/IGPyvhHfb//RaWyKKTvGLTPLdFu8jfguRFzBOwzgB4+4ZpkgImNEalpoVkpS089q1KiK6eevP7Lx4Rwf7qdN7CAv5ZYfFgYABAIBChAJWc+vv+D G94gY+Gzf0hcSR3RNHvZ44+o3EkT2SRvdIGtXt0MhXUka9dPij51OcuyQP63R48BPJHzyW0P//Rb/1yCanF5UKGP8eGHc7m1+EacuYDsaF99thP7dvHPnbdNwdOdHCxgNuhQEAgF6kVmCXi3O3fvj6uj5PbHzn3xv7dQrp1zmkX6dNDp0 3OXQO7fd02DtPhL/dYcvbj4f1eTSsd/vNvR7e9Ea7TU4vXizKMUDAuL/7U/33p/rvPxIQeySAkzEOXsy4JZoOnPeip0DzweL33AEAFkfnocSC8hQyfKu59TcRFZSn8O+BSQrY1n3e3LfRa38lx94UP+7bpLiv5OBJyA iKTw/UIe7o/SeRLP4EJ7AgFn/lAAti8eEHLAs3BvanB3DP0Mek+e+vPdyb5r+n9i+3wxOd5Ls7yTc6yZc7G53ixy25dJATsC0ar6Bwt3URX6/ftoBjU6QHR3iUJ0eExmur/I+u7gMANF82a7xAs2WLxitCYgxsjPLUZbdEyW7PDZEePOtr/27UeOkRsHURX/+4bQYAAADQqBAXMF69KiuKAQAAgMZJbPoPEDAAAADWBwQMAACAVQIBAwAAYJVAwAAAAFglvIDl5JzOyTkNAQMAAGAd8AJ2+ty10+ euQcAAAABYBxAwAAAAVgkEzPIQkcV9AAAAqwMCZnkgYAAAYAQQMAAAAFaJtoCVQ8AAAABYC7yAaTQajUYDAQMAAGAd1JeAVR2Mur boqxtTJvw16qN7HzrfGzb0zvChNZ+MuuY+6+r2DZVncy0eOQAAAKuGF7CaGqqpITMIWPVKr7tvvXVvwACaOpXc3Mjbm5Yto0WLaP 58+vRT+uije/363X7xhUvTXE5lJVk8fgAAAFaKOQXs6u6w233fpPffpylTaMECWrWKQkJoyxbavJlCQigggBYtIldXmjCBBg+m3r2v/vvfOQvmWDwF5oUxZnEfmhvWmHNr9LkJ0PjT3vg9bFSYTcCqvb76+8UXadgw+uwz8vKioCD6+WeKiKCtWyk8nNavp4AAWrKE3N3ps 89o7FgaPJj69KHnn89/q3dJYZrRATCtTfklJlaTac4gN4xw3ow0zpeKEV41TCDarZjeookWhINHdJ9vRX6YGTdozeh8vXaZeTuuvpHqwXpqSGE3CQv12mmY XjaPgFW7TqNXX6WhQ2n6dPLwID8/WrOGfvyRfviBVq6kRYvom29o/nyaO5dcXWnqVBo3jpydqX9/6tmTunbN6vpseso+07vBvGmSsWaWuaA+fLaWpq0xkAYbXUZfri1X8oVGO2OWl1sDDzwrFTDL+iw/wCoVjKuGcdsMAlbls/Deiy/SgAE0YQLNnk0LF5K3Ny1eTO7uNGMGjRxJTk40YAANHEjDhtHHH9Po0eTsTE5O5OBAvXvffPnlm506xT/b+Y+jsSYmWrvvpf73lP+3VLtE6n8HqWlC6lr5f0Ck/JfyXInDUhWEKVKeDaHbQrPC/MgkUCZM+fClcm6ie1KHohWUXyXllZK4ZNIoZV8+XiWh6R0zSjpaiUGpIaE3w0ILojFq/9VOu1QHCatJhaN88MiMVSk3RFMklXzRcGQaEu0FUU9E8yPTa3pDML2XRdEWsBtGCNiV33b+1akT9e1LQ4fS+PE0ffr/pk69NXEijRxJ/ftT9+7UuTN16ECPP05PPknPPUfdu1OvXjfffvvem2/SG29Qjx53Xnrp8nPPXerYcX3fXkX5qUoalUqTTCfpJEvqQvkOELUjb0q0joz/otWMcFh+xMskR8noUZJVKeMKwzQiNKPdU546I0oUHioJXJhDnUwKpwOZVChxW3TMCC0rD0HboNCs6L6MMzKhSY0lJR0kNWYM7SPj xomMb4bakRrzMi80ncul+kImG8LLzdXLopi6ArvS6/W/X3mFHBxo8GAaPvzukCGLZ870/uKLu889R488Qg8+eKdly+stWlyzta2xs/ufvT21aXOjY8cZkyYFjhtHzz5LXbveff75imeeKX/qqdx27RbPmnb+TI6SduXTJNqpwv7TuVbhuJQaEEoGjYw1UQek3BPtZiXjW6a+sDklQ1O5QYPCFFrWmw1D3ZO/xLhkyjchNYpk0i7VC/KFom7InDUu1QaFIGVQvmvkXRU9JfVXyRgQ3RH1X76PlIwlnTry/St0yaDukDEi2rpMepWUi4Zgei+LYpKAXV676krnztStG731Fr3zzl99+/40d258cXFsScl6V9dqxm4yVsHYBcYuMnaJsRrGTjLmNmrUuri4kEOHtk2cSI89dqdDh4tPPlnSoUPpo49+367t7l2hCl03Ok1KXk VSSWSCTb4DRIea6Z0q+vpRconCF7PQuN7MKDRoaJhKOktJxxl6iXHJVN6Ewj6V6gX5WU9m2BvqtqH9ZWjfKWlCqjnRU1J/lY8BvROFfB8ZOk6kjMv4ZlBXysel1xOZmnrzY95eFqXOLcQbBgrYuW4vV3bpQi+/TN2706uvhnp4aIqLiYiIkk6f/nHmzPJaATvHWCVj+YzNHTt2Y0ICEf1N9EthYeK8eTfbtTv3r38VPvpoVvv2qQ8++PnI4aUlRxV6b1yaFI4q+TnCuEEj34pxM4XCi JS/mBW+sOWzqnAqV9gLRmRDuXtGp85or4yuL3WovIMMctuUswqzpGRIyF+rvNMVJlzh5cbFq9emcj8NbUs0LiVSoXBcyYRgrl4WYvwK 7L+/x5147LGKZ5653bUrPf88delS6OKSdOpUDd3fkk+dCpk3r4yxS4xVMJbD2LcTJ21JTq49T3eITo0adcnOrrxdu/yHHz7Stu2xhx6a+kTHHds2KPReb5q4Q24TTb3wlHaJzlmZwcS0NplBI2NBxnOZoSn0Vm9EwiZkYpcZZ1JmZSwoD1NvIFLxGu2e8m TKG5EfmTIWRAPXG6DohULnRZsWuqEkKKm0SIUgn1sZl5QMYKnBKRWdfEPylys8lM+/zFVS/askUvkRJRqXvCdSDigJtv56WUgdAbtxzwABO7/468IOHS48+eS1p5/+X+fO9PTTZGdXPnRoxoULN2ol6vfLlzcvXFjCWD5jK+bP35mRQVpb1fDh5xg73br18QcfPNamTXKbNkfatv3ezm7unBkXz+UrDMA IlGfHumiqcSGZoMlg4rhqJMOykbhRacoK7OSYEfmPPlr+2GMVjz9+rWPHmo4drz/00H8Zyx04MLuykl+HFVZVxfn4RH73XWpZ2T0t9TozbFguY6W2tiVt2uS1bv27vX2Cvf3B1q0j7OwGffDusT/im3zqEVpjBskEZkR+vWWQHYvHoh2Rxd3gBeyGoSuw3J49stq3L3rkkdPt21e0b1/Zvv3FNm3KGTvBWGa/frmXL9+s1aoaoutUZzvRv//vjOUylm9nl2dvf6xVq7RWreJattzbqtUeO7sez3eJ3h1m8dQAAABozPwjYDcM/BxY+lNPHm3XLvuhh44/9NDptm3PtG1b3rr1cRubQsbyGct4992Cioq7dXXrHtFtopNOTmmM/cFYpkqVZWeX1bLlUTu7w7a2+21tI+3sDrRs+WLHDpvDgi2eGgAAAI2Zuu+BGSJgiW3bJrdpc7R16+zWrYtbtz7x4IMlrVoV2Njkc ksrxlIHDrhw+7a2gN0kOtanTxpjGYwdZex3G5vfbW1/t7VNsbVNaNFC06LFdlvb32xtuz7ycMhPARZPTcPQGJbhAABgjWjfQjRsBZb41BOxDzyQ3KrV761aZbdqlf/AA/ktW+ba2GQzls9YMmO7V668fOsWEd27d+/evXtEdJsoffXqw4ylM5bGWJpKldaiRaqtbYKNzT61epdavdnGZred3TPt2q5fu0p5DKKPwYiWWDzdos6b3aDeVFQ2mlvYAABgNMZ/ldTh17vFtGoVZ2eXYmd31M4u084u284uS63OZyyeseWzZ8cfP06C7XhNzZbFiw8ylspYCmOHbGwSbGwOqNXRavUvanWYjU2ojc1T D7f7aZ2/wgBEZ2FR3Wqc87V5vRIGbkWpAAAAgzD+KcQ/xo6IbNkyxs4urkWLZFvbdFvbDBubXMZiGft68uSdaWlC9eK2zIqKYDe3/YwlMxavUh1QqzVq9Q6VKlSt3mRjs0Kt7vjYoxtDvlcYgHAuliqRmbVFP4Ug/CtfU96g1KpIpo6JSAkY1AsA0DQwXsCKfTy22trubtFin41NnI3NIZUqk7HfGJs9alREUpK2YmX17Vvk7HyHiH+2Pr28PHDWLA1jB xj7lbGdKtVmleonlWqTWj1Hre7U6emIzWuVxyAqKjoVRMuF9fmaOrqipKaoQamr9JYIoxNqnnxO5H02r1gCAEDDY7yAXfgjfnOLF ltbtIhUq/eoVAcZi2Zs/qRJ21NS6qiXg8OvjO1hLH3YsFM3b/LP1mdcvLh6/vztjO1kbAtjISpVkFodola/qVL17v36b/u3GxGMzHpItJw/qzOnS8mJwtWMcQJmtK4Ir1LuMzQMAGC91PkcmKFf5hv9fJdwG5sItXoXYxrG/L/5JiIj439a6nVs+PDdjMUwto8xDWPxgweXXLv2V+3Z/L/+2r1kSThjGxlbo1L9oFavUqsfVqvHjvmwMC/FiGCMFjCZkgYTMJmgDFqBGdE6AABYI3WeQjT0y3zjgldqbGw2qdVbGNvB2PZXX036449/vkfK0XEXY3tq0TAWyVhM//4lV67wChf12mvBjAUx5qdSrVarR6pUjz/+L59l3xoXjMx9s0plAmbBFZjU5cZlwIjoAADAujBpBVZZURz53DObbGx+YuxnxsIY2/mf/9zh3uUaNCiCsSjGohjbrVJFq1RRjO1iLIKxfQMHcuq1u0uXQMa+Z2wFY34qlbdK1Yaxfu/0ObDPgPuHUusS0RtrUisYnXKZKV6mpnw1vc4oWV0ZlA0lrVtq2AEAgOmY+ovMGVHhv6jVa9TqNYz9xNg6xhKdnFI++mgjY1sZ287 YDpVqh0q1XaXaplJFMBbO2E+MpU6cuKdPn5WM+TG2nLGlKpWfStWLsccf/5fHt/POnc42V3iYowEAoKlS9xaiId+FyLN1zowtavUPKtX3jAUztpqxHxnbyFh4LZsZC2csjLFQxkIYW8uYP2N+jK1kbBljXoz5qVQfM9 aqVauhQwYkxUeZN0IsNQAAoEnyzwrsxj1jbiFyrB42cJNaHaBSrWIskLEgxoIZW8fYesbWMRZSuzhby9gaxgIZ82PsO8aWMObFmK 9KNY4xGxubXj1fC90YZPGMAAAAsAq0VmD3DH6Ig+e/l4pWjRiyWqUKUKlWMLaCsVWMcWL2fS2Btauu5YwtYWwRY4sZW6JSDWfMxsamW7eX1gT5nj+TY/GMAAAAsAq0V2DGvAfGU3GhYOXnU75RqX5QqVYy5qPFcsaWM7aMscWMeTPmxdhixnwYm6dSdWPsgQda9e7VI+j75WfLzfbWl5AGvo uIm5YAAFDfaP2cyj3Dfg9MlE0bfpj2Rnd3lWq5SrVCpfJhbEmtbnEsZWwJY7NVqn4qlX0Lm6ee7Dh6lHPE5rUXzuaaEobME4Z8hY ZMKwQMAADqm7q3EE0WsMqK4szf45Yu+ca5b8z1DdkAAAj0SURBVK+h9g9MUKlcVSo3xtwZc2XMRaV6X6XqxFjr1vb/fvrJwYPeX/Gd59G0AybGoEQtIGAAANDEMPUxelEqLhSkpcSsDV75xedTBjm99+abb3Tv9nK3bi+91v2VN998Y5DTe65ffBq82vfwoT2XzheYGI DyT2JVSnyql68m+tkpoX0ZI0zw+TCpClIeKrwWAABAnRVYjTlWYA2M6LQuqjEy5cIdYU29xmWaU36JQZ4AAEBzxjyP0VuQRitgUh aUaJ68zwAAACrr3EI07SlES9FoBUzUuMJLIGAAAKCXurcQrVDAKg35BtsGFjAlFUR90FsIAABA6zF6ssr3wDiETzoID0VrGvfOk5 QRqcullEnvnUa9ngAAQLNF+3Ng1roCAwAA0AzReojDmldgAAAAmhvaD3GY4Zs4AAAAgIahzntgEDAAAADWQp33wJq2gBn6BASemA AAgMZMXQGzzoc4hI/zVQqe/avU9/ifGevLlAAAADAXVr8C0/vouc5ZhR/JMrS+EgUFAABgRuq+B2adKzAeocDonKo0RJCU2Nf7cTGL5wQAAJoq5v85FUsh9VFl4VmdQoUCpveTxRAwAABoSJrICkz591nIfym GlIApES0IGAAANCRN4TF6JWKjd/2kvBoEDAAAGgPaAnbdGgVMXjYMEjBD7yXKWxMtAQAAYC6awlOIojcA5e8HCt8hk5ElvfYVlgAAADAjTeFzYHoxVEWgOgAA0PiBgJ mhPgAAgIaHF7DrTVjAAAAAND2s/j0wAAAAzRNtAbPKpxCVY/Ebgw3sgMXjtTjIAABNm7oCZrW3EGUeI9QpNHpSM302NO98qve5R5nmhM9VWqrXLGVf5hMUhubfxHFlXHONKtt6X3oA1BNN5Baicg Ezi32jjZgxXp19+RK9l1sE6xUwYf2GjMW4thpGwABoSJrUN3HIfE6rsu60Lvr/rPx/uEpepcI1kHBJJKo02v/ICy+Xb1rKrJKMCdMilQr50JRUEJbrTZfeEnlPZPKgc0qvD3oHg6GxyF8r46GOt1JjyVAPTYlF+1DKDSn/pXwAQAm8gN0fSU1GwKSqCWcHqRKpVvS6ITxU2LTMFCYz0Ug1p9BV7RlH3nO9oel1QMmkbFAfGdGPMp4odE87+Xrzr9cr+b6Qd8bE hvRWq9d+MWjEAiAKL2AajUaj0TRrAdPeZFrR64bwsJ4EzIjKfAWj51/RXOkkTSaHSqZRgyZBoSfKkyZqTSZM5flX7pXebEt1mcIUKcy2ce6ZWKIkvQDIwAvY6dNnTp8+Y30CxgRbpbECprchgypINSHTtM6 OQXOxwspSFZRPizL2RQVAppqhc7GSXjMoaVJXKRwSyvNvFgEztKcav4ApSS8AMjQFARMemihg8jOIVJ2GFDCjZy4lJQYJmPLpT76 b6m+iNLSzlKTU9FiUZ1sm501GwGR6CgAZmqaAVWr9H61zSv7FI7xK6pSSasJDnXKjBUzKJVH/jSjRa9ygQ71m5Y3IlMi7KkysqDMybusNxOhY5IeNaB3RQx3LTMGYkQ9NSedKucGXyNTRm3ChPwBIYfUCZinwSmv4DFtvzq3XcwAa MxAwY8B8ZJEkW2/arddzABozEDAAAABWCQQMAACAVQIBAwAAYJVAwAAAAFglEDAAAABWCQQMAACAVQIBAwAAYJVAwAAAAFglEDAAAABWCQQMAACAVQI BAwAAYJVAwAAAAFglEDAAAABWCQQMAACAVQIBAwAAYJVAwAAAAFglEDBgHTBr3nRiIavd5s6ZavGRAAAPBAxYB4wxS8/exmxz50wVFbDqq2esjl3b1kPAQKMCAgasA07ALD6JGzHjSwmYxVNqKBAw0NiAgAHrgBcwi3uiHAgYAPUKBAxYBzoCxqlCY/5bCQEDoJ6BgAHrQFvAhJLQ2OA8hIABUK9AwIB1gFuIRmSsPsKxeFYB4IGAAevAvCsw4QPuUvtG26+sNwHTMSjlLQQMNHkgYMA6MO MKTFSrhDumAwEDoF6BgAHrwFwrMOG1os9fmO5tZYMLmM6yko9I6vPUhgIBA40NCBiwDsy1ApMRsHpastSHgAm/6UO4rJQqNzEc86YIAFOAgAHroAFWYGYUsIZfgUlJGgQMNGEgYMA6aIAVmOhZU2hgAZOJSyp2I8IxY34AMBEIGLAOzPgUYgM8xGGR FZhoCQQMNGEgYMA6MONTiJX1/xg9Bx7iAKBegYAB68CMK7CG8bbS0h9k1vbELEDAQGNDqYDt2rZeL0Rk8XhAU8W8K7CGocGeQpRRKQgYaMIYIGBz50yVofrqGQgYq D+wArM4EDDQ2DBMwGR+uK+ZCFjjnzqbKgzfRm9pIGCgsVG/Aib1ZJTR6NwzEd5CkXp/W8ofQ32DgFkK3EK0OBAw0NhoaAEzBaEFvSJkkIAZ5wNoGDgBU/JebKMCAgZA/WGxFZjUyknhWkqvfb1GpK4VfWNcdKlnkP/ARBhj8u/CNlpEBcziymq0Hlt8JADAU+/vgQl1q1KfsOnsiB4KC5UIWKVAqwzyzRT/gYkwa950YrG4ppqCxUcCADwWEzCdl7fUXx07QuM6c4Teq2QaErZraImM/wAAAMyL5VdgwnKDBEy+BAIGAABNlYZ4jF6JAEgVStlRWKLXjilyZaj/AAAAzIhlBKxS8BCEVDWhKeGNR/k6Cv2p1CdOwnuVRvgPAADAXBggYNVXz8gjJWAAAACA2VEqYDJrL+1NxzoTbBYPGAAAQNMA30YPAADAKoGAAQAAsEogYAAAAKwSCB gAAACrBAIGAADAKoGAAQAAsEogYAAAAKwSEQFz93fhNOzw0dWHj67OKFyvlKJ1AAAAQMMgKWArQmYBAAAAjZw6Auby1XAAAADAWv hHwAzdGPPmMeLyBjCIDRs2q96SkpIs7QI2IqKqK+eJKDBsfvge/19i1vwSsyZif0DE/oAte1eGRi8PjV4eEukRvNU9eKu7/8b5ROS3+uvKimIiKjuTWlR6KOFw1P74nZzYmJ1nntlgjIBhw4YNW71uELBGsllEwJYs/loeCBg2bNga7wYBaySbpQTs9l/XZeAF7P8DIoJvGs+vFmIAAAAASUVORK5CYII=



De antemano apreciaria cualquier ayuda que Uds. medieran.


Muchas Gracias

camino
05-10-2011, 21:39:18
Corrijo no sale El mensaje de error:

'Dynamic sql error
SQL error code =-206
Column Unknown
29/09/2011
At line 1 Column 30'

Casimiro Notevi
05-10-2011, 21:45:46
Por favor, no olvides leer nuestra guía de estilo (http://www.clubdelphi.com/foros/guiaestilo.php), gracias por tu colaboración.
Pon títulos descriptivos.
Encierra entre etiquetas el código fuente, etc.

http://neftali.clubdelphi.com/images/UtilizarTAGs.png


.

ecfisa
05-10-2011, 22:22:32
Hola camino.

En principio, aunque hago memoria, no logro recordar el hilo que comentas. :rolleyes:

Tampoco mencionas el motor de BD ni que componentes estás utilizando, pero intentá armar tu consulta de este modo:

sql := 'select * from ingresos where Fecha = ' + QuotedStr(sFecha);

Siempre que la variable sFecha sea de tipo string...

Un saludo.

roman
05-10-2011, 22:33:33
Corrijo no sale El mensaje de error:

'Dynamic sql error
SQL error code =-206
Column Unknown
29/09/2011
At line 1 Column 30'

Pues hombre, el error parece no dejar dudas: el campo fecha no existe (está en la línea 1, columna 30 de tu consulta).

// Saludos

salvica
05-11-2011, 00:07:40
Pues hombre, el error parece no dejar dudas: el campo fecha no existe (está en la línea 1, columna 30 de tu consulta).

// Saludos
Perdón, el campo FECHA no, lo que no encuentra es el campo 29/09/2011. :D

Supongo que está utilizando Firebird y cuando encierras un dato entre comillas dobles, lo toma como el nombre de una variable (o un campo)

En su consulta pone:
sql := 'select * from ingresos where Fecha = "' + sFecha + '"';
y debería ser:
sql := 'select * from ingresos where Fecha = ''' + sFecha + '''';

Lo mejor sería que utilizases Parámetros, o la función StrQuoted (creo que se llama así :mad: )

Saludos
salvica