I appreciate the explanation. It's much simpler to read.
For the online reference, I didn't this topic specifically, though that's why I needed it today. I find google only good if I KNOW the keywords that I need. An online reference is a little easier to browse. I have a good CF one.
I did
daniel kessler wrote:
> That great and it executed.
> So I don't have a foreign key anymore? Is it not needed? I think that it's part of the available Oracle syntax, so what do I lose by not having it?
You foreign key is still there, you just don't need the "foreign
key" keyword if you define y
That great and it executed.
So I don't have a foreign key anymore? Is it not needed? I think that it's part of the available Oracle syntax, so what do I lose by not having it?
btw, anyone know of a good online Oracle reference or list?
> create table fsnep_pollAnswers (
> pA_id NUMBER Primar
daniel kessler wrote:
> If you mean have a semi-colon between each create table and create sequence, I actually input them seperately, individually. Not as a set of statements. When I get the error, I'm only doing (without the comments field which I only have in my documentation):
>
> create tab
If you mean have a semi-colon between each create table and create sequence, I actually input them seperately, individually. Not as a set of statements. When I get the error, I'm only doing (without the comments field which I only have in my documentation):
create table fsnep_pollAnswers (
pA
Two things I'd guess at, try a semi-colon between statements and the comment is an HTML one not a
CF one, add two more hyphens
Ade
-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: 16 September 2004 12:47
To: CF-Talk
Subject: create table error
I'm trying to creat
John Quarto-vonTivadar wrote:
> This brings up an interesting question I've had for a while: I've seen a few
> (but only a few!) developers use CreateUUID() for creating a record's PKID,
> and therefore have the PKIDs be strings rather than integers.
Storage and internal representation is not nece
John wrote:
>...a few others say that they used that only for creating a
>unique ID, but that they had a separate ID field in each table that was
>numeric which they used for joins. This part seemed like overkill to >me - surely there's some stored procedure that accomplishes all of
>this?
I do
fice Phone 606.920.7447
Cell Phone 606.831.4590
-Original Message-
From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 3:19 PM
To: CF-Talk
Subject: Re: Create table ID field
This brings up an interesting question I've had for a while: I've seen a
This brings up an interesting question I've had for a while: I've seen a few
(but only a few!) developers use CreateUUID() for creating a record's PKID,
and therefore have the PKIDs be strings rather than integers. (their
argument was that they didn't have to worry about another record being
insert
That did it!! Thanks much Matt.
And thanks all the others for chipping in as well.
Robert O.
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 2:39 PM
To: CF-Talk
Subject: RE: Create table ID field
No. That was a complete example of a
ore the details.
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 11:22 AM
To: CF-Talk
Subject: RE:
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 12:43 PM
To: CF-Talk
Subject: RE: Create table ID field
Here's an example for an Access table, where the primary key is an
autonumber field, and there's a separate index as well.
Here's an example for an Access table, where the primary key is an
autonumber field, and there's a separate index as well.
datasource="#request.blahblah#">
CREATE TABLE myfile (
ID COUNTER not NULL PRIMARY KEY,
ParentID number NULL,
LinkID number NULL,
Slot number NULL ,
ItemType text(
:51 AM
To: CF-Talk
Subject: Re: Create table ID field
Robert Orlini wrote:
> How do I do this? I've tried different ways. Is it in the Insert section?
INSERT INTO #trialname# (ID, Orderdate, Institution)
VALUES (#ID#, '#DateFormat(Now())#', '#FORM.Institution#')
Robert Orlini wrote:
> How do I do this? I've tried different ways. Is it in the Insert section?
INSERT INTO #trialname# (ID, Orderdate, Institution)
VALUES (#ID#, '#DateFormat(Now())#', '#FORM.Institution#')
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Tod
How do I do this? I've tried different ways. Is it in the Insert section?
RO
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 11:21 AM
To: CF-Talk
Subject: Re: Create table ID field
Robert Orlini wrote:
>
> I added y
Robert Orlini wrote:
>
> I added your code as:
>
> Create table #trialname#
> (id INTEGER,
> CONSTRAINT #trialname#_pkey PRIMARY KEY (id),
> Orderdate Char (50) not null,
> Institution Char (50) not null,
> Customer Char (50) not null,
> address Char (50) not null,
> city Char (10) not null
nuary 02, 2004 11:09 AM
To: CF-Talk
Subject: Re: Create table ID field
Robert Orlini wrote:
>
>
> Create table #trialname#
> (Orderdate Char (50) not null,
> Institution Char (50) not null,
> Customer Char (50) not null,
> address Char (50) not null,
> city Char (10) not
Depends on the database
If you're using SQL Server;
IDfield identity primary key
You could expand it further
IDfield int identity(1,1) primary key
But they do the same thing
> -Original Message-
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 02, 2004 10:53 AM
>
Ahhh, Access. You stumped me then. :-)
Check the manual as Jochem recommended
The way I showed you was for SQL Server...
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 11:02 AM
To: CF-Talk
Subject: RE: Create table ID field
Hello
Robert Orlini wrote:
>
>
> Create table #trialname#
> (Orderdate Char (50) not null,
> Institution Char (50) not null,
> Customer Char (50) not null,
> address Char (50) not null,
> city Char (10) not null,
> state Char (10) not null,
> zip Char (5) not null,
> phone Char (8) not null,
>
2, 2004 10:56 AM
To: CF-Talk
Subject: RE: Create table ID field
IF EXISTS(
SELECT
*
FROM
dbo.sysobjects
WHERE
id = object_id(N'[dbo].[TABLE_NAME]')
AND
OBJECTPROPERTY(id, N'IsUserTable') = 1
)
ALTER TABLE TABLE_NAME ADD
CONSTRAINT UNIQUELY_NAME_YOUR_PK PRI
IF EXISTS(
SELECT
*
FROM
dbo.sysobjects
WHERE
id = object_id(N'[dbo].[TABLE_NAME]')
AND
OBJECTPROPERTY(id, N'IsUserTable') = 1
)
ALTER TABLE TABLE_NAME ADD
CONSTRAINT UNIQUELY_NAME_YOUR_PK PRIMARY KEY
(
TABLE_FIELD_NAME
)
Mike
-Original Mes sage-
From: Robe
Matt, that worked! I left my SQL book at home but at least you helped me get
this app running today!
Thanks!
-Original Message-
From: Matthew Walker [mailto:Matthew@;cabbagetree.co.nz]
Sent: Thursday, 24 October 2002 12:15 PM
To: CF-Talk
Subject: RE: Create table
al Message-
From: Matthew Walker [mailto:Matthew@;cabbagetree.co.nz]
Sent: Thursday, 24 October 2002 12:15 PM
To: CF-Talk
Subject: RE: Create table
> BookmarkID IDENTITY NOT NULL PRIMARY KEY,
I think:
BookmarkID INT IDENTITY NOT NULL PRIMARY KEY,
M
> BookmarkID IDENTITY NOT NULL PRIMARY KEY,
I think:
BookmarkID INT IDENTITY NOT NULL PRIMARY KEY,
Matthew Walker
http://www.matthewwalker.net.nz/
~|
Archives: http://www.houseoffusion.com/cf
If I'm not mistaken it would be:
CREATE TABLE
#Form.UserFirstName#_#Form.UserMiddleName#_#Form.UserLastName#
(
BookmarkID IDENTITY NOT NULL PRIMARY KEY,
BookmarkName VARCHAR(255),
BookmarkCategory VARCHAR(255),
I had pretty much the same question.
try this link for help
http://www.w3schools.com/sql/
- Original Message -
From: "CF-Talk" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 3:43 PM
Subject: Re: Create Table Questi
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
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)
)
-
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"
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
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 Novembe
Here's one I used earlier.
CREATE TABLE FeaturedSites (FeaturedSiteID COUNTER,
Link VARCHAR(255),
URL VARCHAR(255),
CONSTRAINT CreatePK PRIMARY KEY (FeaturedSiteID));
This creates a table called FeaturedSites with an Auto number field called
FeaturedSiteID and two text field
I solved the problem by using:
on the form page and then put '#auction_date#' in the insert statement.
However, I have another question now.
How can I create an SQL statement that will create a directory so my users
can upload to their own directory?
Thanks,
Rich
---
>1) The Primary Key is not set to auto number, how can I set this? Should I
>be using something in place of TEXT(40) I tried using AutoNumber but that
>returned errors.
CREATE Table #userid#
(
ID COUNTER CONSTRAINT ID PRIMARY KEY,
userid TEXT(40) NOT NULL,
category TEXT(
To: CF-Talk
Subject: RE: Create Table SQL
Are you using SQL Server?if so neither will work as Date is not a valid
type. Replace it with Datetime and it'll work
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
t authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 16:39
To: CF-Talk
Subject: RE: Create Table SQL
This is just a stab in the dark, but that S
8890.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 16:44
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Create Table SQL
This is a multi-part message in MIME format.
--=_NextPart_000__01C0458B.5EE2DAB0
Content-Type: text/plain;
charset="
OK here is what I have so far:
CREATE Table #userid#
(
ID TEXT(40) NOT NULL PRIMARY KEY,
userid TEXT(40) NOT NULL,
category TEXT(10) NOT NULL,
quant TEXT(10) NOT NULL,
startprice TEXT(10) NOT NULL,
duration TEXT(2) NOT NULL,
auction_id TEXT(25) NO
To: CF-Talk
Subject: RE: Create Table SQL
This isn't working for me and I can't figure out why. This works:
auction_date DATE NOT NULL,
however as soon as I ad the Default part
auction_date DATE NOT NULL DEFAULT GETDATE(),
I get errors.
Any Ideas,
Rich
-Origin
This is a multi-part message in MIME format.
--=_NextPart_000__01C0458B.5EE2DAB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
OK here is what I have so far:
CREATE Table #userid#
(
ID TEXT(40) NOT NULL PRIMARY KEY,
userid TEX
e, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:55
To: CF-Talk
Subject: RE: Create Table SQL
This isn't working for me and I can't figure out why. This works:
auction_date
8890.
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:55
To: CF-Talk
Subject: RE: Create Table SQL
This isn't working for me and I can't figure out why. This works:
auction_date DATE NOT NULL,
however as soon as I ad t
In Access setting type to "counter" works as an autonumber as well
CREATE TABLE People(
ID COUNTER,
First Char(50) not null,
Last Char(50) not null
)
Archives: http://www.mail-archive.com/cf-talk@
lto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:23 AM
To: CF-Talk
Subject: RE: Create Table SQL
To create a primary key create a unique clusted index after you have crated
the table like so
CREATE TABLE
( field1 int PRIMARY KEY CLUSTERED
, field2 datetime DEFAU
ailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 14:23
To: CF-Talk
Subject: RE: Create Table SQL
To create a primary key create a unique clusted index after you have crated
the table like so
CREATE TABLE
( field1 int PRIMARY KEY CLUSTERED
, field2 datetime DEFAULT GETDATE()
, f
To create a primary key create a unique clusted index after you have crated
the table like so
CREATE TABLE
( field1 int PRIMARY KEY CLUSTERED
, field2 datetime DEFAULT GETDATE()
, field3..
..
..
..
)
The other way is to creat the table and then create an unique clust
>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
>
50 matches
Mail list logo
