Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing a table from OleDb
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01153964
Message ID:
01217374
Vues:
10
Where?

>Doesn't work for me. I keep getting "Function argument type, count or value is invalid"
>
>
>lcStr = "SELECT 0"+CHR(13)+CHR(10)+"USE Test EXCLUSIVE"+CHR(13)+CHR(10)+"INDEX ON Fld1 TAG Test"
>IF NOT DIRECTORY("c:\test")
>   MD ("c:\test")
>ENDIF
>CREATE TABLE c:\Test\Test (Fld1 I)
>EXECSCRIPT(filetostr('c:\test\test.txt'))
>DELETE TAG all
>CLOSE ALL
>STRTOFILE(m.lcStr,"c:\test\test.txt")
>oAdoConn = CREATEOBJECT([ADODB.Connection])
>oAdoConn.ConnectionString = [Provider=vfpoledb.1;Data Source=c:\test\;Collating Sequence=machine;]
>oAdoConn.Open()
>
>oAdoComm = CREATEOBJECT([ADODB.Command])
>oAdoComm.ActiveConnection = oAdoConn
>oAdoComm.CommandText = [EXECSCRIPT("SELECT 0"+CHR(13)+CHR(10)+"USE Test EXCLUSIVE"+CHR(13)+CHR(10)+"INDEX ON Fld1 TAG Test")]
>oAdoComm.Execute()
>
>BTW, how can I find out the VFPOleDB version? I use VFP8 here.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform