Need some help with Paradox tables

Thread View: comp.lang.pascal.delphi.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Bill Artemik Sat, 24 Oct 1998 00:00

#118

Author: Bill Artemik
Date: Sat, 24 Oct 1998 00:00

31 lines
1521 bytes

I have to create a Paradox table with the following criteria:

1 Primary Index
1 Composite Unique Secondary Index

I need to do this in code. I have Ver 5.0 of the BDE and am working
with Delphi 3.02.

HOW can I accomplish this in code? I know how to create tables in
Delphi and I can create indexes, etc but the composite, unique is
throwing me for a loop.

Thanks anyone, for your help!

----
Bill
------------------------
artemik@worldnet.att.net
bartemik@neri.org
Programmer / Analyst
New England Research Institutes

"The two rules for success in life are:
        1) Never tell them everything you know."

             <?>

           \\\|///
          \\ ~ ~ //
           ( @ @ )
/-------oOOo-(_)-oOOo--------\

Re: Need some help with Paradox tables

#119

Author: Reid Roman
Date: Sat, 24 Oct 1998 00:00

40 lines
1863 bytes


Bill Artemik wrote:
> 
> I have to create a Paradox table with the following criteria:
> 
> 1 Primary Index
> 1 Composite Unique Secondary Index
> 
> I need to do this in code. I have Ver 5.0 of the BDE and am working
> with Delphi 3.02.
> 
> HOW can I accomplish this in code? I know how to create tables in
> Delphi and I can create indexes, etc but the composite, unique is
> throwing me for a loop.

I think:

MyTable.AddIndex('','DbYear;DbMonth;DbDate;',[]);

Should do it ...


Rkr

-- 
                   \|||/
                   /'^'\
                  ( 0 0 )
--------------oOOO--(_)--OOOo--------------
. Reid Roman			          .
. Delphi Programmer / Analyst	          .
. TVisualBasic:=class(None);	          .
. May the Source be With You		  .
-------------------------------------------
. Auto-By-Tel (http://www.autobytel.com)  .
. Irvine, CA U.S.A 			  .
. E-Mail : rkroman (at) pacbell (dot) net .
. or reidr (at) autobytel (dot) com	  .
-------------------------------------------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads