Warning: Table '.\dcgforum\cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://forums.dataphor.org/index.php?q=node/11' in C:\Sites\DCGForum\includes\database.mysql.inc on line 172
Filter strangeness | Dataphor Forums

Filter strangeness

I have customized a Browse form for a table T. The customization consists of a simple expression in the Filter property of the Main source. When I Open or Show the form in Dataphoria, or use it as the Start Document of an Application, the filter is honoured. However, when the form is opened by a ShowFormAction in another form, the filter doesn't work; all the rows of T are shown. What is going on?

Filter behavior

Hi Jon,

I believe what is happening is that since the ShowFormAction has a Filter property, it is overwriting the Filter on the Source in the form being shown. A workaround then would be to set the Filter on the ShowFormAction as well.

Regards,
Bryn Rhodes
Database Consulting Group LLC

Re: Filter behaviour

Yes, that works. Thanks.


Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: LOCK TABLES cache_page WRITE</em> in <em>C:\\Sites\\DCGForum\\includes\\database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://forums.dataphor.org/index.php?q=node/11', '', '54.196.190.32', 1542384705) in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &amp;#039;.\\dcgforum\\cache_page&amp;#039; is marked as crashed and should be repaired\nquery: UPDATE cache_page SET data = &amp;#039;\\0\\0\\0\\0\\0\\0Xr6LᔝvoLђڮHj;?qX;m@$$b \\0ZVf/2\\&amp;#039;s\\0\\&amp;quot;eYi\\\\3(4?&amp;lt;~Ǔ $q|$KkN$y#(w&amp;lt;Oz=Xڬ \\rif\\Z[?m,}r4 R ó01A璩4*mFOr2N8gτt\\0.#?9V3mN0XpǀJN W.oJA\\ZM#\\\\BN=4gr72&amp;gt; MPp9,ʁ/Qd n!{d;GיF`+aYH`ӈI;E B:h3\\Zhx#xd|*G4&amp;gt;&amp;gt;rؒr$&amp;lt;?TO!&amp;amp;]΋mb/d6xdq:W)P߾oFqXtpk1Z\\n in C:\Sites\DCGForum\includes\database.mysql.inc on line 172

Warning: Table '.\dcgforum\watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Incorrect string value: &amp;#039;\\x8B\\x08\\0\\0...&amp;#039; for column &amp;#039;session&amp;#039; at row 1\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;8tdi8v2225free5c4fg1um6u12&amp;#039;, 0, 0, &amp;#039;54.196.190.32&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:195:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is marked as crashed and should be repaired\\nquery: LOCK TABLES cache_page WRITE in C:\\\\Sites\\\\DCGForum\\\\includes\\\\database.mysql.inc on line 172.\\&amp;quot;;i:1;s:2508:\\&amp;quot;user warning: Table &amp;amp;#039;.\\\\dcgforum\\\\cache_page&amp;amp;#039; is mark in C:\Sites\DCGForum\includes\database.mysql.inc on line 172