Member Avatar for ahmed elweshahy

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

  • 2 Contributors
  • 2 Replies
  • 84 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by manoshailu
Member Avatar for manoshailu

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

Member Avatar for manoshailu

hi,


i attached a file with this for ur requirement.

it could be useful to u.


shailu

howto_dao_add_delete_tables.zip (7.58 KB)
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.