Jump to content

Recommended Posts

Posted

Hi, I was wondering if there is a limit of data one can paste in an edit control, because in my test I copy 960+ rows of values in MysqlQuerryBrowser and can paste them anywhere without a problem, but when pasting them inside an edit control, Only 387 of them appear :)

Are there some special options or anything I'm missing?

Thanks in advance...

Posted

Not sure if it is of any use but this is the source...

CODE
#include <GUIConstants.au3>

Dim $read, $auth, $geo, $file, $x1, $y1, $x2, $y2, $file, $quer, $ver

Dim $x11, $y11, $x21, $y21

Dim $rgxpsearch

$ver = @YEAR & "." & @MON & "." & @MDAY

$read = FileRead(".\header")

If (@error = 1) Then

MsgBox(0, "ERROR", "Could not open header file!")

Exit

EndIf

$gui = GUICreate("Eleria's Lazy Ass Helper", 272, 223, 475, 267)

$Group1 = GUICtrlCreateGroup("SQL_Creator", 1, 0, 133, 189, $BS_CENTER)

$auth_ = GUICtrlCreateInput("", 44, 80, 45, 21)

$file_ = GUICtrlCreateInput("", 68, 120, 58, 21)

$poi_ = GUICtrlCreateInput("", 8, 120, 58, 21)

$com_ = GUICtrlCreateInput("", 19, 159, 97, 21)

$geoy_ = GUICtrlCreateInput("", 67, 41, 33, 21, BitOR($ES_CENTER, $ES_AUTOHSCROLL, $ES_NUMBER))

$geox_ = GUICtrlCreateInput("", 32, 41, 33, 21, BitOR($ES_CENTER, $ES_AUTOHSCROLL, $ES_NUMBER))

$quer_ = GUICtrlCreateEdit("", 138, 7, 131, 214)

$Label1 = GUICtrlCreateLabel("Author", 50, 65, 35, 13)

$Label3 = GUICtrlCreateLabel("P.O.I.", 20, 105, 36, 13, $SS_CENTER)

$Label4 = GUICtrlCreateLabel("Filename", 73, 105, 46, 13, $SS_CENTER)

$Label11 = GUICtrlCreateLabel("Query Comments", 28, 144, 84, 13)

$create = GUICtrlCreateButton("Create", 42, 194, 53, 25, $BS_DEFPUSHBUTTON)

$Label5 = GUICtrlCreateLabel("Geo_y", 68, 25, 35, 13)

$Label6 = GUICtrlCreateLabel("Geo_x", 29, 25, 35, 13)

GUISetState(@SW_SHOW)

While 1

$nMsg = GUIGetMsg()

Switch $nMsg

Case $GUI_EVENT_CLOSE

Exit

Case $create

$read = FileRead(".\header")

$rgxpsearch = FileRead(".\rgxpsearch")

$auth = GUICtrlRead($auth_)

$file = GUICtrlRead($file_)

$poi = GUICtrlRead($poi_)

$com = GUICtrlRead($com_)

$geox = GUICtrlRead($geox_)

$geoy = GUICtrlRead($geoy_)

$quer = GUICtrlRead($quer_)

$geo = $geox & "_" & $geoy

$x1 = ($geox - 20) * 32768

$y1 = ($geoy - 18) * 32768

$x2 = ($geox - 19) * 32768

$y2 = ($geoy - 17) * 32768

$quer = StringRegExpReplace($quer, $rgxpsearch, "('" & $com & "', $1),")

$quer = StringTrimRight($quer, 1)

$quer &= ";"

$read = StringReplace($read, "%auth%", $auth)

$read = StringReplace($read, "%geo%", $geo)

$read = StringReplace($read, "%x1%", $x1)

$read = StringReplace($read, "%y1%", $y1)

$read = StringReplace($read, "%x2%", $x2)

$read = StringReplace($read, "%y2%", $y2)

$read = StringReplace($read, "%poi%", $poi)

$read = StringReplace($read, "%quer%", $quer)

$read = StringReplace($read, "%ver%", $ver)

If FileExists($file & ".sql") Then

FileDelete($file & ".sql")

EndIf

FileWrite($file & ".sql", $read)

EndSwitch

WEnd

Posted

Consider...

Your AutoIt version... a buffer limit may have since been overcome.

Your clipboard info... may have a "null" within it.

The limits of a standard Edit field... I don't know what it is.

Lar.

f_mrcleansmalm_77ce002.jpgAutoIt has helped make me wealthy

Posted

There is a limit with chars. You can set it to infinite with

_GUICtrlEdit_SetLimitText(GUICtrlGetHandle($Edit),-1)

*GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes

Posted

Woot! thank you guys, I'm not used to those includes and underscore-functions at all ^^ (I was an low-average user of AutoHotkey but I find autoit more robust and a bit more "logical"...)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...