Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffered table is not refreshed
Message
From
28/12/2000 05:47:13
 
 
To
28/12/2000 03:45:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00457255
Message ID:
00457263
Views:
20
RECALL does not works in VFP through views. This because no such command in the SQL. You cannot recall record using UPDATE SQL command, but only this command used when updating. You can only insert new record instead of old record that deleted. To assure recalled by such way record have the same ID Key value, change old record id to some new ID # and than insert new record with old id #.

HTH.

>Hi,
> I am using table buffering for all of my forms. I set private datasession to my forms too.
> I have a simple test that:
>
>1. I launch 2 instances of my EXE.
>2. Look up same record in both instance from mySearchform and display data in data entry form. The frmSearchForm will be released.
>3. I delete the record selected in either one of the instance (e.g. 1st instance).
>4. After deleted, I go to 2nd instance and save the selected record which selected. Once My update function detected the record was deleted by other user, it will ask for recall. If user select "YES", it will reall and update it.
>5. The step 4 just work fine. Then, I launch my frmSearchForm again (same instance with step 4), I found the record I recalled just now in the grid.
>6. However, I cant found the recalled record in my 1st instance (which delete the record).
>
>I issue
>
>mySearchForm.INIT()
>USE myTable AGAIN SHARED
>CURSORSETPRO("buffering",5)
>
>mySearchForm.UNLOAD()
>USE IN myTable.
>
>Why the data in 1st instance doesn't refresh?
>
>Thank you
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform