RV: HELP - SQL access problem

------ =_NextPart_000_01BD5A31.544A6160 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable HI I'm in trouble, I have a query in a program/REPORT that is doing some = really strange thing is an select join of two tables, and it just gets lost in the data and = never comes out of the foreach record on the select. I have an index for the two field '"dependencia" and "serial_cuenta" and anothen index for "dependencia", "serial", and "fecha_partida" but I do not think the query is going throu them. I did put at the = beginning of the program the set explain on, and I am attaching the = sqexp*.out file for you to see the query. If I get the query in the isql and run it with out the dates = "fecha_partida" and group it does come out fast, but as soon I include = the dates it get lost too. NOTE: The most strange thing is that I been following the execution of the = program in the tbmonitor/status/user option and as soon as it initiates = to execute the program gets a lock, the report does not have any insert = or delete or update statement, so why do I get a lock. Another thing is that when it reaches the query in discution in get in a = loop were it tryes to acces some (+- 40) record and then realeses them = because a time out which I think is because the lock.=20 So I keep seeing the status line of the user going from --B-R- to --B--- = (this status line is the last column in the tbmonitor/status/user option Please give me a clue, I do not get it, don't know what is happening Mili Barneond ------ =_NextPart_000_01BD5A31.544A6160 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IiMQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA8AQAAAMAAAAQAAAAAwAAMAQAAAAL AA8OAQAAAAIB/w8BAAAAaAAAAAAAAAC1O8LALHcQGqG8CAArKlbCFQAAAOiXdE3zd9ERgYAAALRl O0pEiQAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAQmlsbHkgV2hlZWxlcgBTTVRQAGJpbGx5QHdl c3QuY28uemEAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABEAAABiaWxseUB3ZXN0LmNvLnph AAAAAAMAFQwBAAAAAwD+DwYAAAAeAAEwAQAAABYAAAAnSW5meC0gQmlsbHkgV2hlZWxlcicAAAAC AQswAQAAABYAAABTTVRQOkJJTExZQFdFU1QuQ08uWkEAAAADAAA5AAAAAAsAQDoAAAAAHgD2XwEA AAAUAAAASW5meC0gQmlsbHkgV2hlZWxlcgACAfdfAQAAACwAAAC/AAAAtTvCwCx3EBqhvAgAKypW whUAAADol3RN83fREYGAAAC0ZTtKRIkAAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAAE EAAAAAMAADAFAAAACwAPDgAAAAACAf8PAQAAAHMAAAAAAAAAtTvCwCx3EBqhvAgAKypWwhUAAADo l3RN83fREYGAAAC0ZTtKRIEAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAEluZm9ybWl4IGxpc3QA U01UUABpbmZvcm1peC1saXN0QHJteS5lbW9yeS5lZHUAAB4AAjABAAAABQAAAFNNVFAAAAAAHgAD MAEAAAAcAAAAaW5mb3JtaXgtbGlzdEBybXkuZW1vcnkuZWR1AAMAFQwBAAAAAwD+DwYAAAAeAAEw AQAAABAAAAAnSW5mb3JtaXggbGlzdCcAAgELMAEAAAAhAAAAU01UUDpJTkZPUk1JWC1MSVNUQFJN WS5FTU9SWS5FRFUAAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAADgAAAEluZm9ybWl4IGxpc3QA AAACAfdfAQAAACwAAAC/AAAAtTvCwCx3EBqhvAgAKypWwhUAAADol3RN83fREYGAAAC0ZTtKRIEA AAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAAFEAAAAAMAADAGAAAACwAPDgEAAAACAf8P AQAAAG4AAAAAAAAAtTvCwCx3EBqhvAgAKypWwhUAAADol3RN83fREYGAAAC0ZTtKhIgAAAAAAACB Kx+kvqMQGZ1uAN0BD1QCAAABAGluZm9ybWl4IGxpc3QAU01UUABpbmZvcm1peC1saXN0QGlpdWcu b3JnAAAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABcAAABpbmZvcm1peC1saXN0QGlpdWcu b3JnAAADABUMAQAAAAMA/g8GAAAAHgABMAEAAAAQAAAAJ2luZm9ybWl4IGxpc3QnAAIBCzABAAAA HAAAAFNNVFA6SU5GT1JNSVgtTElTVEBJSVVHLk9SRwADAAA5AAAAAAsAQDoAAAAAHgD2XwEAAAAO AAAAaW5mb3JtaXggbGlzdAAAAAIB918BAAAALAAAAL8AAAC1O8LALHcQGqG8CAArKlbCFQAAAOiX dE3zd9ERgYAAALRlO0qEiAAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAAasEAEEgAEA HgAAAFJWOiBIRUxQIC0gU1FMIGFjY2VzcyBwcm9ibGVtACsJAQWAAwAOAAAAzgcDABwACgAGAAQA BgAOAQEIAAUABAAAAAAAAAAAAAEJAAQAAgAAAAAAAAABIIADAA4AAADOBwMAHAAKAAMAHAAGACMB AQmAAQAhAAAAOEM0MTY3RUMyM0M2RDExMTgxODAwMDAwQjQ2NTNCNEEA5gYBA5AGAKAHAAAkAAAA CwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADAC4AAAAAAAMANgAAAAAAQAA5AECoE2lj Wr0BHgBNAAEAAAABAAAAAAAAAB4AcAABAAAAGgAAAEhFTFAgLSBTUUwgYWNjZXNzIHByb2JsZW0A AAACAXEAAQAAABsAAAABvVhOvRtztMIjxA0R0YGAAAC0ZTtKAIUTsCAACwAXDAAAAAAeAB4MAQAA AAUAAABTTVRQAAAAAB4AHwwBAAAAFgAAAHJvZGV2YWxnQG5zLmd1YXRlLm5ldAAAAAMABhBW/sWA AwAHEFYEAAAeAAgQAQAAAGUAAABISUlNSU5UUk9VQkxFLElIQVZFQVFVRVJZSU5BUFJPR1JBTS9S RVBPUlRUSEFUSVNET0lOR1NPTUVSRUFMTFlTVFJBTkdFVEhJTkdJU0FOU0VMRUNUSk9JTk9GVFdP VEFCTEVTAAAAAAIBCRABAAAAQgQAAD4EAACpBgAATFpGdXdX2RgDAAoAcmNwZzEyNQYyAPgLYG5n NDEwOjYB9yACpAPjAgBjaMEKwHNldDAgBxMCgGZ9CoAIyCA7CW8OMDWzAoAKgXVjAFALA2MAQfEP AjMwOA5QC7YKsQqEmwsxA2B0BZAFQEhJFkghCoBJJ20gC4AgdAUDYHUCYGUsIEkggREAdmUgYSBx ClA8cnkYkhnQFwEJwGFtgC9SRVBPUlQYwEcRAAVABAAgZG8LgGe8IHMDcBmwCXAHQGwaMP5zGNAP ERmwG5AcMRZEG+EvA5ERMBkgF1FqHCEgb3JmGMB3bxjAAaAZIHNbGUAAcGQYkB8RdR0wIL0dgHQE IAkAIQEYomgZsM5kG7AZ0CBybmUZoAXA/wWgB4IIYAVAH4IiEQIQHMF/EPAcsQWhIJACICHzHsQu 3xerGXUDoAuAAQB4JDIh85UfsmYIkGwgkCciAQCmcAnwAQBuYwcwIiBj5iIRMAciX2MKUAIwKbD/ FkQgcgBwFyAiECdaKQsZQLcqJS2RKeNmBZARAF8Ksdx0aSJAKwUWRGIjoRlg7xwQIsAXIB2jayHz GfUEIJ5nHCMbkBjhIfJtLjCCHy9QGpAjoRuxIgJiZWf/C4ADABxBI9UapSVVBUAnoP8LUyUhIFQZ YDXhG7ABkBDwyzJ0JYFxNpEqLiOSKJD7GSAnw3ky4h/QETAdkjGlfyYMH5AZYCExMXoh5AQAcfMD ICBycnUnUQVAA/AbkH8jgyIFB5EurSBjCcAIYHCfIKIcEAeRIzIjg2ZhHTB/GUAwUkKgHGElMRlg C4BjfwpAAQA/OSCxPGIhgzpAb0EmC05PVEU6FkRU/yIRBGAhAR07G9IbkxlgNID3LAECEBzwbwPw OFUnoAWQ/SOgaSUxNS0h1QJQBGADALk6QHIvHTAbsCDwLyDw/SMBbwUwSwIrc0NFQzEgsf8LgCCw BzA/ojpBSqQ6lDWW5yEzGdAJAGNrGUAiAglw/nAJEUGkMOIm9RoyKjEjsf8FwAEAGSBQsQWxQVA/ gh0hvz+RB4ACMBlAHHA+oGgaMO8wsTxEUfQmBUErwyfySJr/VtAsAgVAJGNQAjy6M5AE8P9K5Bih PGIaUwkATgA+oASQ3z2RMQEaIFAEANBjB5Ecc4AoKy0gNDApJLZ/IHIr4xzCB5BapBiANIBj+mFN sSAZwS9AQiVW0A3g/ySgGWAxJBvhYXYiAlfDCuP1CoBTVyJrCeBBYDpxOEf/TVMhcAuAQjEj5E2z MlQDUsAgLS1CLVJfMDpB/2jCaMBfAB2xQ0FmqUjTZGH3QqEjIQpAbVwjTG9NfReq/lAZIEKgGbA0 oBmhHJEZ0D9D8RkzMLVcc0LBHBBuJ30FQGsrwAfgVtAbtBEAcBcpMR3XFkRNAxBpIEL/CsAi0AIg CzEWYxUAAUAPBhBcb2JqN+FwaFwWJxYmEfEAd4AAAAMAEBAAAAAAAwAREAAAAAADAIAQ/////0AA BzDAZLwLY1q9AUAACDDAZLwLY1q9AQMAJIAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAl gAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAALACaACCAGAAAAAADAAAAAAAAARgAAAAADhQAA AAAAAAMAJ4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAC3DQAAHgAogAggBgAAAAAAwAAAAAAAAEYA AAAAVIUAAAEAAAAEAAAAOC4wAAMAKYAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAqgAgg BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADACuACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAA AB4ALIAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAC2ACCAGAAAAAADAAAAA AAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAugAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAAB AAAAAAAAAAsAL4AIIAYAAAAAAMAAAAAAAABGAAAAABSFAAAAAAAAHgA9AAEAAAAFAAAAUlY6IAAA AAADAA00/TcAAPjJAgKQBgAOAAAAAQB5BQAAIAAgAAAAAAC/AAISgAMADgAAAM4HAwAZABIAEgAA AAMAGAECE4ADAA4AAADOBwMAGQASABIAAAADABgBAhCAAQAKAAAAU1FFWFAuT1VUALcCAhGABgCU DQAAAQAJAAADygYAAAAAIQYAAAAABQAAAAEC////AAUAAAAJAgAAAAAEAAAABwEBAGUAAABBC8YA iAAgACAAAAAAACAAIAAAAAAAKAAAACAAAAAgAAAAAQABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAD///8A8AAAA/AAAAPwAAAD8AAAA/AAAAPwAAAD8AAAA/AAAAPwAAAD8AAAA/AAAAPwAAAD 8AAAA/AAAAPwAAAD8AAAA/AAAAPwAAAD8AAAA/AAAAPwAAAD8AAAA/AAAAPwAAAD8AAAA/AAAAPw AAAH8AAAD/AAAB/wAAA/8AAAf/AAAP8EAAAABwEBAAUAAAAJAgEAAAAFAAAAAQIBAAAABQAAAAEC ////AAUAAAAJAgAAAAAEAAAABwEDACEGAABBC0YAZgAgACAAAAAAACAAIAAAAAAAKAAAACAAAAAg AAAAAQAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH9/f7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/ v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+/v7+