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

[ghiehotamares]

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.

 

[fredericofonseca]

This really isn't anything to do with SQL Server but rather with your end user tool - VFP on this case.

Asking on Microsoft: FoxPro -

https://www.tek-tips.com/threadminder.cfm?pid=184

is probably your best bet on tek-tips.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886