/usr/share/gtk-doc/html/libgda-4.0/ch11s11.html is in libgda-4.0-doc 4.2.8-2build1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Validate a DML statement</title>
<meta name="generator" content="DocBook XSL Stylesheets V1.75.2">
<link rel="home" href="index.html" title="GNOME Data Access 4 manual">
<link rel="up" href="howto.html" title="HOWTO for common tasks">
<link rel="prev" href="howto-meta2.html" title="Update the meta data about a table">
<link rel="next" href="ch11s12.html" title="Control value's assignment to various objects">
<meta name="generator" content="GTK-Doc V1.17 (XML mode)">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<table class="navigation" id="top" width="100%" summary="Navigation header" cellpadding="2" cellspacing="2"><tr valign="middle">
<td><a accesskey="p" href="howto-meta2.html"><img src="left.png" width="24" height="24" border="0" alt="Prev"></a></td>
<td><a accesskey="u" href="howto.html"><img src="up.png" width="24" height="24" border="0" alt="Up"></a></td>
<td><a accesskey="h" href="index.html"><img src="home.png" width="24" height="24" border="0" alt="Home"></a></td>
<th width="100%" align="center">GNOME Data Access 4 manual</th>
<td><a accesskey="n" href="ch11s12.html"><img src="right.png" width="24" height="24" border="0" alt="Next"></a></td>
</tr></table>
<div class="sect1">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="id546174"></a>Validate a DML statement</h2></div></div></div>
<p>
<span class="application">Libgda</span> supports validating DML (SELECT, INSERT, UPDATE and DELETE) statements: making sure every
database object referenced in the statement actually exists in the database being accessed through
a connection.
The validation process involves the meta data associated to a connection, son one must make that
meta data is up to date with the database being accessed, using
<a class="link" href="GdaConnection.html#gda-connection-update-meta-store" title="gda_connection_update_meta_store ()">gda_connection_update_meta_store()</a> (also see the
<a class="link" href="howto-meta1.html" title="Get information about a table's columns">Get information about a table's columns</a> section).
</p>
<p>
The following code shows how to validate a statement (assuming the statement already exists):
</p>
<pre class="programlisting">
if (!gda_statement_check_validity (stmt, cnc, &error))
g_print ("Invalid statement: %s\n",
error && error->message ? error->message : "No detail");
else
g_print ("Statement is valid\n");
</pre>
<p>
</p>
</div>
<div class="footer">
<hr>
Generated by GTK-Doc V1.17</div>
</body>
</html>
|