Hello,
This is my first time dealing with importing remote data via a view into FoxPro. This can be very useful for me if I can get it to work. However, I am running into a problem. The status bar shows the records appear in the table. The TableUpdate() returns .T. triggering a message that the update succeeded (for testing). However, when I attempt any action involving the table, browse, Do While loop, or refresh grid, the status bar updates to zero records and no records are available. viewlocalrequestqueue is a remote view of a table on an Oracle server.
Form Init
USE FoxLocalRequests.dbf ALIAS FoxLocalRequests exclusive
=cursorsetprop("buffering",5,"FoxLocalRequests")
SET MULTILOCKS ON
Timer
Select * From viewlocalrequestqueue Into TABLE FoxLocalRequests
Select FoxLocalRequests
=TABLEUPDATE(1,.T.,'FoxLocalRequests','myArray')
IF TABLEUPDATE()
=MESSAGEBOX("Table update succeeded.")
ELSE
=MESSAGEBOX("Table update failed.")
Endif
browse
To add to my confusion, if I run the following in the Command window:
Select * From viewlocalrequestqueue Into TABLE FoxLocalRequests
BROWSE
the records are there. I also tried this by using an array as an intermediary step and received the same results.
This is my first time dealing with importing remote data via a view into FoxPro. This can be very useful for me if I can get it to work. However, I am running into a problem. The status bar shows the records appear in the table. The TableUpdate() returns .T. triggering a message that the update succeeded (for testing). However, when I attempt any action involving the table, browse, Do While loop, or refresh grid, the status bar updates to zero records and no records are available. viewlocalrequestqueue is a remote view of a table on an Oracle server.
Form Init
USE FoxLocalRequests.dbf ALIAS FoxLocalRequests exclusive
=cursorsetprop("buffering",5,"FoxLocalRequests")
SET MULTILOCKS ON
Timer
Select * From viewlocalrequestqueue Into TABLE FoxLocalRequests
Select FoxLocalRequests
=TABLEUPDATE(1,.T.,'FoxLocalRequests','myArray')
IF TABLEUPDATE()
=MESSAGEBOX("Table update succeeded.")
ELSE
=MESSAGEBOX("Table update failed.")
Endif
browse
To add to my confusion, if I run the following in the Command window:
Select * From viewlocalrequestqueue Into TABLE FoxLocalRequests
BROWSE
the records are there. I also tried this by using an array as an intermediary step and received the same results.