|
-
Aug 15th, 2001, 12:20 PM
#1
Thread Starter
Junior Member
appending field to recordset
ADO HELP:
Dim rst As New ADODB.Recordset
rst.Fields.Append "xx1", adInteger
rst.Fields.Append "xx2", adChar, 5
rst.Open "test",strcon,adopendynamic,adlockoptimistic,adcmdtable
rst.addnew "xx1","test"
rst.update
get an error on rst.addnew "Item cannot be found in the collection corresponding to the requested name or ordinal."
it seems that the xx1 was not appended.
So how will the fields show up in the database. Can someone give me sample code to append fields to my database.
and
how do you create a mdb database in ADO?
in dao it is simply the createdatabase(path)
in ADO how do you do this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|