Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Samorris
Starting Member
2 Posts |
 Posted - 2011-06-15 : 11:21:28
|
| Below is my code, used to create a table automatically. The problem is that i want to set the dtp to have a default value of now()CREATE TABLE comment#vid#(CID Counter Primary Key,UNm Text,VID Number,Cmt Text,DtP DateTime,Rat Number) |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-15 : 11:23:02
|
This is a MS SQL Server forum.Looks like you should post in a MySQL forum?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Samorris
Starting Member
2 Posts |
Posted - 2011-06-15 : 11:25:19
|
[quote]Originally posted by webfred
This is a MS SQL Server forum.Looks like you should post in a MySQL forum?[/quoteBut this is all SQL done in MS Access |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-15 : 11:28:32
|
Aha  I have not realized you are asking about Access - sorry.But I have no answer for that - sorry again.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-15 : 11:48:29
|
| I don't know if it's still true for more recent versions of Access (it appears to be in my quick testing), but this document says that it doesn't work in the MS Access query interface, and that you need to use Jet or ADO to do it.sorry, bad link. See this: http://msdn.microsoft.com/en-us/library/aa140015(v=office.10).aspx |
|
|
|
|
|
|
DateTime problem I need HELP