[prev in list] [next in list] [prev in thread] [next in thread]
List: nsbasic-palm
Subject: [nsbasic-palm] res Db design Thank You
From: "Dwight Norris" <dnorris () fireserve ! net>
Date: 2004-08-28 19:58:48
Message-ID: 003901c48d39$709ff540$4d28b40c () 0021483099
[Download RAW message or body]
Mike thanks this sheds some light on dbKey I guess I have to do more reading where is that book
like it is not beside my desk at all times <g>
I have a few more fixes to try before I go back to the One Record at a time version of this app
I plan on not letting the user delete one record from what I call the matched set or records Trade keyed
& Generic keyed and see if this fixes one of the issues.
Also plan a complete new Db the current one has data from many versions of this little app
I do checking for dups if found then do an Update if no dup then Insert
I think the problem is letting the user do a delete of one set of records so the change will be
delete both or cancel only
I may move all the data to one db max has been 65 records to 100 records in the written Db
and 23 records in the interchange Db small Db's by comparison so no loss
After all this was a learning experience to see if I could link two Db's and now I know I can
I just do not think I can write two record sets at once time will tell
thanks for your time
dwight
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Mike thanks this sheds some light on dbKey I guess
I have to do more reading where is that book</FONT></DIV>
<DIV><FONT face=Arial size=2>like it is not beside my desk at all times
<g></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have a few more fixes to try before I go back to
the One Record at a time version of this app</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I plan on not letting the user delete one record
from what I call the matched set or records </FONT><FONT face=Arial
size=2>Trade keyed </FONT></DIV>
<DIV><FONT face=Arial size=2>& Generic keyed and see if this fixes one of
the issues.
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2></FONT> </DIV></FONT></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2>Also plan a complete new Db the current one has
data from many versions of this little app</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I do checking for dups if found then do an Update
if no dup then Insert</FONT></DIV>
<DIV><FONT face=Arial size=2>I think the problem is letting the user do a delete
of one set of records so the change will be</FONT></DIV>
<DIV><FONT face=Arial size=2>delete both or cancel only</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I may move all the data to one db max has been 65
records to 100 records in the written Db</FONT></DIV>
<DIV><FONT face=Arial size=2>and 23 records in the interchange
Db</FONT> <FONT face=Arial size=2>small Db's by comparison so no
loss</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>After all this was a learning experience to see if
I could link two Db's and now I know I can </FONT></DIV>
<DIV><FONT face=Arial size=2>I just do not think I can write two record sets at
once time will tell</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>thanks for your time </FONT></DIV>
<DIV><FONT face=Arial size=2>dwight </FONT></DIV>
<br><br>
<tt>
Community email addresses:<BR>
Post message: nsbasic-palm@yahoogroups.com <BR>
Subscribe: nsbasic-palm-subscribe@yahoogroups.com <BR>
Unsubscribe: nsbasic-palm-unsubscribe@yahoogroups.com <BR>
List owner: nsbasic-palm-owner@yahoogroups.com <BR>
<BR>
Shortcut URL to this page:<BR>
<a href="http://groups.yahoo.com/group/nsbasic-palm">http://groups.yahoo.com/group/nsbasic-palm</a> \
</tt> <br><br>
<!-- |**|begin egp html banner|**| -->
<br>
<tt><hr width="500">
<b>Yahoo! Groups Links</b><br>
<ul>
<li>To visit your group on the web, go to:<br><a \
href="http://groups.yahoo.com/group/nsbasic-palm/">http://groups.yahoo.com/group/nsbasic-palm/</a><br>
<li>To unsubscribe from this group, send an email to:<br><a \
href="mailto:nsbasic-palm-unsubscribe@yahoogroups.com?subject=Unsubscribe">nsbasic-palm-unsubscribe@yahoogroups.com</a><br>
<li>Your use of Yahoo! Groups is subject to the <a \
href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of Service</a>. </ul>
</tt>
</br>
<!-- |**|end egp html banner|**| -->
</BODY></HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic