Index on logical with convert to string

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Index on logical with convert to string

Message

04/10/2004 18:56:35

Cetin Basoz
Engineerica Inc.
Izmir, Turquie

04/10/2004 18:26:57

John Fabiani
J.F. Computer Solutions
Woodland, Californie, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Index on logical with convert to string

Divers

Thread ID:

00948536

Message ID:

00948674

Vues:

>I guess I should have explained a little more. I need a compound index so I need string field + logical field.
>
>John

Transform(logical,'@Y') && T/F
Transform(logical,'Y') && Y/N
Transform(logical) && .T./.F.

PS: VFP9 binary indexes might encourage you to create noncompund faster/smaller indexes instead.
Cetin

Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad

Répondre

Fil

Voir

Click here to load this message in the networking platform