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 Mike Lewis 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. schafjoe

    UpdateText and Table Variable

    I have made the following changes to my code. DECLARE @TextLine1 VarChar(20), @IntCounter Int, @Pointer VarBinary(16) CREATE TABLE #retTable TABLE ( SelectDetailSubClause Text ) INSERT INTO #retTable (SelectDetailSubClause) VALUES (NULL) SET @TextLine1 = 'Line to be inserted.' SET...
  2. schafjoe

    UpdateText and Table Variable

    Everybody, Using the code below, I get the followin error: Server: Msg 170, Level 15, State 1, Line 16 Line 16: Incorrect syntax near '@retTable'. DECLARE @TextLine1 VarChar(20), @IntCounter Int, @Pointer VarBinary(16) DECLARE @retTable TABLE ( SelectDetailSubClause Text ) INSERT INTO...
  3. schafjoe

    Document Location

    Everybody, When I run the following page, I get &quot;http://localserver/temp.htm&quot; in the alert modal dialog box. What I want to get is &quot;http://localserver/Test.asp?&Model=1&quot;. What am I doing wrong. <!-- temp.htm --> <HTML> <HEAD> <SCRIPT language=&quot;JavaScript&quot...
  4. schafjoe

    Best Practices for Column Names

    Thanks Everybody for you suggestions. The fields are for a summarized table that is broken out by the part number, year, month, week and quantity that was shipped. For Example, Part Number Year Month Week Quantity Part A 2003 9 40 100 Part A 2003 10 40 77 Part B 2003...
  5. schafjoe

    Best Practices for Column Names

    Everybody, Is there a Best Practices for Year, Month and Week Column Names? What I mean is that is it good to have a Column named Year or is their something better.
  6. schafjoe

    Return Value from SQL Server

    Everybody, How do I return a value from SQL Server? For example, = SQLSETPROP(gnConnHandle, 'asynchronous', .F.) = SQLEXEC(gnConnHandle, 'SELECT @@VERSION') Thanks
  7. schafjoe

    Dynamic SQL Statement

    Found another solution. DECLARE @SQLString VarChar(8000) SELECT @SQLString = ISNULL(@SQLString + ',', '') + CHAR(13) + 'SUM(CASE ' + 'WHEN Data.Year = ' + CAST(s.Year as VarChar(4)) + ' AND Data.Month = ' + CAST(s.Month as VarChar(2)) + CASE s.Week WHEN 0 THEN '' ELSE ' AND Data.Week = ' +...
  8. schafjoe

    Dynamic SQL Statement

    Everybody, I have the following Code that work fine. What I want to do is when s.Week = 0, then do not place the week statement. DECLARE @SQLString VarChar(8000) SELECT @SQLString = ISNULL(@SQLString + ',', '') + CHAR(13) + 'SUM(CASE ' + 'WHEN Data.Year = ' + CAST(s.Year as VarChar(4)) + '...
  9. schafjoe

    APROCINFO( ) Function

    Everybody, Can I use the APROCINFO( ) Function in an Executable? When I have the commands in the Executable I get a &quot;Feature is not available.&quot; error message.
  10. schafjoe

    Rebuilding a Project

    Everybody, I am trying to rebuild a project and I get the following error: Property value is out of bounds (Error 1469). This error occurs when the message in the status bar says “Build Project: Visual Class Library Reports”. This class currently has 1211 class defined in it. If I compile the...
  11. schafjoe

    Select Statement

    Everybody, I was wondering this is possible using a Select statement. I am using VFP 7.0. I want to add an Order column to the following Select statement. What I want in the Order column is the ranking of the record. SELECT Pareto.Commodity, Pareto.Test_Code, ; SUM(Pareto.TtlQty) AS...
  12. schafjoe

    Export Data to Excel

    Everybody, I need to export a Memo field that contains more than 255 characters to a Cell in Excel. Has anybody had any luck in getting this to work?
  13. schafjoe

    Clear Class Question

    Everybody, I have the following sample code. Once the code is run, if I go into Windows Explorer and try to cut the “Template.Vcx” file and paste it to another directory, I get the following error: “Cannot Move Template: It is being used by another person or program.” Can somebody tell me why it...
  14. schafjoe

    Get Session.Timeout

    Everybody, Is there a way to get the &quot;Session.Timeout&quot; value so I can use it in a JavaScript function. In VBScript, I would call <% Response.write Session.Timeout %>.
  15. schafjoe

    Insert Problem

    Thanks Everybody, I did not have the correct permissions for this stored procedure.
  16. schafjoe

    Insert Problem

    This Stored Procedure works when I run it through the SQL Query Analyzer but does not when I use it from an ASP Page. It will put the data in the dbo.Src table but I cannot get it to put it into the dbo.LockSrc Table. Can somebody please tell me why. ALTER Procedure SrcData @Users Int = 0...
  17. schafjoe

    Web Assistant Wizard

    Everybody, Can you tell me why the Web Assistant Wizard creates a stored procedure in my Database. The data that I am using comes from a stored procedure. Also, Does anybody have a description and values of the columns in the msdb.dbo.mswebtasks table.
  18. schafjoe

    Select for the Max Records

    Everybody, I have the following table. All of the fields are of the Interger type. The records that I need is the maximum value of the Score Divided by the MaxScr for each Period, Region, Comm and Elem grouping. Period Region Comm Elem MaxScr Score 9 2 6 2 23 13 9 2 6 2 23 14 9 2 6 2...
  19. schafjoe

    Copy Text to Clipboard in ASP

    Everybody, I need a way to copy a some text to the clipboard. I am using VBscript for an ASP page. This code will be run at the server and not at the client. I have tried to use the following Set objClipboard = CreateObject(&quot;Clipboard.Application&quot;) objClipboard.Clear...
  20. schafjoe

    Join Three Tables

    dbo.GeirsAdd ( Primekey int IDENTITY (1, 1) NOT NULL , ReportNumber varchar (25) NULL , Platform int NOT NULL , Contact varchar (30) NULL , Sqe_Se varchar (30) NULL ) dbo.GeirsImpact ( Primekey int IDENTITY (1, 1) NOT NULL , ReportNumber int NOT NULL , ImpactDate datetime NULL ...

Part and Inventory Search

Back
Top