Search results for query: *

Good Morning I have been trying to find a way to calculate a future date based upon an already existing date being passed into a routine My question is this I have a date, for example 05/25/16 and I need to add 48 months plus 10 days to create this future date basically for 10 business days...

I have the following windows application that contains several public classes. One class if my login screen where a user enters there ID plus password. In this class I have a public function called get_password which verifies the password just entered. this is an example of the call within my...

I have a console application that I am calling from a vfp program the vfp rpogram is apssing two variables to the console applicaiotn the following statement is being used in console appl. to accept the variables being passed from the vfp applicaiton wpassword =...

I am trying to figure out how to select data in a combobox whose dropdowastyle is dropdownlist. when my form first loads, it populates the combox, named cmbox1 with the following statements; lsql = "Select currency from [sec_mast].[dbo].[sec_fxrt] group by currency " ' ' populate...

I have the following code; Dim conn As New SqlConnection() Dim cmd As New SqlCommand Dim myreader As SqlDataReader Dim adapter As New SqlDataAdapter lsql = "Select effect_dat, fxrate, currency from [sec_mast].[dbo].[sec_fxrt] where currency = 'EUR' order by effect_dat desc"...

I know that I use executenonquery for inserting/updating fields/deleting rows from a table My question is this.. I have the following sql statement lsql_tmp = "select * into temp_item_" + wcode + " _" + strdate1 + " from [merg].[dbo].[item] where itm_pri_cd = '" + wcode + "' and bolevel > 0 "...

I am using the following statements in VFP. DECLARE INTEGER ShellExecute IN shell32.DLL ; INTEGER hndWin, ; STRING cAction, ; STRING cFileName, ; STRING cParams, ; STRING cDir, ; INTEGER nShowWin ** cAction = "open" cFileName = "c:\temp\ping_servers.exe" cParams...

I'm not sure if this is the correct forum for this if not, please point me in the right direction I am creating small vb.net application that will ping a sql server I am using calling the vb.net exe from a vfp program using shellexecute the structure of the shellexecute is as follows; DECLARE...

I hope that this is the correct forum for this. I already have a VFP function that pings a sql server running within a VFP executable I was asked to see if I could create a VB.Net executable that does the same thing.but have that executable called from the VFP application. I need to know if I...

I am new to VB.NET 2012. I have been using VFP9 for a long time. In VFP(, i can create a global variable that will be available thought the entire application I am in the process of converting a login screen into VB.NEt from VFP9. I have the following code set up in my form: Public Class Login...

I am using sql server 2005 and was wondering if it is possible to create an excel spreadsheet from within a stored procedure.. I have been looking at books, thru google and can't find anything...i might be looking in the wrong place(s)... if it is possible to passs the results from a sql stmt...

I am using sql server 5 and reporting services I am trying to add one space into a string that comes from a filter in report services... My filter is the following; the user can select multiple days of the week, say MON and Fri...the filter displays the fields as MON,FRI... the field in the...

i am using sql serve2005 and i'm run the code below in reporting services.. I have the following field in a table.. field is called DAY.. Day can contain the following.. record1 = 'MON,FRI' RECORD2 = 'TUE,THU' RECORD3 = 'MON,TUE,WED,THU,FRI' My report has a filter labeled DAYS that coatins the...

i am creating multiple reports that require a start date and end dates... my setup is that for the star date/end dates in the SSRS is prompt is Start Date; NULL values s clicked on..when the report runs, the users has the choice of entering a date or accepting the null values option.. my...

I'm having a problem using the multi-value check box in the report layout parameters section. I have the following setup for the user to select multi-semesters for a report.. properties: Nmae: semester, data type = string, Prompt = semester;multi-value box is checked;Available values from query...

To all, I am new to Report Services 2005. I am part of a tema converting VFP-based application to SQL Server 2005. In VFP, when i run reports, i check the function _tally() and if tally() = 0, I display a messagebox displaying "NO Data Found For search Criteria".. I want to do the same thing...