Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete a range of record in Oracle
Message
 
 
To
08/03/2001 16:38:40
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00483333
Message ID:
00483353
Views:
7
>We are using VFP6 SP4
>
>We have a need to do 2 things:
>1. Delete a range of records from an Oracle table using VFP6.

See SQLStringConnect or SQLConnect, and SQLExec to delete.

>2. Append records from a VFP table into an Oracle table, no checking needs to be done here. Just an append from type process.

Create a remote view of the Oracle table, then --

use MyView nodata
CursorSetProp('buffering', 5, 'myview')
append from vfptable
? tableupdate(.t., .t., 'myview')
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform