Hi Folks,
This might be a little off topic: I am wondering if anyone knows how to
specify field properties when using the Create TABLE or Alter TABLE SQL
statements in MS Access. I am writing some code to create a few tables on
the fly, and it would be very handy to be able to specify things like
"required" and "Allow Zero Length strings", etc... when creating the tables
or altering them.
So far my SQL statements for MS Access 2000 look like:
<CFQUERY name="alter_this_table_query" datasource="#applicaton.DSN#">
Alter Table #prefix#_customer_table
ADD #prefix#_customer_id Counter NOT NULL primary key,
#prefix#_customer_description memo,
#prefix#_customer_name text
</cfquery>
I've looked around, but can't find the secret. Anyone know?
Thanks,
Eron
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
