We're definitely doing the search in the correct manner; I learnt about that the hard way a few years back.
SQL logging makes for interesting reading, I've grepped out "my" entries into another file, and will start looking through it. Haven't had much experience of this type of debugging before, so it should make for an interesting time. And its typical, today I was wanting to get onto some more "regular" ARS development, but I'm having to troubleshoot a bunch of other applications instead. Has to happen on one of the first days when our lead developer is out on paternity leave (Graham, when you read this, congrats on the birth). Regards Dave On 01/12/06, Carey Matthew Black <[EMAIL PROTECTED]> wrote:
Dave, This is a WAG without seeing the SQL in question... but... I would make sure that the user is using the following procedure. 1) Open form in Query mode. 2) Specify search conditions 3) DO NOT DO THE SEARCH 4) Jump directly to the report selection screen from the QUERY window. 5) select the report in question. 6) Extract the data. Because there can be "issues" when the user use the following procedure: 1) Open form in Query mode. 2) Specify search conditions 3*) DO THE SEARCH 4*) Select some set of record from the Results list or none 5) Open the report selection screen from the MODIFY window. 6) select the report in question. 7) Extract the data. The details (of why it matters) have to to with the query that is passed to the DB. When the Query is the Search conditions it is normally much shorter than the query passed when it is a list of selected (or already returned) 'Entry ID' values. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 12/1/06, Dave Barber <[EMAIL PROTECTED]> wrote: > ** > All, > > One of our users is running a report/extract against a join form. You can > browse the join form without any issues, but upon running the report and > extracing the data, you get the following : > > Error occurred in generating report. > ARERR [552] failure during SQL operation to the database : Line 1; Incorrect > syntax near ')' (SQL Server 170). > > From what I've browsed, that seems to imply that we have a field with a > label of ')'. The only field labeled with a non-text character is labelled > with a dash (-). Its not this field thats throwing out the extract (removal > of it still leaves the same issue). > > Its an in-house application, running on ARS 5.1.2 against a SQL Server > database. > > Any suggestions? > > Regards > > Dave _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"