Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 10 of 16 total |
VERIFY |
Wed, Jan 30 2013 4:00 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I know this was discussed a while ago and may have had something done but if so I missed it. Is there a way to get back information if a table verified or had a problem so it needs repairing. Other than a user sitting there watching in EDBManager? Roy Lambert |
Wed, Jan 30 2013 12:50 PM | Permanent Link |
Barry | Roy,
Good point. I thought if I used: verify table table1! verify table table2! verify table table3! verify table table4! in an SQL window with "Request Execution Plan" turn on, it would show the results in the execution plan tab. But no "execution plan" tab opens up. It also does not show up in Configuration.LogEvents. Methinks Tim might have forgotten something. Barry |
Wed, Jan 30 2013 2:54 PM | Permanent Link |
Fernando Dias Team Elevate | Roy,
Yes, there is the STMTRESULT PSM/SQL function. It returns the result of the execution of the execution of the last REPAIR TABLE and VERIFY TABLE. There is an example in the manual showing how to use it. -- Fernando Dias [Team Elevate] |
Wed, Jan 30 2013 3:20 PM | Permanent Link |
Fernando Dias Team Elevate | Barry
In EDB Manager, the errors found during VERIFY or REPAIR, if any, are shown in the "Log Messages" tab, and the final result is shown in the status bar. To make the tab visible, in case it's not, click "Log Messages" in the "Explorer" menu. -- Fernando Dias [Team Elevate] |
Thu, Jan 31 2013 3:47 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
Isn't reading the manual considered as cheating? Thanks. I'll modify my query to a script and off we go. Roy Lambert |
Thu, Jan 31 2013 7:56 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
Having been told about this by someone who reads the manual ,g> I'm testing it out. I tried SCRIPT(IN Action VARCHAR, IN TableName VARCHAR, OUT Worked BOOLEAN) BEGIN DECLARE Stmt STATEMENT; PREPARE Stmt FROM Action + ' TABLE '+ QUOTEDSTR(TableName,'"'); EXECUTE Stmt; SET Worked = STMTRESULT(Stmt); END in EDBManager but for both REPAIR and VERIFY Worked is only set to false. I tried verifying and repairing the table as simple operations and that seems fine. I also tried SET Worked = TRUE and that was fine. Am I doing something wrong or is it a bug? Roy Lambert |
Thu, Jan 31 2013 10:11 AM | Permanent Link |
Fernando Dias Team Elevate | Roy,
The manual is wrong, it's exactly the opposite - it returns TRUE if there are errors (VERIFY) or if repairs have been made (REPAIR), otherwise it returns false. It seems I haven't read the manual carefully. -- Fernando Dias [Team Elevate] |
Thu, Jan 31 2013 11:11 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
Thanks. Roy Lambert |
Thu, Jan 31 2013 11:20 AM | Permanent Link |
Raul Team Elevate | Fernando,
I don't see how manual is wrong in this case : as per manual : "each reports False if no errors were found" Conversely if VERIFY finds errors or REPAIR repairs them it will return TRUE as per manual - which is what you're seeing. Raul On 1/31/2013 10:11 AM, Fernando Dias wrote: > Roy, > > The manual is wrong, it's exactly the opposite - it returns TRUE if > there are errors (VERIFY) or if repairs have been made (REPAIR), > otherwise it returns false. |
Thu, Jan 31 2013 11:52 AM | Permanent Link |
Fernando Dias Team Elevate | Raul,
The is now correct, but it has been corrected today, when Roy first saw it it was wrong -- Fernando Dias [Team Elevate] |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |