how to append a field

[charlotte49er]

I need to append a field to a dbase file using ado. I'm attempting to accomplish this with the code below but the field is not added and I don't receive any errors. Would someone offer some help/suggestions? Thanks.

		Set oRS = Server.CreateObject( "ADODB.Recordset" )
ors.Fields.Append "Index", adChar, 255 , adFldIsNullable

 

[Olaf Doschke]

You are just appending a field to the recordset. To alter any database via ADO, you need an ADODB.Connection and an ADODB.Command to send some database specific ALTER TABLE command to the database.

I assume you use VB and want to add a field to a VFP DBF file?

Bye, Olaf.