Form design in visual FoxPro

How to Data add/ edit into table by form design by visual FoxPro.
Pl. Guide me. I have no idea for form design.
Sir, i have made input screen @ raw, column say command but I want to develop this screen by form design. But I don't know how  data  add/edit into table.
Suppose iname var. Content replace in name field. How form design add
If form design add / edit simple tutorial aavine pl. Send me
Thanks
Mukesh JaniAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mukesh JaniAuthor Commented:
I want to make form design input screen in visual FoxPro
Data add/edit into table
0
pcelbaCommented:
jrbbldr proposed Garfieldhudson's videos in your previous question already: https://www.experts-exchange.com/questions/29079479/i-want-to-make-exe-file-in-visualfoxpro9-prg-file-pl-help-me.html#a42443992

Did you watch these videos? Did you try to create a form based on these videos? What exactly is unclear?

Optionally, you may try to use Visual FoxPro Form Wizard (available in menu Tools / Wizards). It will show simple UI where you can select all basic features of the form.  Use the Wizard just in the case the generated form fully fits to your needs. I would not recommend any manual updates in the generated form because the code is rather complex. Garfieldhudson's videos are much simpler to understand.
1
jrbbldrCommented:
Personally I would recommend that you DO NOT USE  the Visual FoxPro Form Wizard to create your User Input Form.
Yes it might quickly give you a VFP Form to use, but you would end up not knowing anything about how it was made nor how it might work.

Go to the Free Garfield Hudson VFP Tutorials and learn how to make your form.

EDIT:   I notice that you say:
i have made input screen @ raw, column say command
The @ Row,Column Say/Get approach is the OLD non-Visual Foxpro approach.
I recommend that you Do Not use that, but instead use a true Visual Foxpro Form as shown in the Garfield Hudson videos.

Good Luck
1
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Mukesh JaniAuthor Commented:
sir
  i just tried simple data add in coomand button in form design as following

USE TALLY
APPEND BLANK

REPLACE NAME WITH TEXT1
RETURN

when i run  form
 variable not found   message display
pl. give idea
hope for response
0
jrbbldrCommented:
It sounds as though you have not watched the Free, On-line GarfieldHudson VFP Tutorial Videos or if you have then you have not watched them all the way through.

Again I would however recommend that you DO NOT use a FORM WIZARD to build your Form.  
Doing it that way gives you a Form quickly, but it doesn't teach you anything about how it works and it also ends up with a lot of code that the WIZARD 'thinks' is needed, when it may only confuse things.    

Build your Form from 'Scratch'
CREATE FORM MyForm
< now add Form objects from the Form Designer tool bar >
< write code into the various Form object's Properties Methods as needed >

Open in new window

so that you can get it to do only what YOU want it to do and you can actually LEARN what is going on.

If you have created a VFP Form (by 'Scratch') and put a button on it, that's good, but what have you also put onto the Form for the user to input the data ('text1') ?

Then when your button is pushed its onClick method code needs to 'read' the text box value so that it can be used as the value to put into your table field.

Watch the all of the tutorial videos so that you can understand ALL of the parts.
Building a Simple Application - Pt. 1
Building a Simple Application - Pt. 2
Building a Simple Application - Pt. 3
Building a Simple Application - Pt. 4
Building a Simple Application - Pt. 5
Building a Simple Application - Pt. 6

Good Luck
0
Mukesh JaniAuthor Commented:
Input text box cannot read my data. What i do for read data.

I crate text box and I write code by command button click event.
Use tally
Replace name with text1

Error variable not found.
Pl. Give idea
I watched video by yours.
Hope for response
0
pcelbaCommented:
Just to explain what your code does:

Use tally  ... opens the tally.dbf table in the current workarea and sets record pointer to the first row. (SET DELETED may take into effect here.)

Replace name with text1  ...  replaces the column named "name"   by  column named  "text1"  or  by variable named  "text1".

If you don't have such column/variable then the error appears.

So you should tell what's your goal.

BTW, to replace column named "name" by value from the textbox named "text1" and placed on the form you may write:

Replace name with THISFORM.text1.Value
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mukesh JaniAuthor Commented:
Sir, As per your guide line my problem solved.
Thanks you so much.
0
Mukesh JaniAuthor Commented:
I am very grateful to you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FoxPro

From novice to tech pro — start learning today.