Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best practice for relocating a table within a DBC
Message
From
18/05/2006 13:18:33
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01123249
Message ID:
01123309
Views:
20
This message has been marked as the solution to the initial question of the thread.
>Hi,
>
>When constructing a DBC, VFP allows you to add tables from various locations (folders).
>
>If I wish to relocate a table from one folder to another, how is this best accomplished without causing the DBC to lose its link to the table.
>
>EG: MYDBC resides in c:\test\data
> TBL1 also resides in c:\test\data as part of MYDBC
> TBL2 resides in c:\test\misc as part of MYDBC
>
>I want to relocate TBL2 (from c:\test\misc) to the same folder as MYDBC (c:\test\data). Best way to do this?
>
>Also, the TBL's all contain long field names (>10 characters) and possibly rules and triggers.
>
>TIA

You can do it in severals ways. One way would be to create its code with gendbc and edit code,run.
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
Next
Reply
Map
View

Click here to load this message in the networking platform