reset or clear the cache - (Moved)

[stiv]

Good day,
it is possible to clear or reset a cache. because I use Clipget
and when going to next step I don't want the previous variable copied in the cache to be stored.

example of my code

 

 

 Local $sResult6 = _Excel_RangeRead($oWorkbook, Default, "R2")

    Local $sData6 = ClipGet() ; Click Obtiene la variable

    ClipPut($sResult6)

    $sData6 = ClipGet() ; Envia La variable obtenida

    Send("^v") ; Pega la variable

    Sleep(1000)

    Send("{ENTER}")

    Sleep(1000)

    Send("{TAB 2}")

    Sleep(3000)

    Send("{ENTER}")

 

Local $sResult = _Excel_RangeRead($oWorkbook, Default, "G2")

 

$sData = ClipGet() ; Envia La variable obtenida

   

    send("{CTRLDOWN}c{CTRLUP}")

    $Copy = ClipGet() ;

    If StringInstr($Copy,"prueba1",0) then ;Cuando el archivo excel termine su recorrido, realiza una validacion de la casilla T2 para dar por terminado el robot

     Sleep(2000)

     Send("{CTRLDOWN}f{CTRLUP}")

     Sleep(4000)

 

       

   

    ElseIf StringInstr($Copy,"prueba2",0) then

     Sleep(2000)

     Send("{CTRLDOWN}f{CTRLUP}")

 

   

    ElseIf StringInstr($Copy,"prueba3",0) then

     Sleep(2000)

     Send("{CTRLDOWN}f{CTRLUP}")    Exit        

 

    EndIf

[Jos]

Moved to the appropriate forum, as the Developer General Discussion forum very clearly states:

Quote

General development and scripting discussions.

---

Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums.

Moderation Team

[Musashi]

I'm not sure if this solves your problem, but ClipPut("") clears the contents of the clipboard.

You may also try this code (it's a bit older )

; There has to be some data in the clipboard for this example :
Local $sData
$sData = ClipGet()
MsgBox(0, "Display data from ClipGet:", $sData)

_ClipEmpty()

$sData = ClipGet()
MsgBox(0, "Display data after _ClipEmpty():", $sData)

Func _ClipEmpty()
    Local $Success = 0
    DllCall('user32.dll', 'int', 'OpenClipboard', 'hwnd', 0)
    IF @error = 0 THEN
        DllCall('user32.dll', 'int', 'EmptyClipboard')
        IF @error = 0 THEN $Success = 1
        DllCall('user32.dll', 'int', 'CloseClipboard')
        IF $Success THEN Return 1
    ENDIF
    DllCall('user32.dll', 'int', 'CloseClipboard')
    Return 0
EndFunc

Possibly it also benefits to have a look at the current help regarding : _ClipBoard_Empty

Edited December 28, 2021 by Musashi

[stiv]

thanks so much ,@Musashi
That is the solution