|
Hi
iam having a problem in coverting ms acess query to sql query,plz help me if u know the answer it is urgent.
|
|
|
|
|
Micrsosoft Access uses SQL, so your query is already SQL.
Is it perhaps Micrososft SQL Server that you want to convert the query for?
It's a bit hard to help you with converting the query without seeing it.
---
b { font-weight: normal; }
|
|
|
|
|
thanks for your reply.
this is the ms acess query(while converting to sql server it creates problem)
SELECT tblEmployee.Emp_Id, tblEmployee.Emp_FName, tblEmployee.Emp_LName, tblClockDetails.Clk_InDate, tblClockDetails.Clk_InTime, tblClockDetails.Clk_OutDate, tblClockDetails.Clk_OutTime, tblProcessedData.pHrsWork, tblProcessedData.pHrsOT, tblProcessedData.pNormOT, tblProcessedData.pOffOT, tblProcessedData.pHolOT, tblProcessedData.pEarlyOut, tblProcessedData.pLateIn, tblProcessedData.pLeaveType, tblDepartment.Dept_Id, tblDepartment.Dept_Name, tblSection.Sec_Id, tblSection.Sec_Name, (CDate([tblClockDetails.Clk_InDate] & " " & [tblClockDetails.Clk_InTime])) AS ClockIn, CDate([tblClockDetails.Clk_OutDate] & " " & [tblClockDetails.Clk_OutTime]) AS ClockOut, DateDiff("n",ClockIn,ClockOut)\60 & ":" & DateDiff("n",ClockIn,ClockOut) Mod 60 AS Totalhrs, Format(Totalhrs,"Short Time") AS TotHrs
FROM ((((tblEmployee INNER JOIN tblEmpWork ON tblEmployee.Emp_Id=tblEmpWork.Emp_Id) INNER JOIN tblDepartment ON tblEmpWork.Emp_DeptId=tblDepartment.Dept_Id) INNER JOIN tblSection ON tblEmpWork.Emp_SecId=tblSection.Sec_Id) INNER JOIN tblProcessedData ON tblEmployee.Emp_Id=tblProcessedData.pEmpId) INNER JOIN tblClockDetails ON tblEmployee.Emp_Id=tblClockDetails.Clk_EmpId
WHERE tblClockDetails.Clk_OutTime <> "" and tblClockDetails.Clk_InTime <> "" and (((tblClockDetails.Clk_InDate)>=(SELECT FromDate FROM tblDateRange) And (tblClockDetails.Clk_InDate)<=(SELECT ToDate FROM tblDateRange)) AND ((tblEmpWork.Emp_Report)='Y')) AND tblClockDetails.Clk_InDate = tblProcessedData.pDate;
the problem arises for
(CDate([tblClockDetails.Clk_InDate]-CDate isnot a recognised function name and then how to cnvert Mod 60 in to sql server.
|
|
|
|
|
leelaraj wrote: CDate isnot a recognised function name
Use: cast(x as datetime)
leelaraj wrote: how to cnvert Mod 60 in to sql server
Use: % 60
---
b { font-weight: normal; }
|
|
|
|
|
Thank you very much...its working fine.
|
|
|
|
|
Please help me solve this problem:
I wanna run an application with parameters, when i use these commands, the program doesn't work.
<br />
<br />
System.Diagnostics.Process p = new System.Diagnostics.Process();<br />
p.StartInfo.Filename = "gSpan.exe 10 set2.gsp out2_1";<br />
p.Start();<br />
<br />
"gSpan.exe" is a program coded by VB6.0
"10 set2.gsp out2_1" are 3 parameters that gSpan.exe needs.
Thanks much 
-- modified at 23:17 Tuesday 20th June, 2006
|
|
|
|
|
Use the Arguments property of the StartInfo, or put the filename and arguments in the call to the Start method.
---
b { font-weight: normal; }
-- modified at 0:43 Wednesday 21st June, 2006
|
|
|
|
|
hi there,
Im a student from singapore...i happened to find this website and found the articles to be very interesting and informative.However im now assigned a C# windows application proj and i have some questions on it as i have no programming background.Would anyone be able to help me?maybe u can send me some resources or similar source code regarding : using VS 2003 or 2005 to create a windows application whereby i am access to modify,add,delete,sort and filter a database in Excel format... thanks in advance
|
|
|
|
|
Microsoft is a good source of information of "how to" develop Microsoft Windows applications that automate Microsoft products using Microsoft development tools. http://support.microsoft.com/?kbid=306023[^]
"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum
led mike
|
|
|
|
|
hi thanks for the help..but i think u have misunderstood me.. the link u gave was for transferring data from the windows application to excel format but it is not what i want.. i need something to do with SQL to link my EXCEL DATABASE TO the windows application.. any guidance is deeply appreciated
|
|
|
|
|
skyeddie wrote: my EXCEL DATABASE
If you are referring to "Microsoft Excel" then the link I provided gives you exactly what you asked for. If it is NOT Microsoft Excel then I don't know what it is and you need to provide an URL to the Database products web site.
|
|
|
|
|
hi thanks for the help..but i think u have misunderstood me.. the link u gave was for transferring data from the windows application to excel format but it is not what i want.. i need something to do with SQL to link my EXCEL DATABASE TO the windows application.. any guidance is deeply appreciated
|
|
|
|
|
you can follow following:
1.use the wizard tool.microsoft VS.net 2003 SDK can automatic create code.
2.use the MSDN.MSDN is a strong tool,you can search everything you don't know.
3.just purchase book to read!
KSCsoft
|
|
|
|
|
Hello i have a control that inherits the list view i have tried to override the OnPaint and OnPaintBackground events but the code never seems to reach either function why would my overriden functions not be called when the control paints itself?
|
|
|
|
|
Did you set ControlStyles.UserPaint?
"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum
led mike
|
|
|
|
|
This is the error I get when I try to update.
******************************************************************************
The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
******************************************************************************
Sample code that causes this error.
private void button1_Click(object sender, EventArgs e)
{
this.Validate();
this.tb.EndEdit();
this.tb.Update(this.DataSet.tb);
}
Form was created by using the drag and drop abilities of the data source. simple form, only 4 items in the table.
|
|
|
|
|
Has anyone ever seen this? Or am I the winner of finding new ways to break code for the day? :->
|
|
|
|
|
Hello,
Can you please tell me how can I format a richTextBox using bbcode!
How can I search in the whole richTextBox content and put every
occurance of text between [ b ] & [ /b ] in bold.
Bla Bla Bla Bla Bla Bla [ b ]IN BOLD1[ /b ] Bla Bla Bla Bla Bla Bla [ b
]IN BOLD2[ /b ] Bla [ i ]ITALIC[ /i ]
Your help would be greatly appreciated.
|
|
|
|
|
Well, if I understand correctly what you're trying to do should be as easy as parsing the text in the richTextBox control and looking for the <b> and <i> tags. The easiest (not the most efficient) way to do this is to do a two-pass parse of the text. First for the BOLD tags and second for the ITALIC text.
Whenever you run into an open BOLD tag, increment boldCount variable and store the position. Then remove the tag from the text. Whenever you run into a close BOLD tag, decrement boldCount, and remove the colsing tag from the text. When boldCount = 0, select the text starting at the recorded position and then set it's bold property to TRUE. Keep going until the end of the text.
Repeat for the ITALIC tags.
Here is an example that does bold tags. Modifying this code to do italic text is trivial so it wasn't included here.. Hope this helps and don't forget to visit digitalGetto
private void ParseBoldText(RichTextBox tb)
{
int boldCount = 0;
int lastBoldStartPosition = 0;
int currentPosition = 0;
while (currentPosition < tb.Text.Length - 3)
{
if (tb.Text.Substring(currentPosition, 3) == "<b>")
{
if(boldCount == 0)
lastBoldStartPosition = currentPosition;
boldCount++;
}
if (tb.Text.Substring(currentPosition, 4) == "</b>")
{
boldCount--;
if (boldCount == 0)
{
tb.Select(lastBoldStartPosition + 3, currentPosition - lastBoldStartPosition - 3);
tb.SelectionFont = new Font(tb.SelectionFont.FontFamily, tb.SelectionFont.Size, tb.SelectionFont.Style | FontStyle.Bold);
}
}
currentPosition += 1;
}
tb.Rtf = tb.Rtf.Replace("<b>", "");
tb.Rtf = tb.Rtf.Replace("</b>", "");
}
----
www.digitalGetto.com
-- modified at 18:07 Tuesday 20th June, 2006
|
|
|
|
|
Thanks but this is not working:
tb.Rtf = tb.Rtf.Replace("[b]", "");<br />
tb.Rtf = tb.Rtf.Replace("[/b]", "");
I still have all the tags shown.
-- modified at 19:28 Tuesday 20th June, 2006
|
|
|
|
|
Also you said: the easiest (not the most efficient)
Can you give me an idea about the most efficient way?
|
|
|
|
|
Well, when I said the method was not the most efficient I meant that for large texts it will most likely be rather slow. Depending on your needs you may or may not want to put in the extra effort to look for/implement more efficient algorithms.
The performance hit of the method shown is due to the fact that it reads each character in the text. That is time consuming. A first optimization is to combine looking for BOLD tags with looking for ITALIC tags. That is, to use the same loop to do both. That way, you cut the time approximately in half. Another option you may consider is using unsafe code (pointers) to loop through the text. Yet another possibility is to use regular expressions to perform the search and replace.
As far as the other problem goes (the code not replacing the tags), that is rather strange. I've tested the code before posting it here and it worked. Can you give me more details as to how it fails?!
----
www.digitalGetto.com
|
|
|
|
|
Hi...I'm just a newby in C# programming. really need help bout an application i'm doing. I would like to change the file extensions of certain files regarding data encryption. But what i also want to do is, how will I associate my customized files with a special icon that I would put into my project in visual studio 2005? Anybody pls. help....
kirkangel
|
|
|
|
|
You typically do this with a setup project. In Visual Studio, you can add a Setup Project to your solution. Inside the setup project, you can go into the File Association editor and setup a custom association between a file extension and your app. IIRC, you can set an icon for the association as well.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Goof around music jam with my brothers (with video)
The apostle Paul, modernly speaking: Epistles of Paul
Judah Himango
|
|
|
|
|
Tnx a lot... you've been very helpfull...! God bless!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
