Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250

    Unanswered: Creating DOS command, I can't fill a memo field beyond 339 chars!

    The following code:
    ' cmd for delete from server if exist in DVDimg (ie.)

    'if exist "d:\helps\cd_tulips4\ppt\00002445 Figures 1-3.ppt". (del /f "N:\tulips4\00002445\00002445 _
    Figures 1-3.ppt".) ELSE echo "N:\tulips4\00002445\00002445 Figures 1-3.ppt". didn't copy.

    ' DVDimg = "d:\helps\DVDimg\"

    cmdString = "if exist " & dQ & DVDimg & rstDups(4) & "\" & rstDups(5) & "_" & _
    Format(rstDups(7), "hhmm") & "_" & rstDups(1) & dQ
    cmd2String = ". (del /f " & dQ & rstDups(0) & "\" & rstDups(1) & _
    dQ & ".) else echo " & dQ & rstDups(0) & "\" & rstDups(1) & dQ & ". did NOT copy. "
    rst2Batch.AddNew
    rst2Batch!dosCommand = cmdString & cmd2String
    rst2Batch.Update


    YIELDS:
    if exist "\\Aa830787eb\d$\helps\DVDimg\ppt\369152_1000_ April 25, 2002 Meeting - RC empTheads.ppt". (del /f "N:\abc\abc Functional Area Shared Data\Structures and xyzPDQ\4uImg2sv4_25_02 Meeting\MiscNotes\ April 25, 2002 Meeting - RC empThe ads.ppt".) else echo "N:\abc\abc Functional Area Shared Data\Structures and xyzPDQ\4uImg2sv4_25_02

    PROBLEM: Notice that the truncation of [Meeting\MiscNotes\ April 25, 2002 Meeting - RC empThe ads.ppt". did NOT copy.] The message doesn't get past about 339 characters.

    "cmd(2)String" is(are) locally declared String(s), dQ is char(34) or ", and rst2Batch!dosCommand is a memo.

    Any Ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    Why not Us some Script


    Download the help file
    http://msdn.microsoft.com/library/de...ist/webdev.asp

    in there there is a heaps example which will do every thing you want
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Thanks for your reply, but I don't need to script to the best of my knowledge (I know zero about script, and a lot about DOS and VBA).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •