Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Kent Jensen
  Where is Kent Jensen?
 Las Pinas
 Philippines
 Kent Jensen
 Tags
Subject: RE: Data Environment
Thread ID: 47725 Message ID: 80899 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Friday, November 04, 2005 6:07:02 AM         
   


> what about when saving the record, i usually use append blank and gather memvar memo
>
> how can i use the append blank and gather memvar memo to the "cursor", in "sql select command" i have to use "insert into" to save a record is there a way i can use the gather memvar memo.
>
>
> > a cursor is normally created with the create cursor command OR with a SQL select command.
> > Like in: Select * from mytable where fieldXYZ=somevalue into cursor MyCURrentSetOfRecords.
> >
> > You can then select the cursor with the name you just gave it.
> >
> >
> > Boudewijn LutgeĀ®ink
> > My Blog is here
> >


Sorry to say but I never work this way. I have table buffering on in my forms (2 - optimistic) and datasession set to private. If I make changes to the fields of a record I can update the table with tableupdate(), and revert any changes with TableRevert(), this also works on views...
Oh, and before I forget, posting a reply once is sufficient.

Boudewijn LutgeĀ®ink
My Blog is here


ENTIRE THREAD

Data Environment Posted by Tom Thomas @ 7/27/2004 11:00:59 AM
RE: Data Environment Posted by Boudewijn Lutgerink @ 7/27/2004 11:45:05 AM
RE: Data Environment Posted by Tom Thomas @ 7/27/2004 12:08:51 PM
RE: Data Environment Posted by Andy Kramek @ 7/27/2004 1:01:11 PM
RE: Data Environment Posted by Tom Thomas @ 7/27/2004 2:35:51 PM
RE: Data Environment Posted by Andy Kramek @ 7/27/2004 3:51:56 PM
RE: Data Environment Posted by Kent Jensen @ 10/20/2005 8:00:55 AM
RE: Data Environment Posted by Andy Kramek @ 10/20/2005 1:28:07 PM
RE: Data Environment Posted by Kent Jensen @ 11/2/2005 5:56:47 AM
RE: Data Environment Posted by Boudewijn Lutgerink @ 11/2/2005 7:18:44 AM
RE: Data Environment Posted by Victor @ 11/2/2005 4:22:03 PM
RE: Data Environment Posted by Ken Murphy @ 11/2/2005 6:03:11 PM
RE: Data Environment Posted by Kent Jensen @ 11/4/2005 4:00:02 AM
RE: Data Environment Posted by Boudewijn Lutgerink @ 11/4/2005 6:07:02 AM
RE: Data Environment Posted by Kent Jensen @ 11/4/2005 4:03:13 AM
RE: Data Environment Posted by Ken Murphy @ 10/20/2005 3:28:45 PM
RE: Data Environment Posted by Jerzy Kopinski @ 10/20/2005 9:14:50 AM
RE: Data Environment Posted by Terry Bottorff @ 10/21/2005 5:55:03 PM
RE: Data Environment Posted by Jerzy Kopinski @ 10/24/2005 7:25:36 AM