Hi,
Could you show us the error message so that we can solve the problem more quickly. In your case, I think there's no relationship with Windows platform.Maybe you haven't attached your database into your current SQLServer properly.You may backup your database from your old SQLServer and restore the backup file into the new one. Thanks.
dear
i've an old sql server 2000, with default date format mm/dd/yyyy
i've installed a new one SQL server 2005 , my application did't work with its date format
i wan't to change SQL 2005 default date format to mm/dd/yyyy instead of dd/mm/yyyy
regards
Dates are displayed as configured for the user (its a session setting). But formatting of the dates should be made in the front end / presentation layer. Don′t do that on the server, try to pass the date in a more generic format like ISO Date. 20061114
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Currently my application running on Sql-Server 2000 and I want to upgrade with Sql-Server 2005
will It work sql- server 2005?
if no what changed i need to do?
Can anyone help me?
Thanx
Move the thread from Visual Basic General forum. The question is mainly on SQL Server upgrading issue. There are more exports in SQL Server Setup & Upgrade forum, I believe you can get the satisfying answer in this forum.
Thanks again for your question.
|||Yes ! There are 2 types of upgrades available,http://msdn2.microsoft.com/en-us/library/ms144256.aspx upgrade advisor
http://msdn2.microsoft.com/en-us/library/ms144245.aspx
Currently my application running on Sql-Server 2000 and I want to upgrade with Sql-Server 2005
will It work sql- server 2005?
if no what changed i need to do?
Can anyone help me?
Thanx
Move the thread from Visual Basic General forum. The question is mainly on SQL Server upgrading issue. There are more exports in SQL Server Setup & Upgrade forum, I believe you can get the satisfying answer in this forum.
Thanks again for your question.
|||Yes ! There are 2 types of upgrades available,http://msdn2.microsoft.com/en-us/library/ms144256.aspx upgrade advisor
http://msdn2.microsoft.com/en-us/library/ms144245.aspx
hi,
I'm having this application using the express way to create the dategridview by having the query string builder. However, my computer recently crashed and I have no idea to change the connection string. so when I load the whole windows application, I am unable to view the information that are supposed to be in the datagridview. however, it returned an exception.
after finding out the main culprit, I realised that the database is using the old sql server's login. since it is using the old database's login, therefore it is unable to log the information into the datagrid view.
Please help! Thanks.
I'm sorry to hear that your computer crashed. Did you mean to change connection strings for typed DataSet which you created via "Data Source Configuration Wizard"? If so, you only need to change the corresponding Data Connection in the Server Explorer, as all Typed DataSet generated by the wizard use connectionstrings defined in Data Connections. If you want to configure connection string for individual TableAdapter, you need to open the typed DataSet in Design view, and right click on the TableAdapter->choose Configure...->press Previous button untill you rearch the "Choose Your Data Connection" step.
Hope this helps.
|||thanks for the guide..I'll try and see if it works in other computer..
Cheers,
Joelle
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implementIReportViewerMessages or could not be found".
When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||PedroMarques wrote:
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy
|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implement IReportViewerMessages or could not be found".how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||PedroMarques wrote:
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implementIReportViewerMessages or could not be found".
When I try to use this class in other keys at web.config, everything is OK...|||Most likely the problem is that the class could not be found. Are you using the fully qualified name of the class, including the assembly and public key if necessary?|||Well, I tried... Is there any example of using this feature? It'll be very useful!|||There are some sample implementations on MSDN, though it sounds like your issue is with deployment, not implementation. Will you post the exact line you are adding to the web.config file? You should be able to take the config file value and pass it to Type.GetType() without errors. Your assembly should also be in the same location as the rest of your binaries or in the GAC.|||
how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
I develop some application using SQL Server Reporting Services 2005 to Russian customers. They usually don't know English well. That's why I really want to change phrase "Report is being generated" to Russian words.
How can I do it? I tried to fing this phrase in configuration files or registry but there wasn't success.
Thank you,Hi,
If I change the language of the browser, the language of the "Report is being generated" changes. Not sure if you have already tried this. If you have, then I'm guessing the Server doesn't have Russian language capabilities. I tried in Russian and it didn't work.
Tommy
|||Well, I use Russian version of Internet Explorer and English version of SQL Server. There is no Russian SQL Server yet.
So, maybe there is any "low-level" feature to change this phrase?|||
If you are using the ReportViewer control, you can customize the message by implementing IReportViewerMessages. The specific property that will help you is ProgressText.
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx
|||Well, I tried to do this. I full copied sample but all the time I receive "The type MySample.CReportViewerCustomMessages does not implement IReportViewerMessages or could not be found".how can i create assembly for web config,
my class name inherited from IReportMessages name is "newMessages" and its in app_code. my project has not namespace.
my project name is reportWeb.(reportWeb/app_code/newMessages class path)
|||You can set the value of the web.config entry to:
value="Namespace.Classname, APP_CODE"
If you have no namespace, then:
value="Classname, APP_CODE"
|||I solved, it was my fault.When I looked assamblies I have created two version, I was giving wrong version of assambly.I deleted that then I give the valid one to referance web.config It is worked.Thanks.
|||I'm getting the same error over and over, I try a lot of stuff but nothing takes me to the solution!
Can anyone give a complete walkthrought since the creation of a classe to the final web.config edit? Please!
Thanks!
|||first you should create class library project.
I create strong key with "sn -k <project path>".
my project name is prometus, and my class name msg which is inherited from IReportViewerMessages
"namespace Prometus
{
public class msg:IReportViewerMessages
{".
Then implement the Interface.
then in AssemblyInfo.cs give your strong named key path.(if your .snk file is not in your project path use full path sample: "c:\a.snk")
[assembly: AssemblyKeyFile("..\\..\\a.snk")]
then build your project.
you should load assembly to gac.
in command prompt use gacutil -i "your dllname".
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
then add the appsettings key like this
<!--<add key="ReportViewerMessages" value="Prometus.Msg, Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->
|||
Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
|||Thanks for your information!
I read and implement every line that you give, but I'm having trouble to understand the procedure in the line: "
at last add referance the aspx project which you load assembly to gac.When you add the referanc you will see in web.config something like my simple:
<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->"
I'm using the Reporting Services of the SQL Server 2005 and did't find the right place to put the "<!--<add assembly="Prometus, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2012E2319B76027D"/>-->" Can you help me in this one too?
Thanks for all your help!
I forgot to tell one thing, I'm trying to translate the Report Manager of the Report Server Browser! I'm not creating a project that uses the report view component...
This quote was just to clarify this point...
Thanks again for your time!
The system allows an administrator (though it's not strictly relevant,
this is through an ASP.NET front end) to determine "rules" for
employees. A rule will consist of a Rostered Start Time (the time that
an employee or group of employees is expected to "clock on"), a
threshold allowance for early and late starts, and a Minimum and a
Maximum number of minutes that an employee is expected to work. This
table is called tblTSRule (see DDL below).
Another part of the system assigns a rule to one or more employees.
The table that stores this data is called tblTSEmpRules. The columns
in this table contain links to the tblTSRule table, the tblEmployee
table, the date for which this rule applies, and the two fields that
are at the heart of this question. These are fldLowerBound and
fldUpperBound.
All employee timesheet entries (which are via a barcode scan on their
id badge) are simply raw data - the system captures the EmployeeID, the
location and the time of the scan. It doesn't differentiate between a
"clock on", a "clock off" or a "sub duty" (where an employee has left
their normal place of work to do a rostered duty at another location).
These raw "scans" are processed en bloc at a later date. To
illustrate, the UI presents the user with a range of dates, and the
user can then "apply the rules" to a date or range of dates.
At this point the system needs to collate all the raw scans according
to the date that they wish to process. However, let's say that the
date is the 31st January, but some of the employees for that date are
working a late shift. Logically, therefore, some of the relevant scans
will actually occur on 1 February.
In order to get all the relevant scans for each employee, therefore,
the "rule" for an employee for any particular date will contain the
Lower and Upper bounds between which all raw scans should be processed.
We found that with a typical data load of around 1,200,000 records
that processing was very slow if the lower and upper bounds were
calculated "on the fly" in the SQL, so instead we decided to store this
calculated data in the table itself. Codd may not like it, but it's
expedient.
The two fields fldLowerBound and fldUpperBound are calculated or
recalculated EITHER when a row in the tblTSRule table is updated or
when rows in the tblTSEmpRules table are either inserted or updated.
This is done via INSERT and UPDATE triggers. There is no requirement
to have an INSERT trigger on the tblTSRule, since creating a new rule
automatically removes the possibility that there are any related rows
in the tblTSEmpRules table. The triggers are scripted below.
What we are finding is that if an update is made on the tblTSRule
table, it fires TWO triggers - first the UPDATE trigger on the
tblTSRule table (which updates the tblTSEmpRules table) and then the
UPDATE trigger on the tblTSEmpRules table. The two triggers are
virtually identical, but what can we do in terms of design to get
around this? I should point out that the ability exists in the
application to amend both rules and the assignment of rules to
employees.
Thank you for reading this far. DDL below.
Edward
========================
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_tblTSEmpRules_tblTSRules]') and
OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[tblTSEmpRules] DROP CONSTRAINT
FK_tblTSEmpRules_tblTSRules
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[CreateEmpCaptureBound]') and OBJECTPROPERTY(id,
N'IsTrigger') = 1)
drop trigger [dbo].[CreateEmpCaptureBound]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[CreateCaptureBound]') and OBJECTPROPERTY(id,
N'IsTrigger') = 1)
drop trigger [dbo].[CreateCaptureBound]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[UpdateCaptureBound]') and OBJECTPROPERTY(id,
N'IsTrigger') = 1)
drop trigger [dbo].[UpdateCaptureBound]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblTSEmpRules]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[tblTSEmpRules]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblTSRule]') and OBJECTPROPERTY(id, N'IsUserTable')
= 1)
drop table [dbo].[tblTSRule]
GO
CREATE TABLE [dbo].[tblTSEmpRules] (
[fldEmpRuleID] [int] IDENTITY (1, 1) NOT NULL ,
[fldDate] [datetime] NULL ,
[fldEmployeeID] [int] NULL ,
[fldRuleID] [int] NULL ,
[fldLowerBound] [datetime] NOT NULL ,
[fldUpperBound] [datetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblTSRule] (
[fldRuleID] [int] IDENTITY (1, 1) NOT NULL ,
[fldCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
[fldDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[fldRosteredStart] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
[fldEarlyStartArb] [int] NULL ,
[fldLateStartArb] [int] NULL ,
[fldMinMins] [int] NULL ,
[fldMaxMins] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblTSEmpRules] WITH NOCHECK ADD
CONSTRAINT [PK_tblTSEmpRules] PRIMARY KEY CLUSTERED
(
[fldEmpRuleID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblTSRule] WITH NOCHECK ADD
CONSTRAINT [PK_tblTimesheetRules] PRIMARY KEY CLUSTERED
(
[fldRuleID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblTSEmpRules] WITH NOCHECK ADD
CONSTRAINT [DF_tblTSEmpRules_fldLowerBound] DEFAULT (getdate()) FOR
[fldLowerBound],
CONSTRAINT [DF_tblTSEmpRules_fldUpperBound] DEFAULT (getdate()) FOR
[fldUpperBound]
GO
ALTER TABLE [dbo].[tblTSRule] WITH NOCHECK ADD
CONSTRAINT [DF_tblTSRule_fldRosteredStart] DEFAULT ('00:00') FOR
[fldRosteredStart],
CONSTRAINT [DF_tblTSRule_fldMaxMins] DEFAULT (0) FOR [fldMaxMins],
CONSTRAINT [IX_tblTSRules_1] UNIQUE NONCLUSTERED
(
[fldCode],
[fldSubAreaCode]
) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
CREATE UNIQUE INDEX [IX_tblTSEmpRules] ON
[dbo].[tblTSEmpRules]([fldEmployeeID], [fldDate]) WITH FILLFACTOR = 90
ON [PRIMARY]
GO
CREATE INDEX [IX_tblTSEmpRules_1] ON [dbo].[tblTSEmpRules]([fldDate])
WITH FILLFACTOR = 90 ON [PRIMARY]
GO
CREATE INDEX [IX_tblTSRules] ON [dbo].[tblTSRule]([fldCode]) WITH
FILLFACTOR = 90 ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblTSEmpRules] ADD
CONSTRAINT [FK_tblTSEmpRules_tblEmployee1] FOREIGN KEY
(
[fldEmployeeID]
) REFERENCES [dbo].[tblEmployee] (
[fldEmployeeID]
),
CONSTRAINT [FK_tblTSEmpRules_tblTSRules] FOREIGN KEY
(
[fldRuleID]
) REFERENCES [dbo].[tblTSRule] (
[fldRuleID]
) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[tblTSRule] ADD
CONSTRAINT [FK_tblTSRules_tblSubArea] FOREIGN KEY
(
[fldSubAreaCode]
) REFERENCES [dbo].[tblSubArea] (
[fldSubAreaCode]
) NOT FOR REPLICATION
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE TRIGGER CreateEmpCaptureBound ON dbo.tblTSEmpRules
FOR INSERT,UPDATE
AS
-- Calculate the EARLIEST POSSIBLE clock in time for this
employee/rule/date record and write it to fldLowerBound.
-- Calculate the LATEST POSSIBLE clock out time for this employee/rule
record/date and write it to fldUpperBound.
-- Write data to ALL affected rows.
update tblTSEmpRules
set
fldLowerBound =
dateadd(
mi,
( tblTSRule.fldMaxMins - 1440 ) * 0.5,
dbo.fnGetDateFromDateAndVarCharTimeParts(-- Rostered start date &
time
inserted.fldDate, -- Date on which rule is to be applied
tblTSRule.fldRosteredStart)-- Time
),
fldUpperBound =
dateadd(mi,
( tblTSRule.fldMaxMins + 1440 ) * 0.5,
dbo.fnGetDateFromDateAndVarCharTimeParts(-- Rostered start date &
time
inserted.fldDate,-- Date on which rule is to be applied
tblTSRule.fldRosteredStart)-- Time
)
FROM inserted INNER JOIN
tblTSRule ON inserted.fldRuleID =
tblTSRule.fldRuleID
WHERE inserted.fldEmpRuleID=tblTSEmpRules.fldEmpRuleID
print 'Trigger for TSEmpRules fired...'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE TRIGGER UpdateCaptureBound ON dbo.tblTSRule
FOR UPDATE
AS
update tblTSEmpRules
set
fldLowerBound =
dateadd(
mi,
( inserted.fldMaxMins - 1440 ) * 0.5,
dbo.fnGetDateFromDateAndVarCharTimeParts(-- Rostered start date &
time
tblTSEmpRules.fldDate, -- Date on which rule is to be applied
inserted.fldRosteredStart)-- Time
),
fldUpperBound =
dateadd(mi,
( inserted.fldMaxMins + 1440 ) * 0.5,
dbo.fnGetDateFromDateAndVarCharTimeParts(-- Rostered start date &
time
tblTSEmpRules.fldDate,-- Date on which rule is to be applied
inserted.fldRosteredStart)-- Time
)
FROM inserted
WHERE inserted.fldRuleID = tblTSEmpRules.fldRuleID
print 'update trigger for TSRule fired.....'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO(teddysnips@.hotmail.com) writes:
> What we are finding is that if an update is made on the tblTSRule
> table, it fires TWO triggers - first the UPDATE trigger on the
> tblTSRule table (which updates the tblTSEmpRules table) and then the
> UPDATE trigger on the tblTSEmpRules table. The two triggers are
> virtually identical, but what can we do in terms of design to get
> around this? I should point out that the ability exists in the
> application to amend both rules and the assignment of rules to
> employees.
There are a couple of options.
1) Set the configuration option "nested triggers" to 0. But this is a
server-wide option. I recommend that you leave it on.
2) In the trigger tblTSEmpRules add:
IF NOT EXISTS (SELECT * FROM inserted WHERE
fldLowerBound IS NULL OR fldUpperBound IS NULL)
RETURN
3) In the trigger TSRules add:
CREATE TABLE #no$cascade(a int NOT NULL)
And in the other trigger add:
IF object_id('tempdb..#no$cascade') IS NOT NULL
RETURN
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||>> I have an application to capture and process timesheet information. Put simply, employees clock in and out at various locations. Business logic determines how to process these events... <<
Take a look at the job clock at http://www.exaktime.com. I designed
their database, and I did not need triggers.
I am writing questions for two exams do not have time to go thru your
code right (and clean out all the "tbl-" and 'fld-" prefixes, bring it
up to ISO-11179, remvoe IDENTITY columns, etc.) But based on a quick
scan, it looks like it could made much easier.
Hi All, Does anyone have already made an application that writes some data into the EDB Pocket database ? I′m trying to insert a record with a empty FILETIME field and I′m getting the Error 87 (INVALID_PARAMETER), I′ve tested with some date in the field and the record is added sucessfull, it seems that the database doesn′t accept anymore empty FILETIME fields? Is it true? I didn't find anything in the docs.
thanx in advance.The CEPROPVAL is OEM dependent. Have you verified the behavior on other devices too? If that remains the same, I need to investigate further.|||
Hi Thiago,
Are you using CeWriteRecordProps (EDB)? If so, then yes you would get error if you are passing empty FILETIME field. Somehow, this is missed in documentation. We have a bug for that, and I would check the status.
Please pass non-empty FILETIME to get yourself unblocked. Sorry for the pain created.
Thanks,
Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation
|||Hi Laxmi,
Thank you very much for your reply, I′m passing now a non-empty FILETIME and it's working very well, now I'm stuck in another function, a similar problem with the CeSeekDatabaseEx funcion, especially when used with the CEOID, BEGINNING, LAST or CURRENT flags.
In the documentation, MSDN says that isn't necessary to open the database with a sort order when seeking with these flags, but if I do this, get the same ERROR 87 (INVALID_PARAMETER).
The function only works (find a record sucessfully) when I open the database specifing a sort order.
Do you know something about this issue?
In the documentation is:
The ERROR_INVALID_PARAMETER may be returned in the following situations:
x. The database was opened without a specified sort order, and dwSeekType is
a value other than the following:
CEDB_SEEK_CEOID
CEDB_SEEK_BEGINNING
CEDB_SEEK_CURRENT
CEDB_SEEK_END.
All other seek types require the use of a sort order.
link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wcedata5/html/wce50lrfCeSeekDatabaseExEDB.asp
Thanx in advance,
Thiago
Hi All, Does anyone have already made an application that writes some data into the EDB Pocket database ? I′m trying to insert a record with a empty FILETIME field and I′m getting the Error 87 (INVALID_PARAMETER), I′ve tested with some date in the field and the record is added sucessfull, it seems that the database doesn′t accept anymore empty FILETIME fields? Is it true? I didn't find anything in the docs.
thanx in advance.The CEPROPVAL is OEM dependent. Have you verified the behavior on other devices too? If that remains the same, I need to investigate further.|||
Hi Thiago,
Are you using CeWriteRecordProps (EDB)? If so, then yes you would get error if you are passing empty FILETIME field. Somehow, this is missed in documentation. We have a bug for that, and I would check the status.
Please pass non-empty FILETIME to get yourself unblocked. Sorry for the pain created.
Thanks,
Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation
|||Hi Laxmi,
Thank you very much for your reply, I′m passing now a non-empty FILETIME and it's working very well, now I'm stuck in another function, a similar problem with the CeSeekDatabaseEx funcion, especially when used with the CEOID, BEGINNING, LAST or CURRENT flags.
In the documentation, MSDN says that isn't necessary to open the database with a sort order when seeking with these flags, but if I do this, get the same ERROR 87 (INVALID_PARAMETER).
The function only works (find a record sucessfully) when I open the database specifing a sort order.
Do you know something about this issue?
In the documentation is:
The ERROR_INVALID_PARAMETER may be returned in the following situations:
x. The database was opened without a specified sort order, and dwSeekType is
a value other than the following:
CEDB_SEEK_CEOID
CEDB_SEEK_BEGINNING
CEDB_SEEK_CURRENT
CEDB_SEEK_END.
All other seek types require the use of a sort order.
link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wcedata5/html/wce50lrfCeSeekDatabaseExEDB.asp
Thanx in advance,
Thiago
