Difference between revisions of "Error Messages/40858"

Latest revision as of 22:12, 8 March 2016

Error message examples

First parameter to DbTable must be defined with a DbQuery or DbWrite function.

First parameter to DbLabels must be defined with a DbQuery or DbWrite function.

Cause

The first parameter passed to the function mentioned in the error message must be a «dbIndex», variable in your Analytica model defined with DbQuery() or Dbwrite() function.

The following code shows an example of using the DbLabels with another object defined with DbQuery:

Definition of DBRows:

DBRows := DbQuery("DSN = Sample Database", "Select * From Customer")

Definition of DBColumnNames:

DBColumnNames := DbLabels(DBRows);

Remedies

Correct the first parameter to the function to be «dbIndex» index defined by either the DbQuery() or the Dbwrite() function.

@@ Line 1: / Line 1: @@
-= Error Message Examples =
+[[Category: Error messages]]
- First parameter to [[DbTable]] must be defined with a [[DbQuery|DbQuery()]] or [[DbWrite|Dbwrite()]] function.
+== Error message examples ==
- First parameter to [[DbLabels]] must be defined with a [[DbQuery|DbQuery()]] or [[DbWrite|Dbwrite()]] function.
+<pre style="background:white; border:white; margin-left: 1em; font-style:italic">
+First parameter to DbTable must be defined with a DbQuery or DbWrite function.
-= Cause =
+First parameter to DbLabels must be defined with a DbQuery or DbWrite function.
+</pre>
-The first parameter passed to the function mentioned in the error message must be a dbIndex, variable in your Analytica model defined with [[DbQuery|DbQuery()]] or [[DbWrite|Dbwrite()]] function.
+== Cause ==
+The first parameter passed to the function mentioned in the error message must be a «dbIndex», variable in your Analytica model defined with [[DbQuery|DbQuery()]] or [[DbWrite|Dbwrite()]] function.
 The following code shows an example of using the [[DbLabels]] with another object defined with [[DbQuery]]:
-Definition of '''DBRows''':<br>
+Definition of <code>DBRows</code>:
-<code>DbQuery("DSN=Xtreme Sample Database 2008", "Select * From Customer")</code>
+:<code>DBRows := DbQuery("DSN = Sample Database", "Select * From Customer")</code>
-</code
-Definition of '''DBColumnNames''':<br>
+Definition of <code>DBColumnNames</code>:
-<code>DbLabels(DBRows);
+:<code>DBColumnNames := DbLabels(DBRows);</code>
-</code>
-= Remedies =
+== Remedies ==
+Correct the first parameter to the function to be «dbIndex» index defined by either the [[DbQuery|DbQuery()]] or the [[DbWrite|Dbwrite()]] function.
-<br><comments />
+==See Also==
+* [[DbTable]]
+* [[DbLabels]]
+* [[DbQuery]]
+* [[DbWrite]]