blink314

I havent seen anything while searching the forum. I posted in the bug area but now cant find my post. Personally, I think it's a bug, but I've managed to work around it in the script I'm writing. I wonder, though, if there are other z-order programs with GUI controls. Thanks for the sanity check fossil rock... when I first had this problem I thought I was waaaaaay off base. Kevin

Please see this thread http://www.autoitscript.com/forum/index.php?showtopic=35686 Kevin

It's like there is no sense of z-order, front/back, etc. Kevin

If I click on the front left label in the area where it overlaps with back left, the msgbox tells me back left was clicked... hmmmmmmmm Kevin

Sorry. I changed the "Clicked" in the msgbox. If you do this, you get the ctrlid of the background label when click on the front label. Kevin

Oh, I see. You made the top and bottom labels have an event... I'll have to look into this. I may be able to make it work. The problem is the @GUI_CtrlId is all messed up!! Is this normal?? Kevin

Yours works how I would like mine to work. What did you change? Just the amount of overlap? I will need to have some topmost labels overlap the bottom label (to create a frame effect) so... I'll look at this more. Kevin

I'm trying to make a GUI and I've noticed that if I layer labels they do not respond to events. Run the sample I've attached. The left square is coded to generate an event (in this case a silly msgbox), but it does not generate an event. The right rectangle ONLY generates an event if you click on the part that is not on top of the other black label. Any Ideas??? #include <GUIConstants.au3> opt("GUIOnEventMode", 1) ; Change to OnEvent mod $guiwidth = 200 $guiheight = 150 $MainGUi = GUICreate("Error Demo", $GUIWidth, $GUIHeight, @DesktopWidth/2-($guiwidth/2), @desktopheight/2-($GUIHeight/2+35), $WS_MINIMIZEBOX + $ws_maximizebox) GUISetOnEvent($GUI_EVENT_CLOSE, "CloseGUI") ;Left Box: Background label and top label guictrlcreatelabel("Back",5,5,70,70) GUICtrlSetBkColor(-1,0x000000) guictrlcreatelabel("Front",6,6,68,68) guictrlsetonevent(-1,"LabelClick") ;Right Box: Background label and top label guictrlcreatelabel("Back",75,5,70,70) GUICtrlSetBkColor(-1,0x000000) guictrlcreatelabel("Front",76,6,100,68) GUICtrlSetBkColor(-1,0xCCCCCC) guictrlsetonevent(-1,"LabelClick") GUISetState(@SW_SHOW) While 1 Sleep(1000) ; Idle around WEnd func LabelClick() msgbox(0,"","Click") EndFunc Func CloseGUI() Exit EndFunc ;==>CloseGUI

AutoIt goes down hard. I get popup saying AutoIt has crashed and then all things AutoIt are closed. I can read the error report (well, actually I cant since it's in hex mostly), but it's not a normal crash like when my program crashes. No error report is generated in SciTe and if I have msgboxes around the DLL call I get one before but not one immediately after. It is only when retrieving certain null values from databases. It seems to be that if I insert a null using an SQL statement like this Field1=null I get a crash. If I insert it Field1='' I dont get a crash (at least as of now!). I am using beta 87. I'm leaving for home for the holidays so I will only be checking this periodicaly. Kevin

Ahhh i see... so it's not actually loading the entire database into memory, just any temp tables you create. Useful to know for the future... I haven't used temp tables yet. Kevin

What return type should you use for a "const unsigned char?" This is according the SQLite api for get_column_text. I'm using str and I see you are too... why does this sometimes crash on a null value? Kevin If I go into SQLiteBrowser and "clear" the null cell (no change visually) there is no problem and it reads fine... then crashes at the next null. One problem it seems is that I have been inserting nullstrings as null. If I insert or edit as '' they display without crashing. Anybody know the SQL to search and replace all null cells with null strings??

I was getting some weird crashes (autoit crashes... not my program). Are you? I'll try the data count rather than column count and see if it fixes it. Kevin Still getting them... if I try to extract data from the Nwind Categories table I get a crash. It seems to happen most often on cells that have a null string in them, though not all nulls cause the crash. I did check and I'm getting the right column count.

Here is another quick and dirty Prepare script. You will need to look at the 2 dimensional array (n columns and 2 rows) to see it but it should help give the flow of things. Kevin #include "sqlite.au3" _SQLite_Startup() $hdll = $SQLiteWrapperGlobalVar_hDll $hdb = _SQLite_Open("Trial.db") ;~ int sqlite3_prepare( ;~ sqlite3 *db, /* Database handle */ ;~ const char *zSql, /* SQL statement, UTF-8 encoded */ ;~ int nBytes, /* Length of zSql in bytes. */ ;~ sqlite3_stmt **ppStmt, /* OUT: Statement handle */ ;~ const char **pzTail /* OUT: Pointer to unused portion of zSql */ ;~ ); $sql ="SELECT * FROM sqlite_master" ;Prepare $r = DllCall($hdll,"int","sqlite3_prepare","ptr",$hdb,"str",$sql,"int",StringLen($sql),"long_ptr",0,"long_ptr",0) $ppStmt = $r[4] ;Find Number of Columns $ColumnNumDLL = dllcall($hdll,"int","sqlite3_column_count","ptr",$ppstmt) $ColNum = $ColumnNumDLL[0] $r = DllCall($hdll,"int","sqlite3_step","ptr",$ppStmt) dim $DataArray[$ColNum][2] ;Get Column Names for $ColCount = 0 to $ColNum-1 $Temp = DllCall($hdll,"str","sqlite3_column_name","ptr",$ppStmt,"int",$ColCount) $DataArray[$ColCOunt][0] = $Temp[0] Next ;Get Column Data while $r[0] <> 0 For $ColCount = 0 to $ColNum-1 $Temp = DllCall($hdll,"str","sqlite3_column_text","ptr",$ppStmt,"int",$ColCOunt) $DataArray[$ColCOunt][1] = $Temp[0] Next ;_displayarray($Dataarray) $r = DllCall($hdll,"int","sqlite3_step","ptr",$ppStmt) WEnd ;Finalize $r = DllCall($hdll,"int","sqlite3_finalize","ptr",$ppStmt) _SQLite_Close($hdb) _SQLite_Shutdown()

I looked at it and didnt see anything pertaining to loading the database. I searched for PTREX... this should have turned it up, correct? Your modifications look fine... they are an example of the reasons that you should be doing the modifications. I dont see a need to add them, but I dont see anything wrong with them! Keep changing away. Actually you may want to rewrite it, since it's kind of kludged together. Kevin Incidentally, all VIEWs and I'm assuming Triggers are kept in the sqlit_master. "SELECT * FROM sqlite_master" to see them.

I see no problem with Picasso's implementation. I dont see where we have to agree on things. As far as I'm concerned development is proceeding with you and Picasso. The reason I agreed to "relinquish control" last week is that it was becoming too tedious for me to keep up and ideas were diverging. Granted, most of this stress is self induced... but I do not intend to take it back up! I will help out where I can with minor coding details, but I am more concerned with getting "something" working so I can continue working on my frontend, the part that will actually be useful to me at work and at home. So you two can decide on things! It would be better anyway if the code that is posted here that I wrote is rewritten. I will continue to watch what is happening to see if any new breakthroughs come (Prepare and loading the db into memory in particular) but I am not going to debate standards and usability issues. Please dont think I'm mad, angry, or otherwise discomfitted... I learned a lot and continue to learn a lot by watching this thread, but I dont desire to be on the cutting edge so to speak. Go ahead and make your changes! Kevin