I´ve written a little test-script for working with ODBC. The real one still got ODBC but will be connected to a proper database then Acces 97. Everything works great with DBI::ODBC (win32 is not an option for me). When I give this query to the ODBC, MS Access returns a 'not a valid query'-error.

my $stt = $db->prepare("CREATE TABLE ".$row[0]."(id smallint, datum da
+te, mach smallint, van_afd smallint, naar_afd smallint, bewerking int
+, hoev_gepland int, gepland enum('true','false')");
[download]

(I also tried the escape-tags for the ' of the enum) Also

("CREATE TABLE ".$row[0]."(id smallint NOT NULL)");
[download]

won´t work. While

("CREATE TABLE ".$row[0]."(id smallint)");
[download]

works perfectly. Am I missing something? Greetings, Joris

There's your complete question. I did read it. Here's my understanding of the steps you took:

• You have a CREATE TABLE command with several fields that fails;
• You have a simple CREATE TABLE that works;
• You've tried escaping the ' characters in the enum field, but that made no difference; and
• Now you're stuck and would like our help and suggestions.

So, what I suggested was that you go back and figure out what was broken by taking 'baby steps' from the simple command that works, to the complicated command that doesn't work. Once you find out what breaks the command, you know what to fix.

Anyway, it seems you got the answer that ENUM is not a real SQL command, so you're on your way, and good luck with that.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.