Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replacing field names globally
Message
De
02/09/1998 12:09:33
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00132410
Message ID:
00132422
Vues:
14
>I know I saw this somewhere, but I can't remember how to do this. I've got a report that was designed using table field names directly. I need to change it to a view instead. I don't want to have to manually edit every field to change (Table1.field1 to v_Table1.field1). Is there an easier way?
>
>Thanks
use myview alias "Table1"
is the easiest solution as long as aliasname not in use. Or modify the frx to remove alias so it will use whatever current alias is (report would have no table in its DE for this to work):
use myreport.frx
replace all expr with stuff(expr,1,at(".",expr),"") ;
    for expr = "table1."
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform