Isn't this code for creating tables wrong ???

toptime

Private Sub Command1_Click ()
Dim conn2 As New ADODB.Connection
Dim sqlstring As String
Dim connectionstring As String
connectionstring = "provider = Microsoft.Jet.oledb.4.0; data source = default.mdb"
conn2.Open connectionstring
sqlstring = "create table aaa (a varchar (50), b number (10,3), c number (10,3))"
conn2.Execute sqlstring
'conn2.Execute "commit"

End Sub


Why is it always saying syntax error in creat table ???
What is wrong with this sqlstring?

maggic

Number is wrong.

create table aaa (a varchar (50), b money, c money)

This can replace

toptime

So if I have a date and it has a format, such as 2017-01-01, how can I get it?

I remember when I learned sql in oracle, number (10,3) was used like this ... Why not work here?

Thank you!

maggic

datetime

maggic

Or use the varchar type directly-the comparison and query conditions use the long date format, it is also possible.

charrrr

create table #aaa (a varchar (50), b numeric (10,3), c numeric (10,3))

select *
from #aaa

Try it, there is no problem at all. numeric is correct. Ah

charrrr

Also, if you encounter such a problem, you can copy the string to the query analyzer and try it, and it will report the error.

maggic

Access databases don't have a query analyzer, and Access doesn't support that many data types.

lz's connection string already stated
> provider = Microsoft.Jet.oledb.4.0; data source = default.mdb

Upstairs, such as mdb, still can not be executed.
create table aaa (a varchar (50), b numeric (10,3), c numeric (10,3))




Comparison or mapping of data types between Access databases and projects
http://www.hackhome.com/2005/1-15/20341716338.shtml

追梦神童

create table aaa (a varchar (50), b numeric (10,3), c numeric (10,3))
2 data types do not exist in acess
should be
create table aaa (a string (50), b double, c double)

charrrr

Sorry, I did not look carefully, it is access.