×
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.
First of all, thanks to all for the help with this and other SQL issues
you've helped me with as I struggled with reaching the Advanced Novice
stage with SQL.
Secondly, identity_val_local() worked a charm.
Lastly, I have to admit that I am impressed with SQL's ease and
strength. I wrote a 500-line subfile program with 5 columns of data,
sortable on any column by clicking any column heading. Clicking that
column again sorts in the opposite direction. What makes sorting a
subfile useful with large data files is that each column also allows
wildcard searches so that subfile sizes can quickly be sized to 200-300
chosen records.
Here is a carousel of a some screen shots of the program.
http://martinvt.com/SQL_-simple-/SQL_Name_Editor/sql_name_editor.html
On 12/1/2015 8:58 AM, Birgitta Hauser wrote:
For a single row I normally prefer Identity_Val_Local()
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
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
