Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OLEDB Flush ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00618437
Message ID:
00619771
Vues:
18
>>It smells like the OLEDB driver is not flushing anything, even after 70,000 rows. What can I do to make the driver actually write to the table?
>
>(recordsetobject).Update?

I am not using a RecordSet Object. Here's what I'm doing (doit.vbs):
Set oCacheConn = CreateObject("ADODB.Connection")
With oCacheConn
  .ConnectionString = "Provider=VFPOLEDB.1;Data Source=mydbc.dbc"
  .CursorLocation = 2	'	adUseServer
  .Mode = 16		'	adModeShareDenyNone
  .Open
End With
oCacheConn.Exec("Create Table mytable ( tRowCreated t(8) Null)")
For iNo = 1 to 70000
  oCacheConn.Exec("Insert Into mytable (tRowCreated) Values (DateTime())")
Next
Where can I put something in there to flush to disk? What is getting bad is the fact that even if something breaks at row 69000 I still have nothing in the .dbf.

Thanks.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform