|
Steven Have you considered using Query Management queries instead? I think the locking, if any, would be minimal, since it's really an SQL statement, not anything that has to check things in the file very much. If you have Query Manager, there's an interface very like the Query/400 one, until you get used to native SQL Or you just enter an SQL statement into a source member and run CRTQMQRY. There's also RTVQMQRY, which can convert a QRYDFN to a QMQRY source member. Not everything translates, but most does. And the layout is handled well by QMFORMs. Biggest problem is changing from RUNQRY to STRQMQRY Just a thought, but may solve your lock problem. Vern At 12:36 PM 9/5/02 +0100, you wrote:
This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] Just discovered the hard way that this solution hasn't fixed the problem of our Invoice File being locked when I save a Query/400 definition. This is becoming a big problem as the 'powers that be' want more reports on how sales are doing, but I can't save the Query definitions without stopping everyone in our Despatch area for 5 minutes... Steven Donnellan
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
