×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
My earlier question has been resolved. Can't skip a key field in a database and
get decent performance.
Now, I wondering:
Run the Crystal report. Export the rsssults to a flat file. First field would
be a complete primary key to the MS-SQL database. Third field would be the new
value for a single specified field.
One possibility would be to modify the text file to read like this:
update clinical set id= xxx where mrc=yyy
The above line would be modified so that a text file would have several thousand
individual update commands. The file would be input to a command line program,
name eludes me for the moment.
Is there a way to do all the updates with a single command?
John McKee
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
