StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Can you ZAP or PACK a vfp free table through BO?
Can you ZAP or PACK a vfp free table through BO?
Post Reply
Like
0
Can you ZAP or PACK a vfp free table through BO?
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Marcel Heitlager
Marcel Heitlager
posted 15 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 84,
Visits: 835
Hi,
I'm trying to delete all the records in a VFP free table. Doing the deleting is no problem, but I want them permanently deleted, like ZAP or PACK.
Can you do something like below but with the PACK or ZAP command? I know it's a stupid question but I'm stuck.
thanks,
Marcel
Dim LoConn As New OleDb.OleDbConnection
LoConn.ConnectionString = MicroFour.StrataFrame.Data.DataLayer.DataSources("myKey").ConnectionString
LoConn.Open()
Dim loCommand As New OleDb.OleDbCommand("SET DELETED OFF", loConn)
loCommand.ExecuteNonQuery()
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Can you ZAP or PACK a vfp free table through BO?
Marcel Heitlager
-
15 Years Ago
OK,
So I did some more digging and did the obvious thing...
Marcel Heitlager
-
15 Years Ago
Hi Marcel, Are you sure your table is open EXCLUSIVE?
Michel Levy
-
15 Years Ago
You will have to open the table exclusively, but there is more. You...
Trent L. Taylor
-
15 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search