Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simulating Xactions
Message
From
25/01/2007 12:44:38
 
 
To
25/01/2007 12:38:20
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01188628
Message ID:
01189310
Views:
9
>>>I'm not sure if you're getting it clear from what Cetin is saying. You can have a dbc with views only, and the underlying tables for those views can be your free tables.
>>
>>I think I twigged last night when I thought back on't. Do you/does he mean views that are like, say:
>>
>>"Select * from X into ViewName"
>>
>>i.e. the view becomes just a virtual copy of the table, with SendSQLUpdates?
>
>Exactly. Still not sure whether it'd be possible to wrap that into a transaction, but if Cetin says so, I figure it would be.
>
>You may also try to do the same with just cursors for copies of the data, and roll your own
>
>update myfreetable set fld1=value1, fld2=value2... where ...
>
>statements and wrap those in a transaction. It'd be practically the same, and you'd have more control over the where clauses. The trade off is in not bothering with creating the views (which may be good for you, if the structures of the tables vary, and you only care about a few fields), but you pay for that by having to roll your own where clauses.

Roger that, thanks.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform