RE: Create Table Question
I'd like to proven wrong on this, but I think you're at the mercy of Jet-SQL which doesn't allow direct manipulation of numerous properties of an Access table. e.g. Default Value, AutoNumber types, etc... -Original Message- From: Will Ryan [SMTP:[EMAIL PROTECTED]] Sent: 13 November 2000 14:36 To: CF-Talk Subject: Create Table Question Greeting Guru's I'm trying to create a table in Access via CF. I need to create an AutoNumber field for an ID. I don't want to create it through access as I would have to upload a 60 meg DB to our offsite server. Any suggestions for the SQL Statement? create table T_AddBook ( AddID autonumber, Name varchar (20), Add1 varchar (40), Add2 varchar (40) ) Thanks, Will Will Ryan [EMAIL PROTECTED] http://www.zerotoeighty.com w: 410-327-9152 f: 410-327-4086 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --- Any opinions expressed in this message are those of the individual and not necessarily the company. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Sapphire Technologies Ltd http://www.sapphire.net Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Create Table Question
You've pretty much got ittry using text instead of varchar as the datatype for the charachter fields. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Will Ryan [mailto:[EMAIL PROTECTED]] Sent: 13 November 2000 14:36 To: CF-Talk Subject: Create Table Question Greeting Guru's I'm trying to create a table in Access via CF. I need to create an AutoNumber field for an ID. I don't want to create it through access as I would have to upload a 60 meg DB to our offsite server. Any suggestions for the SQL Statement? create table T_AddBook ( AddID autonumber, Name varchar (20), Add1 varchar (40), Add2 varchar (40) ) Thanks, Will Will Ryan [EMAIL PROTECTED] http://www.zerotoeighty.com w: 410-327-9152 f: 410-327-4086 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Create Table Question
Try the below: create table T_AddBook ( AddID COUNTER PRIMARY KEY, Name text(20), Add1 text(40), Add2 text(40) Remove the PRIMARY KEY code if the filed is not to be a primary key. Sincerely, Gary Groomer - Original Message - From: "Will Ryan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 6:36 AM Subject: Create Table Question Greeting Guru's I'm trying to create a table in Access via CF. I need to create an AutoNumber field for an ID. I don't want to create it through access as I would have to upload a 60 meg DB to our offsite server. Any suggestions for the SQL Statement? create table T_AddBook ( AddID autonumber, Name varchar (20), Add1 varchar (40), Add2 varchar (40) ) Thanks, Will Will Ryan [EMAIL PROTECTED] http://www.zerotoeighty.com w: 410-327-9152 f: 410-327-4086 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Create Table Question
You can create autonumbers. use "Counter" Adding default values seems a bit tricky, or not possible, I have tried and tried on that point. create table T_AddBook ( AddID counter, Name text(20), Add1 text(40), Add2 text(40) ) Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Create Table Question
A ) is missing at the end. Uwe - Original Message - From: "Gary Groomer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Montag, 13. November 2000 16:31 Subject: Re: Create Table Question Try the below: create table T_AddBook ( AddID COUNTER PRIMARY KEY, Name text(20), Add1 text(40), Add2 text(40) Remove the PRIMARY KEY code if the filed is not to be a primary key. Sincerely, Gary Groomer - Original Message - From: "Will Ryan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 13, 2000 6:36 AM Subject: Create Table Question Greeting Guru's I'm trying to create a table in Access via CF. I need to create an AutoNumber field for an ID. I don't want to create it through access as I would have to upload a 60 meg DB to our offsite server. Any suggestions for the SQL Statement? create table T_AddBook ( AddID autonumber, Name varchar (20), Add1 varchar (40), Add2 varchar (40) ) Thanks, Will Will Ryan [EMAIL PROTECTED] http://www.zerotoeighty.com w: 410-327-9152 f: 410-327-4086 -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
