Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Urgent :: Want to add a column to Foxpro table
Message
De
07/08/1998 09:16:52
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Urgent :: Want to add a column to Foxpro table
Divers
Thread ID:
00124744
Message ID:
00124744
Vues:
63
I am using Foxpro 3.0 tables,
I want to add a column, so I used .Fields.Append .CreateField
but not able add the column. It says database is readonly

The code,


Dim db As Database
Dim rss As Recordset
Dim tbldf As TableDef
Dim gk As Field
Dim noflds As Integer

Set db = OpenDatabase("d:\temp111", True, False, "Foxpro 3.0;")
'Set rss = db.OpenRecordset("exptab1", dbOpenDynaset)
Set tbldf = db.TableDefs("exptab1")

Debug.Print db.Updatable
Debug.Print tbldf.Updatable
If tbldf.Updatable Then
tbldf.Fields.Append tbldf.CreateField("vedula", dbText, 50)
End If

db.Close
Répondre
Fil
Voir

Click here to load this message in the networking platform