|
The most common way of doing this is to use triggers on the table you want to check for changes in, and then save date and username in an other table.
You can also add two fields, last modifiedBy and lastModifiedTime to each table you want to check for changes in, in addition you add a trigger and copies these values to an other table eg: TableNameLog if the original table was named TableName.
If you do not wan to use triggers you have to save the information in two places when a save occurs. You can use client-code or storede procedrues in the database.
/M
|
|
|
|
|
Thank you Mattias for your replied.
I have a Login.aspx page. On my default.aspx page which is contained Database Table. I was wondering if you could please give me some sample code.
I wanted to add "Last Modified By" field table and if the Logged in user update the table then have his/her name display under that "Last Modified By".
Thanks again for your help.
Eyungwah
|
|
|
|
|
Hi Guys!
I'm working with SQL Server 2000 and I have only started working with it for the last 3 weeks now. I'm basically teaching myself how to use it. Therefore, lots of trial and error Here are the porblems:
When I create a report and try to run it by pressing the play button, I get a Cannot find TargetServer URL error message. What am I supposed to enter for TargetServer URL, please explain with as little jargon as possible.
Second problem: After I allow the report to continue its execution, the report will show the desired output, but, if I copy the rdl file to the server location that I want the report to be stored in, the report will not run. It gives me the following error message:-
"An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'XXXXX'. (rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied."
Whats going on? Please explain with as little computer jargon as possible.
Please note that I am working for a company that requires me to work with this software and there is no time to go for a course to learn the software, I need to urgently solve this problem asap. Please help me somebody, or else I'm fired!!! please help, somebody
|
|
|
|
|
I'm using SQL Server 2005.
Is there any function for converting a string to lower case except for the first one that should be upper case?
_____________________________
...and justice for all
APe
|
|
|
|
|
select upper(left(MyColumn,1)) + lower(substring(MyColumn, 2, len(MyColumn)))
from MyTable
|
|
|
|
|
Just be aware that there are a few oddball words like O'Daniel or McDonald etc that will need to have special consideration when proper casing text.
CleAkO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Hi,
i use a Firebird Embedded DB for my App and would like create all the tables etc. without typing 100 SQL Statements.
Does anybody of you know any tool which can do that? I just found some for the firebird SERVER not for the embedded one.
Thank you for helping.
|
|
|
|
|
I use IBExpert[^]
If you scroll to the bottom of the page, you'll find a link to the free Personal Edition.
|
|
|
|
|
Thank you, it works for me
For everyone else, if you use this tool on FB Embedded and you are promted for username and password but you never used it because you don't had to, use sysadmin / masterkey. That's the standard.
|
|
|
|
|
i want to execute the following string
insert into test values 'h"ll'
but it gives some error. which escape i should use,,,
please help me. any advise will be appreciated.
thanks in advance
sebastian
|
|
|
|
|
Sebastian T Xavier wrote: it gives some error
Be specific! What is the error message?
|
|
|
|
|
Incorrect syntax near 'h"ll'.
this is the error message, this is because of the " inside the string. how will we insert such strings into database.
thanks
sebastian
|
|
|
|
|
Try this:
insert into test values ('h"ll')
|
|
|
|
|
thanks
but this will not solve the problem.
i got it
thanks once again
sebastian
|
|
|
|
|
Sebastian T Xavier wrote: but this will not solve the problem
Yes, it does solve the problem. If it does not solve your problem then there is some missing information.
|
|
|
|
|
I've got 2 tables:
Province and Client
When I link Province with client i get the ff message
'Province' table saved successfully
'Client' table
- Unable to create relationship 'FK_Client_Province'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Client_Province". The conflict occurred in database "test", table "dbo.Province", column 'Province'.
karabo
|
|
|
|
|
not got your query in full.
can you please give the sql statement reselted in this error. along with the 1. parent able and chield table
2. primary keys on the tables
however what i under stook is province is parent and client is chield
if so one column like provienceID should be primary key in province table
and in client table's provienceID can refer to provience table
Regards
KP
|
|
|
|
|
Does SQL Server have an autonumber datatype which will increment when adding record
Karabo Mekgwe
|
|
|
|
|
YES.
CREATE TABLE tblA(
AutoID decimal(18, 0) NOT NULL IDENTITY (1, 1),
Col2 varchar(10)
)
|
|
|
|
|
yes that s IDENTITY
See the example :
CREATE TABLE Emp (EMPID int IDENTITY (1, 1) NOT NULL ,EMPNAME VARCHAR(20))
Above this examble Identity is like an auto increment.
The Parameters (1,1) represents Start Number, Increment Number
this example starts 1 and next incremented by 1
RK
RK
RK
|
|
|
|
|
yes that s IDENTITY
See the example :
CREATE TABLE Emp (EMPID int IDENTITY (1, 1) NOT NULL ,EMPNAME VARCHAR(20))
Above this examble Identity is like an auto increment.
The Parameters (1,1) represents Start Number, Increment Number
this example starts 1 and next incremented by 1
RK
|
|
|
|
|
Hi, sometimes when I execute a procedure, it quits in no time:
echo "execute procedure ro_main_tp_oc('ATS','EY','N')" | dbaccess prds
Database selected.
Routine executed.
Database closed.
I heard it's because some procedure was blocked and locks other procedures. How shall I check and resolve it?
I am using HP unix, informix.
Thanks!
lantianman
|
|
|
|
|
There aren't very many Informix guys on this forum - its mostly SQL Server, Access, Oracle and MySQL.
I would try using dbaccess to run the command interactively to see if you get any better clue about what is happening.
Blocking and locks would normally result in a procedure being really slow. If there is a problem then I would guess that the procedure contains:- A "set lock mode" or "set current lock timeout" statement that tells Informix to throw an error if it encounters a locked record (or the database has been configured with a "locktimeout" parameter).
- An update/delete statement or a "for-update" cursor statement.
- If no error message is being displayed then I would expect that the resulting timeout error is being swallowed a "whenever error" clause.
If there was a problem with blocking then I would have expected an error message to be displayed (especially given that Informix is such a mature product). Are you sure that the procedure is having problems?
Hope that helps. I haven't done Informix for a reeeeeeally long time.
Andy
|
|
|
|
|
Thank you for your reply! Seems the problem has gone after I wait for some time...
|
|
|
|
|
sir,
I have a table which is having duplicate and some distinct records. Please can anybody please tell me the SQL-Server-2000 query to get only the duplicate records.
Means I dont need those records, which are not duplicate, but I need to print only those records which are duplicate. Thank you.
Regards,
Mohd. Abdul Aleem,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|