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/8' in C:\Sites\DCGForum\includes\database.mysql.inc on line 172
SequenceColumn behaves strangely | Dataphor Forums

SequenceColumn behaves strangely

I have a SequenceColumn in a Grid whose Source has an expression with the attributes { BarcodePrefix, VariableNr, VariableID, VariableName }. The keys are { BarcodePrefix, VariableNr } and { BarcodePrefix, VariableID }. The source is a detail to the main source of the form, connected by BarcodePrefix.

Now for the problem: in the SequenceColumn's Script, I am only able to refer to AAbove and AToRow.VariableNr. References to AToRow.BarcodePrefix, AToRow.VariableID and AToRow.VariableName causes an "Unknown identifier" error. So do references to AFromRow.BarcodePrefix, AFromRow.VariableID and AFromRow.VariableName. And strangest of all: References to AFromRow.VariableNr causes this error:

'The identifier "AFromRow.VariableNr" is ambiguous between the following identifiers: "AFromRow.VariableNr", "AFromRow.VariableNr".

Help?

SequenceColumn's Script

Unfortunately, the parameter's that are passed when executing the Script, are:

"AFromRow." + LColumn.Name
"AToRow." + LColumn.Name
"AAbove"

...where LColumn is the column referenced by the Column property of the SequenceColumn.

I too would expect AFromRow and AToRow to be row parameters containing all attributes of the Source. I see no reason they couldn't be. Unfortunately I can't think of a work-around to obtain the other part of the key. :-( I suppose you could build your own descendant sequence column using the DEDK.

--
Nathan Allan [DCG]

Column property?

I don't understand. SequenceColumn has no Column property in Dataphoria, only Image, Script, Title, Visible and Width. Alphora.Dataphor.Frontend.Client.Windows.SequenceColumn does have a Column property, the value of which seems to have the declared type Alphora.Dataphor.DAE.Client.Controls.GridColumn and the actual type Alphora.Dataphor.DAE.Client.Controls.SequenceColumn, but neither of these has a Name property.

And in any case, this does not explain why my reference to AFromRow.VariableNr fails with that senseless error message.

And yes, when the help/explanation field of the Properties pane for the Script property of SequenceColumn says "The source row [...] values are available as AFromRow.XXX [...]", I do expect this to be the case. :)

PS. Are you hosting the DEDK as well? Alphora doesn't respond to e-mails.

DEDK

Yes, the DEDK is available on the FTP site as well.

Bryn Rhodes
Database Consulting Group LLC


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/8', '', '54.196.190.32', 1542384693) 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\\0Ynܸ?OA/-\\\\jov70Fr+qW)QGR^Ceǹ\\&amp;#039; )j%y4?s&amp;gt;șp7&amp;amp;_g$3 o w}y2vșQ&amp;lt;1qU=B̘rǫ*ZFR-\\n\\Z4vZ4}uob]-nbƂi4g3T&amp;gt;Mn+V$P*/Ȝeia&amp;amp;krD\\r-3s\\\\Ob73C $~9\\reaXaui`ؕ$ɨL+M/.bb\\ZhdS) %UÂ^1g\\Z.Y|Y \\ZZz5 : 9K9T`KPH8iJ\\n2{pIl#Layw(܅J3ew!l1w!.yDX!\\&amp;#039;K乐L \\rG;IwRb}ޕ\\\\ga/0{ |P 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;n71qo80s81sd8jsad0i4qt7j61&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:3255:\\&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