Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing field names globally
Message
From
02/09/1998 12:09:33
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00132410
Message ID:
00132422
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform