Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with tableupdate & remote views
Message
From
30/01/2002 10:44:42
 
 
To
30/01/2002 05:24:42
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00611955
Message ID:
00612743
Views:
26
Actually, I came up with a different idea that works fine.

Instead of using a SQL Server view, I created the equivalent SQL call as a SQL server stored proc.

So now, instead of going through 3 layers, VFP SQLPT Cursor->SQLServer View
->SQL Server Table, it's straight from the VFP SQLPT Cursor to the SQLServer table, which seems to agree with VFP, since it now, with no further ado (?), produces the correct results.

Thank's people!

>before you make Insert/Replace, open a new SQL connection handle,
>and close the handle after made the operation.
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform