• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

DataControl recordsource Query Cancel

I have :
- DataControl (Data1)
- I can search in a database file with the following code:

Data1.databasename="c:\Proj\Data.mdb"
Data1.recordsource="select * from MyTable where Field1 like '*computer*'
Data1.refresh

My Quez is:
 How to CANCEL that QUERY, for example by pressing ESC key.
PLZ I want a sample code
I Dont Know any thing about SQL SERVER, So dont use it

Thanks
0
khalid_Z
Asked:
khalid_Z
1 Solution
 
TimCotteeHead of Software ServicesCommented:
Basically you can't, the data control is designed for simple data access and doesn't allow asynchronous queries. This means that from the point of issuing the query you cannot raise or handle any events within the VB application until it is complete. If you really have to do this then you should look at doing your data access through coding rather than using the controls in the toolbox. With coding you get much more flexibility and you may have the ability to issue a query as an asynchronous one which you CAN cancel if necessary.
0
 
elzohryCommented:
PLZ give me an example, to access that issue with code
0
 
DanRollinsCommented:
Hi khalid_Z,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept TimCottee's comment(s) as an answer.

khalid_Z, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
 
Computer101Commented:
Seems we have 2 accounts.  If no response in 72 hours I will suspend both.  Post here which account you would like to keep

Computer101
E-E Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now