Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL passthrough
Message
From
19/09/2002 08:51:37
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
 
 
To
19/09/2002 08:40:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00702210
Message ID:
00702217
Views:
13
>Hi,
>
>Is there a possible way on how to fetch up to date records from a base table using sqlpassthrough?
>
>An example is if you modify or add a record in a table manually using the command window of visual foxpro then executing sqlexec() function, the records that were modified or added are not included in the new query...
>
>This is weird but I really need to solve this problem....
>
>
>Thanks in advance....
1 do eqlexe with select to table
set update properties for this cursor similar to remote view
Do any manipulations with cursor at client side ( add/update , etc) and add after any manipulation =tableupdate(.t.)
and this is all
MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.
Previous
Reply
Map
View

Click here to load this message in the networking platform