Search results for query: *

If only one user run this SP, it fill up job number list and correct. If second user run different SP on different PC and different screen same application same time (takes at least 30 minutes and use same table), the first user doesn't get Job Numbers after run this SP. I altered this SP with...

I try to get rows(job number list)returned from the procedure. MessageBox.Show(dtJobs.Rows.Count) is show on screen "0" Is there way to get job number list while the other SP runnint?

This is SP... INRV2_getallsavedJobs-- inr_mailinglist and inr_jobschecule are deleting or writing by other SP at the same time. CREATE PROC [dbo].[INRv2_GetAllSavedJobs] AS SELECT plm.jobcode [Job No],si.seminartitle [Seminar Title] FROM (SELECT DISTINCT pm.jobNo jobcode FROM...

I excuted SP but return value zero. I think the table using in SP is deleting and writing by parameter by another SP. How to get return value while other SP is deleting and writing same sql table by job number? Private Function getSavedJobs() Dim cmdSavedJobs As New SqlCommand...

Thank you gmmastros. I spent 2 days to resolve this problem. Thank you very much.

If [History count} is zero, [Final Count} should have [All count]. But [Final Count] value returns as zero. How to move [History count] into [Final Count]? This is part of SELECT within Store Procedure. ISNULL(cast (([ALL count]-[History count]) as integer(18)),0) AS [Final Count]

Thank you Waddlellg. It works after change with your IF logic. on FORM1; FORM2.Showdialog.Dialogresult.OK - this gives error I changed; IF FORM2.Showdialog = Windows.Forms.DialogResult.OK then sub1 Else FORM2.Dispose End If

Thank you. You saved my life. I spent 5 days to solve this problem. I passed empey element on XML. Thank you very much.

I am a beginner and need help. I am getting error message System.Data.SqlClient.SqlException: Error converting data type nvarchar to numeric. at System.Data.SqlClient.SqlCommand.ExecuteReader (Commandbehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) I tried...

FORM1 need to get result from FORM2 and keep run next step in FORM1. So I used .showdialog() instead of .show(). The problem is I get result from FORM2 but looks like FORM2 still running. FORM2 looks like hide. How to end FORM2 after .showdialog()? I am a beginner. I read article about...

Form1 need to get result from Form2 and keep run next step in Form1. So I used .showdialog() instead of .show(). The problem is I get result from Form2 but looks like Form2 didn't closed. How to close Form2 after .showdialog() from FORM1; If dtJobDetailsMileRadius.Rows.Count > 0 Then...

I am sorry there is typing error. ClassKey is Varchar(20) I also tried Classkey Nvarchar(20) and got same Error 213 INR_Attendee.ClassKey = Nvarchar(20) DECLARE @ClassTab TABLE(ClassKey NVARCHAR(20)) Declare @LicenseID_ProfCode table ( LicenseID numeric(11)...

Error 213: Insert Error: Column name or number of supplies values does not match table definition. Insert Error: Column name or number of supplies values does not match table definition. I am getting Error 213 after add ClassKey Varcgar(20)in table @LicenseID_ProfCode. Please help me...

I want to run DTS manually. I clicked Schedule Package and changed end date to TODAYs date on Edit Recurring JOb Schedule but It donsn't let me change it. How to disable auto daily run.

I am attacing full code. Please help me. I want to know where is called..... using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using...

I am new c# and Web App and try to understand it. I would like to know how the following line work and also attached full public void too. I cannot figure out how where GetProgramM get executed. I use Visual Studio 2008 & c#. DataTable _datatable = _dataaccess.GetProgramM(_iPMID); public...

Thank you. I can use strSQL to update table. I also want to reset current value on the form too. I am using similar logic to "Select All" and "De Select All". Also Form check box name is NCselect and table check box field name is NCselect. I am attaching De Select logic. This also take a...

I have continues forms and show all 5,000 records. I want to update the table where check box select = -1 check box deSelectd = 0

I try to save check box value(selected or not selected) in the table. The table have 5,000 records only. This exec takes very long time.

I am try to update seleted check box but it takes so long to save into table. There are only 5,000 records in table. Is there way to make this faster? Here is code; Sub SaveCurrentCheckBox() Static blnSelect As Boolean Set db = CurrentDb() Set myrs = Me.RecordsetClone...