ghiehotamares
Programmer
Hi All,
Can you give me sample code/explanation, I have MS SQL Table with data records, I want to display records once I enter and click search button in my sample data entry form(VFP Form data entry Textbox).
How can I call the script/stored from sql server database to display these records from data entry Form, I want to update/edit/delte existing records and append new records to sql table using connections string & data entry Form, I am not yet expert in sql stored procedure, can you give explain sample stored proc backend & to be called in the front-end.
Samples form.scx
DESIGN DATA ENTRY TEXTBOX
--------------------------
ENTER PRODUCT CODE : text1 SEARCH Button --> to display existing records from sql table back-end. If not existing enter
new records to be appended in the back-end table using data entry form.
PRODUCT DESCRIPTION : text2
QUANTITY : text3
UNIT PRICES : text4
TOTAL AMOUNT : text5
SAVE BUTTON CANCEL BUTTON
* records should be updated or insert once click save button
Appreciate your response.
Thank you.