OK this is turning out to be relatively simple, but here's a basic SQL
question. Once I have identified the record whose contents need to be used
to update its matching record in the new database, is there a command that
will automatically write the entire record without me specifying each column
along with the value?
I know to retrieve all columns in a given record with the * wildcard. But
how can I write all those columns for that record into SQL7 with some type
of command? I'm not quite up to speed yet with all the SQL7 syntax.
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email: [EMAIL PROTECTED]
Voice: (816) 801-5200
Fax: (816) 880-4776
(800) 525-1101
CONFIDENTIALITY NOTICE: This email message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Ryan Hartwich
Sent: Monday, November 12, 2001 10:22 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] CF and SQL to migrate database
Your idea will only work if each table has a 'last inserted/updated'
field in it. If you have tables that have new insertions but no
timestamp than it won't work.
Also, you will have to write queries/copies for each table in the
database.
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
