Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Stewart Chew
  Where is Stewart Chew?
 
 Malaysia
 Stewart Chew
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Insert & Update records
Thread ID: 145129 Message ID: 145800 # Views: 20 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, September 19, 2007 2:39:21 AM         
   


> >
> >
> > Dear Ken,
> >
> > Can you help me to verify my coding, please refer to the attachment;
> >
> > http://www.foxite.com/uploads/9845dff4-f0df-4f7a-b08f-5b0a475e761c.zip
> >
> > i need your advise.
> >
> > Thanks.
> >
> > Regards,
> >
> > Stewart Chew
>
> Stewart,
>
> The first thing I note is your GetNewKey() function. You are using VFP 9, so just make your key fields autoinc fields. Let VFP handle the new key assignment for you. I also note that you do not unlock the record in that function. If you lock a record or table, you MUST unlock it, or other users will never be able to add a new record.
>
> In your CmdGrid.PRG, you are programmatically creating a form and a button class. Why not just build the form and class visually and then run them? It would be a lot easier to maintain. They call it Visual FoxPro for a reason.
>
> As to your forms, I cannot open them without your skin classes.
>
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

Dear Ken,

Below attachment is my skin classes.

http://www.foxite.com/uploads/16613d09-ad81-45f1-be28-abeb9395241f.zip

Regards,

Stewart Chew



COMPLETE THREAD
Insert & Update records Posted by Stewart Chew @ 9/13/2007 8:47:55 AM
RE: Insert & Update records Posted by tushar @ 9/13/2007 10:12:55 AM
RE: Insert & Update records Posted by Stewart Chew @ 9/13/2007 11:33:53 AM
RE: Insert & Update records Posted by Ken Murphy @ 9/13/2007 12:40:19 PM
RE: Insert & Update records Posted by Stewart Chew @ 9/18/2007 3:54:33 AM
RE: Insert & Update records Posted by tushar @ 9/18/2007 11:44:22 AM
RE: Insert & Update records Posted by Ken Murphy @ 9/18/2007 2:12:41 PM
RE: Insert & Update records Posted by Stewart Chew @ 9/19/2007 2:39:21 AM
RE: Insert & Update records Posted by Ken Murphy @ 9/19/2007 2:55:43 PM
RE: Insert & Update records Posted by Stewart Chew @ 9/20/2007 4:18:16 AM
RE: Insert & Update records Posted by Ken Murphy @ 9/20/2007 1:45:31 PM
RE: Insert & Update records Posted by Cetin Basoz @ 9/20/2007 2:05:02 PM
RE: Insert & Update records Posted by Ken Murphy @ 9/20/2007 2:14:16 PM
RE: Insert & Update records Posted by Cetin Basoz @ 9/20/2007 2:26:32 PM
RE: Insert & Update records Posted by Ken Murphy @ 9/20/2007 2:43:10 PM
RE: Insert & Update records Posted by Cetin Basoz @ 9/20/2007 2:00:53 PM