<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">use FOR instead of table<br><br>Edward Koryagin<br><br>--- On <b>Wed, 22/9/10, Jeremy Coulter <i><jscoulter@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Jeremy Coulter <jscoulter@gmail.com><br>Subject: [DUG] Interbase Stored Proc<br>To: "NZ Borland Developers Group - Delphi List" <delphi@delphi.org.nz><br>Received: Wednesday, 22 September, 2010, 9:32 AM<br><br><div id="yiv474291204">Hi all.<br>I know a few of you out there work with Interbase so I thought I might ask the following question here.<br><br>I want to create a stored procedure that creates a table. So I am doing :-<br><br><br>CREATE PROCEDURE MySP_ AS <br>
begin<br> create table DAR_RESULTS<br>(<br>PATIENTID char(7),<br>TEST_NAME varchar(30),<br>WHENRECEIVED date,<br>RESULT varchar(16)<br>);<br>END<br><br><br>However, it doesnt like this and complains avout the "(" althought when I removed this it still gave the same error :-)<br>
<br>can someone who knows IB a bit better point me in the right direction?<br><br><br>Jeremy<br>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>NZ Borland Developers Group - Delphi mailing list<br>Post: <a ymailto="mailto:delphi@delphi.org.nz" href="/mc/compose?to=delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>Unsubscribe: send an email to <a ymailto="mailto:delphi-request@delphi.org.nz" href="/mc/compose?to=delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe</div></blockquote></td></tr></table><br>