Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLEDB Flush ?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00618437
Message ID:
00619771
Views:
17
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform