Re: PreparedStatement.cancel() does not work with SP3

Noam,
Can you please post the code that you are using? I would like to try and
recreate what you are seeing -- but I want to make sure I am clear on what
you are doing.

Thanks.
Sue Purkis
DataDirect Technologies.

"Noam Ambar" <NoamAmbar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:929EE084-FFE8-4762-89E7-63467CB520AF@xxxxxxxxxxxxxxxx
> When using SP3, the cancel() call hangs until the long query ends and I
see
> that the query is still running in the database. With SP1, it canceled the
> query immediately.


.

Relevant Pages

  • Re: Parent/Child Relationship to Integrate Data in Reports
    ... I am working on updating my queries but am confident ... On the code to cancel the before update ... Create a query joining the projects and expenses tables. ... Join ProjectID from one table to ParentProjectID in the other. ...
    (microsoft.public.access.reports)
  • Re: Return to form if query unmatched
    ... Dim MyRecCount As Long ... If it doesn't pop up a message and set Cancel = True. ... record source of that form. ... If it is a sql then you should create a query with that sql, ...
    (microsoft.public.access.queries)
  • Re: Return to form if query unmatched
    ... The final solution I have gone with is using my original query as datasource ... Dim MyRecCount As Long ... If it doesn't pop up a message and set Cancel = True. ...
    (microsoft.public.access.queries)
  • RE: check qry on form close for null entrys
    ... criteria I just put Datebut it still gives me dates from way back. ... If you are using the query builder, don't put Null for each field in the ... show the MsgBox and not restrict the person from closing. ... cancel the close and present the records will Nulls in the form. ...
    (microsoft.public.access.gettingstarted)
  • RE: check qry on form close for null entrys
    ... If you are using the query builder, don't put Null for each field in the ... Put each Null criteria on a different line. ... show the MsgBox and not restrict the person from closing. ... cancel the close and present the records will Nulls in the form. ...
    (microsoft.public.access.gettingstarted)
Loading