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 Wanet Telecoms Ltd 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: *

  • Users: dvader0571
  • Content: Threads
  • Order by date
  1. dvader0571

    Simple PL/SQL question

    Is the CASE statement supported or not in 9i? I keep getting a "Missing right parenthesis" error when trying to run this. I thought CASE was ANSI SQL and thus supported.... SELECT SRVCHGKEY, SRVCHG, ACCTTYPE, BLTYPEKEY, BLITEMGRP, EFFDATE, EXPDATE, PRNORDER, CALCORDER, PRNTTEXT, REFTEXT...
  2. dvader0571

    Trouble w/Stored Proc

    This is bizarre to me however, hopefully someone can explain what is happening here. When I check the execution plan of the following query: SELECT A.TRANDTTM FROM [imsv7].ACCTTRAN A, [imsv7].CUSTBL C WHERE A.ACCTKEY = @dwAcctKey AND A.BLKEY = C.BLKEY AND A.TRANDTTM >= @tsDueDate AND...
  3. dvader0571

    32 bit unsigned int not large enough, alternative data type?

    I have a calculation that takes in the number of bytes for a given file. This number can be in excess of 4.2 billion (4.2GB) bytes, which apparently is the largest a 32 bit unsigned int (or ulong/DWORD) can handle. I can put these numbers into Excel and it calculates them fine. Is there a data...
  4. dvader0571

    Using SQL Server 2000 and OLE DB

    I am designing an application in VC++ using the Native SQLOLEDB.1 driver. I have no problems executing and accessing the results from a regular stored procedure in our SQL Server 2000 repository. However, as soon as I try and connect to a Stored Procedure that returns more than 1 result set...
  5. dvader0571

    Using SQL Server 2000 and OLEDB

    I am designing an application in VC++ using the Native SQLOLEDB.1 driver. I have no problems executing and accessing the results from a regular stored procedure in our SQL Server 2000 repository. However, as soon as I try and connect to a Stored Procedure that returns more than 1 result set...
  6. dvader0571

    C++ compile error C3358: CSoapHandler symbol not found

    ATL Server, Web Service solution Visual Studio .NET I have the code exactly like the sample OnlineAddressBook from the MSDN library yet I get the error whereas that app does not. Such simple things can stop a programmer for hours. Here is the code I am using. Note that the Web Service this code...

Part and Inventory Search

Back
Top