|
HI,
I have 3 tables. I wish to select the latest Unit Rate from those tables....like SQL Cross Apply.Is it possible from Ms-Access?
The below SQL-Query Select the latest unit_price, price_date from three tables..... Itemmst, Pomst, Grinmst
Actually the query checks those three tables and will select the greatest Price_date and Unit_Rate
Select i.itm_code,i.itm_description,i.unit_measure,t.unit_rate,t.price_date from itemmst i cross apply ( select top 1 unit_rate,price_date from( select im.unit_rate,''as price_date,0 as ord from itemmst im where im.itm_code=i.itm_code and im.unit_rate is not null union all select unit_price as unit_rate,po_date as price_date,1 as ord from pomst where pomst.itm_code =i.itm_code and pomst.unit_price is not null union all select grinmst.unit_rate,grinmst.grn_date,1 from grinmst where grinmst.itm_code =i.itm_code and grinmst.unit_rate is not null )r order by price_date desc,ord desc )t
Output :-
- Item1, Pencil, Nos, 25.00, 26/03/2015 => from Grimst
- Item2, Pen, Nos, 22.00, 21/03/2015 => from Pomst
- Item3, Paper, Nos, 65.00, 01/04/2014 => from Itemst
Thanks
|
|
|
|
|
Short answer would be, yes you can use SQL-based commands for data in MS-Access, because MS-Access can also work with SQL commands. Please read this[^] for more.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
im basically wana make a project of microcontroller in which from inkcanvas what ever i draw , by sending drawing to microcontroller ,it will show on graphical lcd . as graphical lcd get "
const code char array[1024] = {
88, 160, 88, 160, 80, 16, 160, 96, 160,.....}" array as argument mean get array i.e array .. and display respected image on lcd . so problem is that i dnt understand how i get array of drawing in inkcanvas .plz gude me properly
malikkamranhafeez
|
|
|
|
|
i am monitoring a database table for data change like insert/Update. some sql dependency throw error i heard like when no activity is there for a specific table for long days like 3/4 days. i am trying to say if i am monitoring a table and if no data inserted or updated in that table for long time then SQL Dependency throw error. here is my code. please see my code and tell me am i handing the error properly.
my sql dependency code is written in windows service. i want if any error is thrown then my windows service should restart. here is my full code
public partial class PartIndexer : ServiceBase
{
static string connectionString = "server=222;uid=222;password=222;database=wwww;Pooling=true;Connect Timeout=20;";
SqlDependency dep;
public PartIndexer()
{
InitializeComponent();
}
#region OnStart
protected override void OnStart(string[] args)
{
RegisterNotification();
MailNotify("STARTED");
}
#endregion
#region RegisterNotification
///
/// RegisterNotification
/// this is main routine which will monitor data change in ContentChangeLog table
///
private void RegisterNotification()
{
string tmpdata = "";
System.Data.SqlClient.SqlDependency.Stop(connectionString);
System.Data.SqlClient.SqlDependency.Start(connectionString);
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT ActivityDate FROM [bba-reman].MyLog";
dep = new SqlDependency(cmd);
dep.OnChange += new OnChangeEventHandler(OnDataChange);
SqlDataReader dr = cmd.ExecuteReader();
{
while (dr.Read())
{
if (dr[0] != DBNull.Value)
{
tmpdata = dr[0].ToString();
}
}
}
dr.Dispose();
cmd.Dispose();
}
}
finally
{
//SqlDependency.Stop(connStr);
}
}
#endregion
// this below function never used
public void ReStartService()
{
ServiceController service = new ServiceController("PartIndexer");
if ((service.Status.Equals(ServiceControllerStatus.Stopped)) || (service.Status.Equals(ServiceControllerStatus.StopPending)))
{
service.Start();
}
else
{
service.Stop();
service.WaitForStatus(ServiceControllerStatus.Stopped);
service.Start();
service.WaitForStatus(ServiceControllerStatus.Running);
}
}
#region OnDataChange
///
/// OnDataChange
/// OnDataChange will fire when after data change found in ContentChangeLog table
///
/// <param name="sender" />
/// <param name="e" />
void OnDataChange(object sender, SqlNotificationEventArgs e)
{
((SqlDependency)sender).OnChange -= OnDataChange;
if (e.Source == SqlNotificationSource.Timeout)
{
var template = new MailTemplate()
.WithBody("HI,
Part Indexer Service Exception Timeout occur " + DateTime.Now.ToLongDateString())
.WithSubject("Part Indexer Service Exception Timeout occur")
.WithSender("xxx@xxx.com")
.WithRecepient("xxx@xxx.com")
.Send();
Environment.Exit(1);
return;
}
else if (e.Source != SqlNotificationSource.Data)
{
var template = new MailTemplate()
.WithBody("HI,
Part Indexer Service Exception SqlNotificationSource.Data " + DateTime.Now.ToLongDateString())
.WithSubject("Part Indexer Service Exception SqlNotificationSource.Data")
.WithSender("xxx@xxx.com")
.WithRecepient("xxx@xxx.com")
.Send();
Environment.Exit(1);
}
StartIndex();
RegisterNotification();
}
#endregion
#region StartIndex
///
/// StartIndex
/// this routine will call web service in bba reman website which will invoke routine to re-index data
///
void StartIndex()
{
//eventLog1.WriteEntry("Web Service called start for indexing data");
PartIndexerWS.AuthHeader oAuth = new PartIndexerWS.AuthHeader();
oAuth.Username = "Admin";
oAuth.Password = "Admin";
PartIndexerWS.SearchDataIndex DataIndex = new PartIndexerWS.SearchDataIndex();
DataIndex.AuthHeaderValue = oAuth;
try
{
DataIndex.StartIndex();
//eventLog1.WriteEntry("Web Service called stop for indexing data");
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message.ToString());
//eventLog1.WriteEntry("Web Service call error "+ex.Message.ToString());
}
}
#endregion
#region MailNotify
///
/// MailNotify
/// fire mail when apps start & exit
///
/// <param name="strStatus" />
void MailNotify(string strStatus)
{
if (strStatus == "STARTED")
{
var template = new MailTemplate()
.WithBody("HI,
Part Indexer Started Date " + DateTime.Now.ToLongDateString())
.WithSubject("Part Indexer Started")
.WithSender("xxx@xxx.com")
.WithRecepient("xxx@xxx.com")
.Send();
//eventLog1.WriteEntry("mail fired ");
}
else if (strStatus == "STOPPED")
{
var template = new MailTemplate()
.WithBody("HI,
Part Indexer stopped Date " + DateTime.Now.ToLongDateString())
.WithSubject("Part Indexer Stopped")
.WithSender("xxx@xxx.com")
.WithRecepient("xxx@xxx.com")
.Send();
//eventLog1.WriteEntry("mail fired ");
}
}
#endregion
#region OnStop
protected override void OnStop()
{
System.Data.SqlClient.SqlDependency.Stop(connectionString);
MailNotify("STOPPED");
//eventLog1.WriteEntry("Part Indexer stopped Date : " + DateTime.Now.ToLongDateString());
}
#endregion
}
see this function because if error occur then i am restarting service from here by this code Environment.Exit(1);.
void OnDataChange(object sender, SqlNotificationEventArgs e)
{
((SqlDependency)sender).OnChange -= OnDataChange;
if (e.Source == SqlNotificationSource.Timeout)
{
var template = new MailTemplate()
.WithBody("HI,
Part Indexer Service Exception Timeout occur " + DateTime.Now.ToLongDateString())
.WithSubject("Part Indexer Service Exception Timeout occur")
.WithSender("xxx@xxx.com")
.WithRecepient("xxx@xxx.com")
.Send();
Environment.Exit(1);
return;
}
else if (e.Source != SqlNotificationSource.Data)
{
var template = new MailTemplate()
.WithBody("HI,
Part Indexer Service Exception SqlNotificationSource.Data " + DateTime.Now.ToLongDateString())
.WithSubject("Part Indexer Service Exception SqlNotificationSource.Data")
.WithSender("xxx@xxx.com")
.WithRecepient("xxx@xxx.com")
.Send();
Environment.Exit(1);
}
StartIndex();
RegisterNotification();
}
the problem is my service is not sending any mail when data change in specific table but if i restart my service then service is sending mail when data is changed in specific table which is monitoring by the sql dependency. need help.
tbhattacharjee
|
|
|
|
|
3/4 days?
Perhaps it'd be more appropriate to simply have a "LastModified" column and check the top 1 of that?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Long weekend possibly!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
please discuss here with example scenario like when people draw UML Sequence diagrams and when people draw UML Activity diagrams. thanks
tbhattacharjee
|
|
|
|
|
We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
Try it yourself, you may find it is not as difficult as you think!
If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I refer you to the answer I gave you here[^].
|
|
|
|
|
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
If you have a question, ask it. Don't ask for "discussions"; we cannot answer generic questions, and this is an open-ended question. Like the top post says, "be specific".
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Activity diagrams are drawn by folks that don't know how to draw sequence diagrams because activity diagrams are easier to conceptualize than sequence diagrams.
|
|
|
|
|
I'm reading this[^]
In the Introducing section it says:
If “await” sees that the awaitable has not completed, then it acts asynchronously. It tells the awaitable to run the remainder of the method when it completes, and then returns from the async method
Does this mean that is the awaitable has NOT completed, it stops there and runs it? Isn't this a block?
If it's not broken, fix it until it is
|
|
|
|
|
The code after the await statement won't execute until the awaitable is complete. Yes, this is a blocking call, KIND OF.
The difference is that the thread executing the await goes back to running other code that needs to run, like the applications message pump so UI updates are painted and button clicks and whatnot can still execute.
When the awaitable finally returns, the code after the await statement executes as normal.
|
|
|
|
|
I created an app that will be hosted in a Windows Service. I've been looking up how to install the service, and all the results seem to be to use InstallUtil.
My app will be downloaded and installed using an installer. How do I install my Windows Service with the installer?
Can someone point me to how to do this? Again, I DO NOT want to use InstallUtil.
Thanks
If it's not broken, fix it until it is
|
|
|
|
|
If you don't want to use InstallUtil, then this is your only alternative:
Service Functions[^]
In my opinion, it's much easier to use a Custom Action in the installer to call InstallUtil.
EDIT:
If you are using the Windows Installer (.msi) then you can use the Service Installer table to author the installation of services:
ServiceInstall Table[^]
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Richard Andrew x64 wrote: If you don't want to use InstallUtil,
It's not a matter of "want"... My customers are going to pay for & download this app. Their not going to want to run a DOS command line utility to install something.
Next, I don't understand the two inks you posted.. Is there not way to create a Setup.Exe with a VS Setup Project?
If it's not broken, fix it until it is
|
|
|
|
|
Kevin Marois wrote: It's not a matter of "want"...
Geez, take it easy.
I don't believe the VS setup project provides a way to install services. However, if the VS project supports custom actions, you could use a custom action to run the InstallUtil and your users would not have to run any separate utility.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Kevin Marois wrote: Their not going to want to run a DOS command line utility to install something
You're note getting it. It's the custom action in your installer that execute the commands, not your user.
Upgrade to a better installation creation application and chances are good you won't even need the InstallUtil because that functionality would be built into the installer.
|
|
|
|
|
Dave Kreskowiak wrote: Upgrade to a better installation creation application
Can you please elaborate on what this means?
Thanks
If it's not broken, fix it until it is
|
|
|
|
|
I think he means that if you want your installer to jump through hoops, you should invest time and/or money in a decent install authoring tool.
There are quite a few available on the interwebs.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Yep.
The Visual Studio Setup and Deployment project doesn't even exist any more. Get used to using a 3rd party tool to build your installers. There's a ton of tools out there.
|
|
|
|
|
Dave Kreskowiak wrote: The Visual Studio Setup and Deployment project doesn't even exist any more.
Yes it does. I'm using in in VS2013 on other applications.
With this whole thread I've been operating on the assumption that it's possible to build a Setup.exe that will install a Windows Service.
Am I wrong here?
If it's not broken, fix it until it is
|
|
|
|
|
Assuming you've added the necessary service and project installer classes to your service project, you should be able to select "Installer Class" from the properties of the service executable:
How do i create an InstallShield LE project to install a windows service?[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Kevin Marois wrote: Yes it does. I'm using in in VS2013 on other applications.
Actually, the Setup and Deployment PROJECT was removed in VS 2012 and replaced with InstallShield Limited Edition. The heading of "Setup and Deployment" project TYPES is still in the "New Project" dialog.
Kevin Marois wrote: With this whole thread I've been operating on the assumption that it's possible to build a Setup.exe that will install a Windows Service.
Sure, if you felt you needed to go through all the extra work of writing it yourself. There is no built-in template to scaffold out a Setup.exe project for you to modify.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
