I.T. Discussion Community!
-Collapse +Expand
Search Paradox Group:

-Collapse +Expand Paradox To/From
-Collapse +Expand Paradox Store

Prestwood eMagazine

November Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardQBE & SQL Topic   Print This     

Programming with QBE results

Programming with QBE results in QBE & SQL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Programming   results   Programming QBE   Programming QBE results  
London, -- UK

Hi - My wife and I have taken over Administration of a large Amateur Theatre company in London - the only salaried position (as a jobshare).  We have inherited "interesting" old procedures and equipment, including a PC running Windows 98 and a Paradox-based Box Office system called Databox.  It is my wish to develop better-looking sheets of daily bookings for the Box Office volunteer staff to use.  I have managed so far to create QBEs that select the desired data, but seat numbers have been defined as alphanumeric (by the Databox people, so I can't change the definition), with the result that they are sorted thus:

26, 27, 3, 33, 34, 4, instead of 3, 4, 26, 27, 33, 34.  I have 25 years' experience of programming, so I can cope with adding zeroes on the left and taking a three-character right substring, but the help in Paradox 7 doesn't give me enough idea as to how/where to insert this code so as to produce the required query results.

I should be grateful for specific help on this and general advice on procuring tutorials (preferably free!) to ease myself into programming.  We have no manuals.

 Thanks in advance!


 Posted 11 years ago (Thread Starter)
Comment Quote
About jontower -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12490, 2 replies
Thread Started 2/22/2008 7:20:50 PM
View Counter=2849
Last Reply Posted 2/23/2008 1:54:38 PM)
Location=London, -- UK 
Joined=11 years ago   MB Posts=5  
Most Recent Post
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Hi Jon,

I noticed you started subscribing to our monthly eMag but you still need to verify your email. Once you verify your email, you will receive one email per month containing Paradox and Visual Basic content (the two groups you chose).

If you verify your email this month, you'll receive the Feb Issue which also contains some useful information on virtualization features Microsoft introduced with Vista.

Mike Prestwood
Prestwood IT Solutions

 Posted 11 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #12493 (Level 1.1)  Reply to 12490
Thread Started 2/23/2008 1:54:38 PM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=70   BLOG, Topics=4  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

First--Get ahold of Mike Prestwoods book.  It is probably the best source to begin with.

Second--It is not possible to add code to a paradox query.

Third --Probably the best solution is to convert the query to a SQL query.  Then use the CAST function to convert the Alphanumeric field to an integer.  The resulting table should automatically be sorted.

syntax       CAST( <field name> as integer)

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions

 Posted 11 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #12491 (Level 1.2)  Reply to 12490
Reply Posted 2/22/2008 8:45:17 PM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  

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 (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12490 Counter
Since 4/2/2008

Follow PrestwoodBoards on: 

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