Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to call stored procedure to display records in fron-end data entry

Status
Not open for further replies.

ghiehotamares

Programmer
Mar 9, 2019
7
PH

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top