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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by richardii

  1. richardii

    Problem with silent install on x86 VMs (x64 are OK)

    Hello I'm trying to do silent install on an x86 VM with the following commands: net use G: "\\cristienas\Uranus\Windows\x86\NetWorker Clients\Version 7.6 SP3\networkr" /user:STROUD\<user> <password> "G:\setup.exe" /s /v"/qn /L*v """%TEMP%\networker_install.log""" The log shows failure: MSI (s)...
  2. richardii

    vbscript for copying file runs indefinitely

    It's a bug in Windows 2000 - XP does it OK.
  3. richardii

    vbscript for copying file runs indefinitely

    I have some vbscript for copying a file - it works fine when I double-click it. However, if I try to put it under control of the Scheduled Tasks (in Windows 2000) - the task runs indefinitely (and is never successful). I've tried recoding the vbscript (as a shell call and using .CopyFile). Same...
  4. richardii

    TSQL batch separator

    It was messed up around the 'go's I removed those and placed all the syntax on one line, it ran through fine and created the job. In fact all I wanted to do was run an existing job (so it was much easier then I thought :) Thanks.
  5. richardii

    TSQL batch separator

    I'm executing it through a bat file command: ISQL -u <user> -P <password> -d <Database> -i <the script above> -o <the log file above> It appears I can log on OK, but I see the syntax errors. Unfortunately I can't use QA to execute it (it has to be done from a Virtual PC without SQL Server...
  6. richardii

    TSQL batch separator

    I'm generating some TSQL from the Enterprise Manager and being warned that I have GO set as my TSQL batch separator. I can't change it though (the option is greyed out). I tried changing it in SQL Query Analyzer (no effect). How can I change the TSQL batch separator? Or can I 'repair' my TSQL...
  7. richardii

    Find using Reg Exp

    Thanks very much - that first excellent link did the trick. I used ReadBinaryFile(cFileToSearch) to read it and RSBinaryToString(xBinary) to convert to a string. It's fast (5 seconds).
  8. richardii

    Find using Reg Exp

    The idea of searching by line is a good one - and in fact all I'm interested in is whether the string occurs (not how many times). I've done that and it works fine - the problem comes if the file is binary (I then get the message &quot;Input past end of file&quot;). Big text files are fine...
  9. richardii

    Find using Reg Exp

    That's interesting. Nearly *all* of the time is spent reading the string in.
  10. richardii

    Find using Reg Exp

    It was taking about 3-4 minutes to find 3 occurences in a 1,230 KB file, which did not compare with a UNIX grep at all well! I've not tried the Instr() approach.
  11. richardii

    Find using Reg Exp

    Thanks - I've given up on this approach. It will &quot;work&quot; as long as the file is text - but it's too slow.
  12. richardii

    Find using Reg Exp

    I'm using this code to find a string in a file. It works fine as long as the file is NOT a large binary file!! Unfortunately that's exactly what I want to look in. Any ideas what the problem might be/solution. Thanks in anticipation. Option Explicit Dim objRegExpr Dim FSO, TF, inp Dim...
  13. richardii

    Converting table contents into a string

    This is just an example, the following code moves through the table called tbl and uses the field TABLE_NAME to step through each table's name (linking them to the database). You could adapt this as the key bit is the loop. Private Sub Command0_Click() Dim db As DAO.Database Dim rsTable As...
  14. richardii

    Easy question...just brain dead! Delete query...

    Remove duplicates from a table TEST. Step1: SELECT DISTINCT Tests.* INTO Tests_1 FROM Tests; Step2: DELETE Tests.* FROM Tests; Step3: INSERT INTO Tests SELECT Tests_1.* FROM Tests_1; Then get rid of the temp table tests_1: DoCmd.DeleteObject acTable, &quot;tests_1&quot;
  15. richardii

    ZIP a file

    I found WinZip's command line extension quite useful (then you're not limited to 8 char names): Dim myObjFSO Set myObjFSO = CreateObject(&quot;scripting.filesystemobject&quot;) CheckFolder &quot;C:\source&quot; Sub CheckFolder(strPath) Dim objFolder Dim objFile Dim objSubdirs...
See more

Part and Inventory Search

Back
Top