Change DM in frm to :alias: tbls without loss of code,formatting, ...? 
Author Message
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?

I made the mistake of creating an entire application using the default
(ie :WORK:) directory and all of the forms and reports have been completed
using data models made up of these tables (up to 20 in some cases).

Now I want to place the forms and reports on several client computers
and the data on a server, so that there is less time loading the forms as
this arrangement will avoid reading the forms and reports across the network.

When replacing a child table all of the field definitions, code and formatting
on it are lost.

If I change the data model in its entirety all of the fields are unefined.

Is it possible to correct my mistake easily?

--
Raymond Kennington                | Act in haste and repent at leisure
                                  | Code too soon and debug forever
University of South Australia     | ....Dale and Lily (I think)
Computer and Information Science  | Knobs, knobs everywhere,
Levels                            |        just vary a knob to think!
Pooraka 5095                      | ....Metamagical Themas, Hofsta"dter
South Australia



Thu, 02 Jul 1998 03:00:00 GMT
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?

Quote:

>I made the mistake of creating an entire application using the default
>(ie :WORK:) directory and all of the forms and reports have been completed
>using data models made up of these tables (up to 20 in some cases).

>Now I want to place the forms and reports on several client computers
>and the data on a server, so that there is less time loading the forms as
>this arrangement will avoid reading the forms and reports across the network.

>When replacing a child table all of the field definitions, code and formatting
>on it are lost.

>If I change the data model in its entirety all of the fields are unefined.

>Is it possible to correct my mistake easily?

Yes.  I know how, through painful experience (I did the same thing).

Copy the forms and reports to the target directory, then set the directory,
using the Project Viewer, to that directory.

Add references to the tables, using the alias for the directory (this step is not
absolutely required, but makes the following steps easier).  When you see the list
of tables in Project Viewer, you should see:
:AliasDirectory:Table1
:AliasDirectory:Table2
etc.

Open the forms and reports in design mode.  Paradox will complain that it
can't find the table, and ask you if you want to associate the form/report
with a different table.  Select the "Yes" button, and select the table
that you need.  The selection dialog box will include all tables in the Project
Viewer list by default (that's why you added the reference).  If you didn't
add the references, use the Directory/Alias drop-list to select the alias.

NOTE:  If the form or report has several tables attached,
make sure you note _which_ table it can't find _before_ you click the "Yes"
button.  Otherwise, you might end up attaching to the wrong table!

Once the form/report is open, just save it and close it.  Problem solved.

Best to make backups of your forms (or work from copies) before you start, of course.

Jim



Sun, 05 Jul 1998 03:00:00 GMT
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?

This is a repost as I have not received any replies.

I made the mistake of creating an entire application using the default
(ie :WORK:) directory and all of the forms and reports have been completed
using data models made up of these tables (up to 20 in some cases).

Now I want to place the forms and reports on several client computers
and the data on a server, so that there is less time loading the forms as
this arrangement will avoid reading the forms and reports across the network.

When replacing a child table all of the field definitions, code and formatting
on it are lost.

If I change the data model in its entirety all of the fields are unefined.

Is it possible to correct my mistake easily?
--
Raymond Kennington



Fri, 10 Jul 1998 03:00:00 GMT
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?
//I made the mistake of creating an entire application using the default
//(ie :WORK:) directory and all of the forms and reports have been
completed
//using data models made up of these tables (up to 20 in some cases).

//Now I want to place the forms and reports on several client computers
//and the data on a server, so that there is less time loading the forms
as
//this arrangement will avoid reading the forms and reports across the
network.

//When replacing a child table all of the field definitions, code and
formatting
//on it are lost.

//If I change the data model in its entirety all of the fields are
unefined.

//Is it possible to correct my mistake easily?

Here's what I have done:
1.  Set up an alias to the each directory where forms and data stored.
2.  Open your forms on your develop machine.
3.  Open the Data Model on the form.
3A.  I would also rename each table as an alias psuodo name (ie tableOne)
4.  Save the data Model
5.  Exit form.
6.  Open Data Model and change tables using alias rather than explicit
directory.
7.  Save new data model.
7.  Reopen Form.
8.  Open Data Model.
9.  load new data model.
10.  save form

that's what I've done.
Cheers!
   Tim Gunther --
   Visa USA



Sun, 12 Jul 1998 03:00:00 GMT
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?

Quote:
> When replacing a child table all of the field definitions, code and formatting on it are lost.

> If I change the data model in its entirety all of the fields are > unefined.

> Is it possible to correct my mistake easily?

Yes!  What you want to do first of all is to open each of your forms in design
mode.  Preferably all at once if you have enough memory.  For each form
sequentially, go into the data model and remove the table from the data model.  
You will get a message stating that you "Have Objects That Depend On . . ."  
Ignore the message.  Now, in the 'Drive' pull down select the alias that you have
created pointing to the new table and select the table.  Save the form.  UI
objects will not be changed.

One technique I have used with tableframes is as follows:  Make the tableframe
undefined.  This will not affect formatting or text.  Now if you were to select
a different table everything falls apart, but if you click on a single field on
the tableframe and select a specific field in the desired table it assigns the
table to the tableframe without changing any formatting.  You then need to proceed
field by field assigning the fields to the tableframe.

Hope this helps.

Daniel Morgan



Sun, 12 Jul 1998 03:00:00 GMT
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?

Quote:
> I made the mistake of creating an entire application using the default
> (ie :WORK:) directory and all of the forms and reports have been completed
> using data models made up of these tables (up to 20 in some cases).

> Now I want to place the forms and reports on several client computers
> and the data on a server, so that there is less time loading the forms as
> this arrangement will avoid reading the forms and reports across the network.

> When replacing a child table all of the field definitions, code and formatting
> on it are lost.

> If I change the data model in its entirety all of the fields are unefined.

> Is it possible to correct my mistake easily?

What I do is this:

1. Do something to cause the tables to be unaccessable, like
moving them or whatever.
2. Open each form, and when it asks you if you want to select a
different table, say yes, and select the new tables in the now
location.  You will have to do this for each table in each form.

This always works perfectly for me, never had a problem yet.

Good Luck

Glen



Sun, 12 Jul 1998 03:00:00 GMT
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?

Quote:

>I made the mistake of creating an entire application using the
>default (ie :WORK:) directory and all of the forms and reports
>have been completed using data models made up of these tables
>(up to 20 in some cases).
>Now I want to place the forms and reports on several client
>computers and the data on a server, so that there is less time
>loading the forms as this arrangement will avoid reading the
>forms and reports across the network.
>When replacing a child table all of the field definitions, code
>and formatting on it are lost.
>If I change the data model in its entirety all of the fields are
>unefined.
>Is it possible to correct my mistake easily?

You got it.  It is not possible to correct this except to
redefine everything if your intention is to use a different alias
name.  Otherwise, somewhere in your opening form use setAliasName
and point the WORK alias to the proper directory.
--


Mon, 13 Jul 1998 03:00:00 GMT
 Change DM in frm to :alias: tbls without loss of code,formatting, ...?
I would do as follows:

1.) Create the alias that you would use for your tables.

2.) Make sure that the tables are moved to their new locations and
that no copies of the tables are in the :WORK: directory.

3.) Your forms should now be separated from your tables.

4.) Open every form. When the form is opened Paradox complains it
can not find table named X. And ask if it should be replaced.

5.) Answer yes and point to the tables new location using the
alias.

6.) Save the form.

This should do the trick. If you have any question contact me via

/Thomas Blomqvist, Auriga AB, Sweden

--
/Thomas Blomqvist, Auriga AB, Stockholm Sweden

CompuServe: 100737,2176



Fri, 17 Jul 1998 03:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Changing alias in coding is not reflected until restart

2. "Alias" within DM

3. Using FoxPro 2.6 tables in VFP 5 without changing the Code Page

4. FYI, Sample Codes for Changing Locale Date Format

5. Converting VB3 .FRM and .BAS Binary format to VB5

6. FRM-40735 and FRM-40815

7. DMSample with DM Sample Provider Code

8. Formatting the date format without doing it in the cinnection string

9. Renaming master Keys without data loss (?)

10. how to fetch decimal columns without precision loss

11. how to fetch decimal columns without precision loss

12. Changing a field without knowing which field to change


 
Powered by phpBB® Forum Software