IT SOLUTIONS
Your TECHNOLOGY partner! 
Sign In Create a Profile
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox Group Home
-Collapse +Expand Message Board
-Collapse +Expand Paradox KB
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Study Test
PRESTWOODCERTIFIED
-Collapse +Expand Paradox Store
PRESTWOODSTORE
-Collapse +Expand Members Only

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:
   ► MB Lobby ► Corel Paradox / ObjectPAL Coding Board ► QBE & SQL Topic     Print This   

Problem with Delete QBE Queries

Problem with Delete QBE Queries in QBE & SQL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Problem   Queries   Problem Delete   Problem Delete QBE  
 Problem with Delete QBE Queries Post ID #14765, 1 reply 1/13/2012 7:49:42 AM  

John.C

We are currently experiencing a problem with 16bit Paradox 7.  When I run a delete query (QBE) the query completes and we would assume that all the data that we want to remove has been removed.

However, when we check the table we ran this query on only some of the data has been removed.  So we run the query again..  When we check the table more of the data has been removed but some is still left.

We have to repeat this multiple times before all the data is gone.  Each time we repeat it we don't modify the query - its the same one we ran 1st time around.

What could be causing this problem and how can we solve it?

I would appreciate all advice offered regarding this question.

Best Wishes

John
 Posted 16 months ago (Thread Starter)
Comment Quote
Location=London UK,  Joined=23 months ago   MB Posts=1  
More... -Collapse +Expand
John.C
London UK
Rank: Cadet 2nd Year
Email A E UK
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
Post ID #14765, 1 reply
Thread Started 1/13/2012 7:49:42 AM
View Counter=1096
Last Reply Posted 1/18/2012 2:18:56 PM)
Most Recent Post
 RE: Problem with Delete QBE Querie... 1/18/2012 2:11:44 PM  

A. I. Breveleri

Post the QBE.  Try to cut and paste it -- don't retype it.  Also, describe the structures of the tables referenced by the QBE.  Include validity constraints and secondary indices.

-Al.
 Posted 16 months ago
Comment Quote
Location=Boston, MA, USA,  Joined=12 years ago   MB Posts=277  
More... -Collapse +Expand
A. I. Breveleri
Boston, MA, USA
Rank: Commander
Email A E MA USA
Approved member.
Member subscribes to this thread with a verified email.
Post ID #14769 (Level 2) and Parent is 14765
Reply Posted 1/18/2012 2:11:44 PM

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post:

Enter your name and security key.

Your Name:
Today's security key = P187A
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14765 Counter
1096
Since 1/13/2012
-
  Load Time=less than 1 second.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood
Call: 916-726-5675
email: info@prestwood.com
Who's Online! PrestwoodBoards 
361 People Online Now!!  
Online Now: Sign In to see who's online now!  Not a member? Join now. It's free!
Show More...


©1995-2013 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech