Forums Últimos mensajes - Powered by IBM
 

Pack y Zap using VFPOLEDB.1 (ADO - OledDb provider)

23/12/2005 - 15:52 por Jiug | Informe spam
According to Microsoft documentation there is a list of Supported Visual
FoxPro Commands and Functions in OLE DB Provider

http://msdn.microsoft.com/library/d...9093f8.asp


Pack and Zap commands are supported by OleDB, for instance:

// Pack works perfectly

AdoCnn.Open; //Open Connection
AdoCmd.CommandText:= 'Pack myTable'; //myTable.dbf
AdoCmd.Execute; //Execute Command
AdoCNN.Close; //Close Connection


But ZAP command is not working or at least I dont know how it woks. Anybody
can help me with this ?

I GET AN ERROR WITH THIS: "Command contains unrecognized command
phrase/keyword" . It´s obvious I´m using the zap command in a bad way.

AdoCnn.Open; //Open
Connection
AdoCmd.CommandText:= 'ZAP myTable'; //myTable.dbf
AdoCmd.Execute; //Execute
Command
AdoCNN.Close; //Close
Connection
 

Leer las respuestas

#1 Carlos Alloatti
23/12/2005 - 22:00 | Informe spam
But ZAP command is not working or at least I dont know how it woks.
Anybody
can help me with this ?

I GET AN ERROR WITH THIS: "Command contains unrecognized command
phrase/keyword" . It´s obvious I´m using the zap command in a bad way.

AdoCnn.Open; //Open
Connection
AdoCmd.CommandText:= 'ZAP myTable'; //myTable.dbf
AdoCmd.Execute; //Execute
Command
AdoCNN.Close; //Close
Connection






First do a Set safety off and see if that works or:


Help file:

Issuing ZAP is equivalent to issuing DELETE ALL followed by PACK, but ZAP is
much faster.


So try using that

Carlos

Preguntas similares