Network Version of Valentina

[Don Toro]

OK, I don't think I'm explaining this right.


Data in original Valentina 1 DB
Words Table
RecID     Word
1         word1
22        word1
34        word3
56        word4
71        word5

Data in new Valentina 2 DB after coversion
Words Table
RecID     Word
1         word1
2         word1
3         word3
4         word4
5         word5

Exported Data for the WordsScore table of V1 database
RecID,Score
1,25
22,100
56,34
71,0

The Words table is not going to change after the database is delivered to the end user. Let's say we have a table named WordsScore. This table has two colums one is a link to the RecID of the Word table and the other field has the score for that word. So lets say that I export the data from the WordsScore table in V1 database. Importing this data in the WordsScore table of V2 database would have an incorrect RecID. I cannot link by the Word field in the Words table because we can have duplicate words with different RecIDs. 

Does this make sense? I hope I did a better job at explaining this time. Thanks.

Donard Toro
Information Manager/Computer Programmer
-------------------------------------------------------------------
Thinking Publications, a division of
McKinley Companies, Inc.
424 Galloway Street, Eau Claire, WI 54703
Phone: 1.800.225.4769 (US) & 1.715.832.2488
Fax: 1.800.828.8885 (US) & 1.715.832.9082
www.ThinkingPublications.com
-------------------------------------------------------------------
COMMUNICATION SOLUTIONS THAT CHANGE LIVES
Specializing in resources for individuals
with speaking, listening, reading, writing, and thinking skill deficits


-----Original Message-----
From: Ivan Smahin [mailto:ivan_smahin at valentina-db.com]
Sent: Friday, February 10, 2006 3:45 PM
To: Valentina Developers
Subject: Re[2]: Network Version of Valentina


Hello Don,

Friday, February 10, 2006, 11:34:09 PM, you wrote:

> Is there a way to preserve the RecIDs? One of my tables has a list
> of words. Now if the RecIDs of the records of the Words table change
> after the coversion from V1 to V2 that represent a problems. The
> user will be able to export data from the V1 database into the V2
> database and vice-a-verca. When the user imports the data than the
> ObjectPtr will point to the wrong record in the Words table. The
> only way to get around this would be to keep my own ID which would
> be a problem this late in the game as it will require a change in
> the structure of the database. It would also require me to re-write parts of the program.

> What if I use VStudio to dump the data into a xml file and then
> re-import the data to create a copy of database in V1 format and a
> copy in V2 format, will the RecIDs match then? 


As  import/export,  so  Convert_1_2 corrects RecIDs on "load" in such a way, that
all linked records still be linked.



-- 
Best regards,
 Ivan                            mailto:ivan_smahin at valentina-db.com

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina