Hi Chip,
I figured out what I was doing wrong. When I put in the field name I didn't
add the field type or size. I tried again and didn't get an error. Live
and learn. Again thanks for all your help.
----- Original Message -----
From: "Chip Orange" <[email protected]>
To: <[email protected]>
Sent: Tuesday, December 01, 2009 9:49 PM
Subject: RE: error when creating a table
Gary,
did you try to define a field named group_name? I'm not sure why that
text
is there otherwise, but it looks like a field name without an accompanying
field type (such as text(25)).
-----Original Message-----
From: Gary Metzler [mailto:[email protected]]
Sent: Tuesday, December 01, 2009 6:40 PM
To: [email protected]
Subject: error when creating a table
Hi All,
I updated the homer shared object script. But, I am getting an error when
I
try to create a new table. I am using db dialog 1.1 Here is the error:
Error (Dialog)
ADO Provider Error Number: -2147217900 (Edit Box)
Description: Syntax error in field definition. (Edit Box) Native Error:
-538119649 (Edit Box) SQL State: 3000 (Edit Box)
Source: Microsoft JET Database Engine (Edit Box) SQL Command: (Edit Box)
create table booking (Tagged Text(1), booking_ID Counter Primary Key,
Added
DateTime, (Edit Box) Modified DateTime, Group_name, Extra_Info Memo)
(Edit
Box) Close (Button)
Any help would be most appreciated. Thanks, Regards, Gary Metzler send
to:
[email protected] http://www.outtasighttravel.com Msn messenger:
[email protected] Skype name: garymetz
