HTH,
Many thanks for that. My son has now done all the work and we have installed it on the clients site. Very neat. The only problem is to find the user ID, the way the application is used, the user is always "scala" (to do with security issues), the application has its own user ID security...
I have been told that the Manage Triggers is a good place to start, use that to add records to new tables and include whatever fields are needed plus the date/time and user id.
Anyone with experience of this?
I need to manage changes to several SQL tables, they can all go into a single or many log files.
Is there a way to do this within the SQL environment?
We are using an accounting system and the new reporting requirements are to report any changes to key tables. There is nothing in the software to...
I need to create a .csv file grouped by Account, Ccentre with 14 columns, OBAL, JAN, FEB, etc to CBAL.
I have existing views to get the data into the individual parts, the following is for JAN:
SELECT SUBSTRING(GL06001, 1, 4) AS Account, SUBSTRING(GL06001, 5, 4) AS Ccentre, GL06004 AS JAN...
Problem answered by another forum.
If you create the view for one table (or set of linked tables) and then save.
Go into the Properties of the view, add UNION ALL under the first script, note no hyphen required.
Now copy the first script into a text editor and change the table names as needed...
What are you using to access the data?
If MS Access for example, you can use the "not in" as part of the query.
The example I have in a book SQL Fundamentals (ISBN 0-13-096016-0) gives the following:
*************************************
select a.number_2,
a.word_2
from twos a...
I need to add data from 2 tables, Country1 and Country2, the layout is exactly the same in both tables.
In Access you can use the UNION_ALL (or UNION for a non-dup)but UNION is not supported in a View.
The end result is using Crystal Reports to do the summation on a single table/view.
Is...
