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!

  • Congratulations strongm 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. bangalibhai

    Collation Question

    Hi, I have the below in one of my stored procedures. Declare @tmp table(OptionCode varchar(2) COLLATE SQL_Latin1_General_CP1_CS_AS PRIMARY KEY CLUSTERED) Record #1: "TP" Record #2: "Tp" 1st record is insrted in to the above table and as soon as the second record is added "Violation of...
  2. bangalibhai

    Column to Row

    Alex, can you please point me to the right direction. I did a search but it did not return anything in 2000 version.
  3. bangalibhai

    Column to Row

    Actually I am doing this in SQL Server 2000.
  4. bangalibhai

    Column to Row

    Is it Possible to do this. I have the below displayed column wise. 1 2 3 4 5 6 7 8 I want it displayed row wise 1 2 3 4 5 6 7 8 Thanks in advance.
  5. bangalibhai

    Traverse rows to columns

    Thanks Mija, actually there are 50 to 80 items. I actually thought of doing it this way. But I was looking for a more efficient way so that I do not have to list all the items.
  6. bangalibhai

    Restricting the number of records returned(COUNT)

    You can restrict the number of rows returned by using the TOP keyword. But, I am not sure if that's what you are wanting.
  7. bangalibhai

    Traverse rows to columns

    Hi, I am trying to display the rows as columns. I have seen a similar posting but can't seem to find it. Initially I have the below table..... CUSTOMER CUST # ITEMS QTY ==================================== John Smith 1234 Item1 2 John Smith 1234 Item2 1 John Smith...
  8. bangalibhai

    How do you set focus to an external window

    Thanks, I found a FAQ which shows exactly what I wanted to do.
  9. bangalibhai

    How do you set focus to an external window

    I am running a VB program. How can I control an external window from VB. For example, I fire off IE and it strats out with a window for downloading a file. Is there any way to control that window. Thanks.
  10. bangalibhai

    How do I fill up a Webbrowser with a string instead of file?

    are you using the wbbrowser control
  11. bangalibhai

    Webbrowser Control

    Hi all, I am trying to automate file download using the webbrowser control from VB6. I can detect the begin of the file download process from the event "FileDownload". But beyond that I cannot control anything from VB. 1) How do I finish the download by clicking the save button? 2)...
  12. bangalibhai

    Running an external .exe from VB

    Thanks. That's what I was looking for. Is there a reference book for all VB functions?
  13. bangalibhai

    Running an external .exe from VB

    Hi, Is there a way to run an external application (.exe or .app) from VB6? Thanks.
  14. bangalibhai

    Read the value of a javascript variable from server side VBScript

    Hi, I need some input on the following. It is possible to read in the value of a server side variable from javascript as stated below: <HTML> <SCRIPT language=&quot;javascript&quot;> <% Dim anynum anynum = 100 %> alert (&quot;<%=anynum%>&quot;); </script> <% Response.Write anynum %>...
  15. bangalibhai

    Hi, Can you do database calls in

    Thanks, I will check it out.
  16. bangalibhai

    database calls in JavaScript or JScript

    This is not what I am looking for. Thanks.
  17. bangalibhai

    database calls in JavaScript or JScript

    Can you please point me to some exapmles or FAQs. thanks.
  18. bangalibhai

    database calls in JavaScript or JScript

    Hi, Can you do database calls in JavaScript or JScript? If so please point me to some examples on how to perform that. thanks, nihad

Part and Inventory Search

Back
Top