Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP Tip o' the Day
Message
 
À
20/04/2000 15:12:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00361872
Message ID:
00362025
Vues:
24
>>I've never seen that error. I can do:
>>
>>
>>USE myview NODATA
>>INDEX ON KeyID TAG KeyID
>>INDEX ON KeyDesc TAG KeyDesc
>>=REQUERY('myView')
>>
>
>If you do this on a calculated index expression (ie, padr(myfield, 25)) then it will die with an error about a zero length string. (I think, its been a while, I know that I had to give up on indexing with the nodata clause)

Nope. If it did this in earlier versions it must have been fixed. I tried the following with a remote view and all worked fine:

use Billing_Rates_View NODATA
index on Last_name+First_name tag Name
index on ALLTRIM(Last_Name) tag LastName
index on PADR(Last_Name,30) tag LastName2
=REQUERY('Billing_Rates_View'

Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform