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 dencom 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: sandtek
  • Content: Threads
  • Order by date
  1. sandtek

    VB6 - getting the status of shell

    Hi All, Im a writing a simple aps and here I want to execute a command and get the status of the command I spawned. Say, I want to delete a file Shell "del somefile.txt", vbNormalFocus msgbox "Status is OK" The problem here is the Msgbox will appear/executed in parallel with the command I...
  2. sandtek

    get actual row count via dba views

    Hi All, We are working on a DWH environment and every time we need to get the actual number of rows from a table. But the problem is the table has large number of rows and doing a select count (*) from huge_table is taking tooooo long. Is there any way to get the actual or atleast closed to...
  3. sandtek

    Writing an IE form filler

    Hi all, I would like to know how to write an automated form filler for Internet Explorer -- one that automatically sends text to a textbox. I guess I need to work with the SendMessage function? Please help as I am wasting most of my time working with filling out forms and I guess need to...
  4. sandtek

    tablespace HWM resize

    Hi tektipsters! I need a query that would get the minimum possible high water mark for a tablespace for resize. Here's one query I got from the net: select 'alter database datafile ''' || file_name || ''' resize ' || ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd from...

Part and Inventory Search

Back
Top