RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
m] On Behalf Of Ajoy Khaund Sent: 24 June 2014 19:00 To: profox Subject: Re: Data Entry Form using Sql Server & SPT Thanks Dave. So are controls on the form like textboxes bound to the cursor or Thisform.oData_Obj ? Ajoy Khaund On Tue, Jun 24, 2014 at 9:15 PM, Dave Crozier wrote: > Fi

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Ajoy Khaund
Dave > > > > > -Original Message----- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund > Sent: 24 June 2014 15:51 > To: profox > Subject: Re: Data Entry Form using Sql Server & SPT > > Dave, > Thanks for the write up. I got it goi

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Stephen Russell
On Tue, Jun 24, 2014 at 9:51 AM, Ajoy Khaund wrote: > Dave, > Thanks for the write up. I got it going. There were some hiccups ofcourse. > > How do you create a data object? > > Do you create a class with all fields of the table as properties? > > - You might consider making a

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
The scatter should be on a new line obviously... Dave ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchab

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
[mailto:profox-boun...@leafe.com] On Behalf Of Ajoy Khaund Sent: 24 June 2014 15:51 To: profox Subject: Re: Data Entry Form using Sql Server & SPT Dave, Thanks for the write up. I got it going. There were some hiccups ofcourse. How do you create a data object? Do you create a class with all

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Ajoy Khaund
My vfp forms connected to master tables are been coded using this method. I have the controls on a pageframe on the first page with Add,Edit,Delete,find & navigation buttons. In my second page I have the data in a grid of main columns. More then one page I have for say products table etc. Thanks

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Ajoy Khaund
Dave, Thanks for the write up. I got it going. There were some hiccups ofcourse. How do you create a data object? Do you create a class with all fields of the table as properties? Please let me know as I want to make the same form in all the ways possible and then choose which I like best. Init

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
I meant CursorAdapter not Table Adapter ... too much using C# the last few months!! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of AndyHC Sent: 24 June 2014 12:12 To: profox@leafe.com Subject: Re: Data Entry Form using Sql Server & SPT

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Eurico Chagas Filho
I use views for all tables that I need to open. Each form has a pageframe, the first page opens a grid that shows, say, all customers in order chosen by the header of the columns. In this first page there three buttons, select, new and exit. In the second page that comes up, in the bottom, there ar

Re: Data Entry Form using Sql Server & SPT

2014-06-24 Thread AndyHC
Dave Crozier +1 - you could also consider using a CursorAdapter [as a data object]. There is a builder available, and as VFP Help! suggests: see Data Access Management Using CursorAdapters . --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- k

RE: Data Entry Form using Sql Server & SPT

2014-06-24 Thread Dave Crozier
Ajoy, The usual procedure of using a "data object" which is an object containing the current, or in the case of a new record, a blank set of data is used. You do the changes to the data object by binding the object properties to the form controls (textbox etc) and then you can freely manipulate

Data Entry Form using Sql Server & SPT

2014-06-23 Thread Ajoy Khaund
Hi Folks, In my vfp apps in a form I generally have a Add & Edit button along with navigation buttons. On clicking on Add btn say an append blank is issued. The caption of Add & Edit button changes to Save & revert... How are you all approaching this with back end servers. Say to enter da