Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RunSQL Action
Message
From
14/11/2002 15:13:07
Roger Toppin
PricewaterhouseCoopers
Bridgetown, Barbados
 
 
To
All
General information
Forum:
Microsoft Office
Category:
Access
Title:
RunSQL Action
Miscellaneous
Thread ID:
00722903
Message ID:
00722903
Views:
54
What's wrong with this statement?
"CREATE TABLE Journal (JournalID AUTOINCREMENT PRIMARY KEY, LedgerID INTEGER, StoreID INTEGER, TrackID INTEGER, Period INTEGER, Take Currency, Pay Currency, CONSTRAINT StoreJournal NOT NULL FOREIGN KEY StoreID REFERENCES Store ON UPDATE CASCADE ON DELETE CASCADE)"

I keep getting an error that says: "Syntax error in constraint clause"
True knowledge is knowing the extent of your ignorance.
Reply
Map
View

Click here to load this message in the networking platform