topic-44154

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Tdatabase ordcreate temp
Posted: Fri Jan 26, 2024 12:01 PM

I use tdatabase

Select( oTemp4:nArea )

index on oTemp4:jump To Temp

why make error ?

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Tdatabase ordcreate temp
Posted: Fri Jan 26, 2024 11:15 PM

if DBFCDX

Code (fw): Select all Collapse

INDEX ON FIELD JUMP TAG JUMPTMP TO TMP TEMPORARY

OR
Using this syntax:

Code (fw): Select all Collapse

METOD CreateIndex( cFile, cTag, cKey, lUnique, lDescend, lMemory )

Code (fw): Select all Collapse

oTmp4:CreateIndex( "TMP", "JUMPTMP", "JUMP", nil, nil, .T. )

Regards

G. N. Rao.

Hyderabad, India

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: Tdatabase ordcreate temp
Posted: Sat Jan 27, 2024 09:37 AM

nageswaragunupudi wrote:if DBFCDX
Code (fw): Select all Collapse
INDEX ON FIELD JUMP TAG JUMPTMP TO TMP TEMPORARY
OR
Using this syntax:
Code (fw): Select all Collapse
METOD CreateIndex( cFile, cTag, cKey, lUnique, lDescend, lMemory )
Code (fw): Select all Collapse
oTmp4:CreateIndex( "TMP", "JUMPTMP", "JUMP", nil, nil, .T. )

thanks

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

FiveTech Support Forums

Continue the discussion