syntax error in CREATE TABLE statement
to create recordset i write the following statement:
db.Execute "CREATE TABLE myTable(Sname text (10),Code number (5)) "
is this statement true or false
Please i want help
thank you

Recommended Answers

All 2 Replies

hi,

ur coding is write. bt u said u have some error. ok. try below coding

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Command1_Click()
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open "daniweb", False, False
cn.Execute "create table daniweb(eid text,ename text)"
End Sub

regards
shailu

hi,


i attached a file with this for ur requirement.

it could be useful to u.


shailu

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.