Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems updating VFP DatabaseTables
Message
 
À
28/10/1999 20:17:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00283429
Message ID:
00283931
Vues:
13
>>I have opened a VFP 5.0 Table with VB 5.0. It opens up & I can see all that data. However, if I try an update type command, i.e. Update, AddNew, Edit, etc. I get Runtime Error 3027 "Can't Update. Database or object is read-only".
>>
>>I know that this Directory & all Tables in it are NOT readonly. I have tried other .DBFs & get the same result. Is there some secret to this? Right now, I'm just using a Data Control. I tried Code earlier, when I started having the problem.
>>
>
>What is a data control?
>
>Have you made sure that you have read/change rights as far as the network goes? There is no secret switch or anything...
>
>can you make changes to the table in the command window?

Let me first say that I am attempting this in VB, not VFP. There is a not a "Command Window" in VB that I know of. I can update the table in VFP, not problem. The data control I spoke of is a Common Control that comes with VB.
I can now Update the Table using the Data Control, but no not DAO code. I am not on a network. Table is local. My Table Open codes is:

Dim dbAPSS As Database
Dim rsCust As Recordset

Set dbAPSS = DBEngine.Workspaces(0).OpenDatabase(App.Path, False, False, _
"FoxPro 3.0")

Set rsCust = dbAPSS.OpenRecordset("Cust2", dbOpenTable)

My probelm, still is when I use the Update method, I get an error message that Table it read only.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform