When a double is about te be entered, the user gets a message box, warning him that a person with a specific name and dob already exists. The user can...

great!

espacially the DIFFERENCE function helped me! if difference is 3 or 4 then a warning message is displayed ...

thx

lcase all the words but the first one and the user won't notice what you are doing 😉

Thank you for the discussion above ...

CONVERT(char(8),YourDate,112) seems nice, now to braintease again, is there a function in...

thx!!

Learned something here to dynamically rename fields in a view

complete SQL statement:

SELECT TOP 100 PERCENT dbo.qryTypeInfo.id, dbo.qryTypeInfo.naam_info + ISNULL(' (' + dbo.qryTypeInfo.formaat...

thx, it works now, but is this way faster then using an ado connection to execute a local sql statement?

thx!! it works

the actual stored procedure to erase the 'datumarchief' date and undelete record gives me a problem.

CREATE PROCEDURE "spDoUndelete"

(

@id int(4),

@tablename nvarchar(300)

)

AS

SET NOCOUNT ON

UPDATE @tablename SET datumarchief = NULL...

Is there a way to automate the creating of triggers?

and ...

Anybody who knows a sp or something else to see all the triggers voor a specified database?

would help a lot ...

ok, guess I have to add triggers to all the tables ...

daim 57 tables ... 🙁