Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jnavarro

    Crystal Report

    the dataset is used to display information on a user form. I am able to preview the information and everything looks ok. Can you provide the way you should declare a crystal report with a ms access dataset? thanks
  2. jnavarro

    Crystal Report

    Both the setdatasource and report source rptEmployee.SetDataSoure = dsEmployee1 .crvReport.ReportSource = rptEmployee
  3. jnavarro

    Crystal Report

    Does anyone know how to create a crystal report using an existing dataset? The dataset is currently been filled with an access db. I am trying to use the dataset to fill the information that I want to display. Everytime I call the routine I received an error "object reference not set to an...
  4. jnavarro

    FTP Error

    I am using the URL for the destination of the files. I am able to run the FTP manually but when I scheduled the task it fails. In order for me to check if the security had something to do with this, I created a bat file on the server and schedule the task to run the files located on the FTP...
  5. jnavarro

    FTP Error

    How do you find out the credentials on the ftp server and set it up on the server?
  6. jnavarro

    FTP Error

    I am trying to download files from a ftp server using DTS. I was able to add the files and download the information manually, however when I schedule the dts to run at a schedule time I get an error: DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 0 (0) Error...
  7. jnavarro

    Date diff

    You will have to use a case statement in order to determine if the date is a weekend. i.e. CASE WHEN Weekday(date1) = 1 THEN 'do something CASE WHEN Weekday(date1) = 7 THEN 'do something CASE ELSE 'do something.
  8. jnavarro

    DTS and VB Scrpits

    That is what I am currently doing, the problem is that I continue to add files. I have about 100 files and I was trying to read the informaiton from a table so I wouldn't have to add more lines of code to copy and rename files.
  9. jnavarro

    DTS and VB Scrpits

    Does anyone know how I can read table values using VB Scripts and DTS? I am trying to read information store in an sql table, the information in this table is the file name, location and destination. What I need to do is check if files are avail on a source path if so, the file needs to be move...
  10. jnavarro

    Dymanic Query

    I have also try this but I get 0 records affected UPDATE tblAIAttachments SET Div= @Div, Account = @Account WHERE Location IN(''+ @Location + '') AND Div= @Org_Div AND Account= @Org_Account @Location variable is set ='\\GLAPPS02OHCSAPPS\AI\FL8192A2.PDF'...
  11. jnavarro

    Dymanic Query

    I did that but I am receiving an error Error converting data type varchar to bigint. I have provide my declare also. DECLARE @Div char(2),@Account bigint, @CorrespondType char(3), @MediaDate datetime, @Org_Div char(2), @Org_Account bigint, @Location varchar(500) DECLARE @SQL varchar(700) Any...
  12. jnavarro

    Dymanic Query

    Can any one tell what is wrong with this query. I am trying to update information based on the parameters,I get an message 0 rows effected. However, if I do it manually it works. -SET @SQL=' UPDATE tblAIAttachments SET Div=' + @Div + 'SET Account =' + @Account + 'WHERE Div=' + @Org_Div + 'AND...
  13. jnavarro

    User Defined Function

    Yes, I ran the query and it return the information that I was looking for. I try create a sp with the same information and it work, however when I try create a function is give me errors. I think it has something to do with how I declare the variables. When I remove the variables it works.
  14. jnavarro

    User Defined Function

    CREATE FUNCTION dbo.fn_MonthlyUpdatesCalculation (@StartDate datetime, @EndDate datetime) RETURNS TABLE AS BEGIN DECLARE @MinAudits int, @WorkDays int SET @MinAudits = 40 SET @WorkDays = DATEDIFF("d", @StartDate, @EndDate) / 7 * 5 RETURN(SELECT dbo.fn_FiscalMonthDate (@StartDate, @EndDate)...
  15. jnavarro

    User Defined Function

    What I am returning is a table based on the sql statement. I have created user defined function similiar to this one however, the difference is that I did not declare or set any values. Any idea on what is causing this?
  16. jnavarro

    xp_cmdshell

    I had the same problem. If I am correct it has something to do with the owner of the file that limit what can be done using xp_cmdshell. I still have not figure this out
  17. jnavarro

    User Defined Function

    Can someone tell me what is wrong with this function. I am receiving an error near begin on line 200. I have display part of my code. CREATE FUNCTION dbo.fn_MonthlyUpdatesCalculation (@StartDate datetime, @EndDate datetime) RETURNS TABLE AS BEGIN DECLARE @MinAudits int, @WorkDays int SET...
  18. jnavarro

    Delete from Nested Select

    Thanks it worked
  19. jnavarro

    Delete from Nested Select

    Can anyone help me. I cannot get this sql statment to excute. What I am trying to do is select record from record set and delete those records in the table DELETE tblAI FROM tblAI WHERE(SELECT Div, Account, CorrespondType, COUNT (Account) AS Inquiries, MAX(MediaDate) AS MediaDate FROM...
  20. jnavarro

    ADO and Stored Procedure

    Thanks I was able to figure it out.

Part and Inventory Search

Back
Top