No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
15 Posted Topics
 | [QUOTE=whitefly;1612259]Is it possible to select a block vertically (rather than the usual horizontal) and delete or add multiple lines in columns in one go from within RAD studio's (Delphi's) IDE? You can select a block by pressing ALT and (keeping it pressed) selecting text with the mouse. You can then …  |
| | [QUOTE=Mr.Ram;1616231]Hi, how can we reduce the time of query execution time? I m using mysql. I have to execute one query which select data from lot of tables . It takes more time to execute. Please give me good suggestion for this.......[/QUOTE] - If table index uses all the columns … |
 | Generally there are (at least) two ways to do this but not all databases support both. If database supports nested queries, you can use the following syntax: [CODE]SELECT EMP.* FROM EMPLOYEE EMP JOIN (SELECT DID AS DID2,MIN(SALRY) AS SAL2 FROM EMPLOYEE GROUP BY DID) ON EMP.SALRY=SAL2 AND EMP.DID=DID2[/CODE] that works …  |
| | The query seems to contain at least few possible errors: * 2nd userId : ..AND userId= '$userId'.. should it be topics.userId='$userId' ? (or it's not needed at all). Currently it's open to interpretation as to which userId it points to (if both tables contain this column). * AND $egroup = … |
| | What DB are you using, what is the class of tblComp and what are the types for the fields you are using in locate and types of the variables (string?) ? Some possible reasons: - if sAddLine2 type is BLOB it would explain the error (you cannot locate using blob … |
| | >From 8x8 onwards, I get a 'Invalid Floating Point' Error in this line : > [CODE]tCopy.Matrix[i,j] := tCopy.Matrix[i,j] / tmp;[/CODE] Possible reason could be that tmp is zero or near it, so that result of division by tmp gives out a numer over 1.18 x 10^4932( maximum extended range). You … |
| | You might want to check the HD for errors as HD near failing could also cause this. Whole system usually becomes unresponsive until the HD finally manages to complete reading/writing on the failing drive. |
| | I'm not familiar with TWizardPage or TNewCheckBox classes but it seems to me that Box2 and Checkbox are both local variables in each of the functions/procedures. As such they are uninitialized under CheckBoxOnClick when you try to use them. You might try to find the correct object using Sender ( … |
| | Simpler way would be to save the commands to a batch file and then execute it. ( for example using savetofile method of tstrings) and then executing the file with: [code] ShellExecute( 0,'open', pchar(file_name),nil,pchar(extractfilepath(file_name)),0); [/code] or [code] WinExec(pchar(file_name),SW_SHOWDEFAULT); [/code] |
| | Sounds like a school work assignment, so I'm just going to post the basis for one type of solution: - you need to add a line of text as a separator after each single memo ( for example '<BREAK>') - something that the user would not normally type into the … |
 | I'm sure there are ready made password dialogs out there but you can easily make your own - it's just a simple form with few labels, edit boxes and buttons. Tedit has 'PasswordChar' property that you can use to hide the entered password. ( set it to * or similar … |
| | FileCtrl contains windows 3.1 stuff so SelectDirectory opens windows 3.1 style dialog. Personally I wouldn't want to use it. It's possible to use OpenDialog to open only folders: Set ofNoValidate in opendialog.options to True, set Filter to '*.' (no 's) and filename to '*.'. Then you can use opendialog to … |
| | Re: Ping and IP Here's a sample from a code I use for opening and executing other programs from within dephi. This executes a file and gives it a 2nd file as a parameter. params [code] procedure execute_file(file_to_execute:string;file_to_transfer:string); var str_to_execute:string; begin if fileexists( file_to_execute )=false then exit; if fileexists( file_to_transfer )=false then exit; str_to_execute:=ExtractShortPathName(file_to_execute)+' … |
| | Re: Ordering You can also move the current controls to inside the groupbox : 1. Select all the controls you would like to move ( SHIFT+mouse button or CTRL+hold mouse button to select an area). 2. Release the CTRL or SHIFT you were holding and click on any of the selected controls … |
| | Re: Locking Rows Perhaps you could do it with your own MySQL Function that returned the next free rowid while updating status on the row. Optionally you could combine this with 3rd party MySQL UDF that allows global variables. That would: - centralise the processing on the db server side, making it faster … |
The End.