-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Setup, Vista, etc. Topic   Print This     

Logical Indexes

Logical Indexes in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Logical   Indexes   Logical Indexes  
gwatchmaker
none
-- USA

To all,

As I migrated from Paradox 8 to Paradox 11, I noticed that I was not able to recreate one of my secondary indexes in the newer version.  The secondary index included a numerical field and then a logical field.  The logical (boolean) field was not listed as one I could add in the table restructure dialog box.  I went back to version 8 and added it.  Is there another way to do this so that I can retire my older version.

Greg

 Posted 5 years ago (Thread Starter)
Comment Quote
About gwatchmaker
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18360, 1 reply
Thread Started 1/16/2021 6:37:28 AM
View Counter=604
Location=-- USA 
Joined=6 years ago   MB Posts=12  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

from the help

"You can define a secondary index on any field or group of fields in a table except memo, formatted memo, binary, OLE, graphic, logical,"

in general, I use number/integer/short field with 1/0 as the indicator values.. 1 is true, 0 is false.. probably cuz I go all the way back to the beginning of PdoxDOS, and there was no logical field :-)

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 5 years ago
Comment Quote
About Steven.G
Visit Profile
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 #18363 (Level 2) and Parent is 18360
Reply Posted 1/16/2021 7:02:25 AM
Location=Myrtle Beach, SC USA 
Joined=10 years ago   MB Posts=463  

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 = P1114A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #18360 Counter
604
Since 1/16/2021
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]