Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedures..
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00305248
Message ID:
00305257
Views:
25
Although, they can be used for many differrent things here is an example of one I did just yesterday. Most of our tables with Prinmary Keys use stored procedures. It is used to automatically icrement the key when inserting to the table. The syntax is just newkey('mytable'). It's really just a callable function built into the table, in this case the Primary Key field. It can be added programmatically or interactively.


>I have absolutely no experience with Stored Procedures and can't seem to find anything useful on the Topic in the VFP6.0 Help.
>
>Would someone be kind enough to give me an example of how to setup one up and then how to use it in an application.
>
>Thank you.
>
>Aaron Young
>Analyst Programmer
>aarony@redwingsoftware.com
Michael Helms

May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me
Previous
Reply
Map
View

Click here to load this message in the networking platform