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
ahmed elweshahy
-4
Newbie Poster
Recommended Answers
Jump to Posthi,
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 …
All 2 Replies
Reply to this topic
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.