Re: How to autogenerate a number in VFP 6?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Altman (NotGiven_at_SickOfSpam.com)
Date: 03/16/04

Next message: Stefan Wuebbe: "Re: How to autogenerate a number in VFP 6?"
Previous message: Trey Walpole: "Re: NVL"
In reply to: Gary: "How to autogenerate a number in VFP 6?"
Next in thread: Stefan Wuebbe: "Re: How to autogenerate a number in VFP 6?"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 16 Mar 2004 10:20:48 -0600

typically how this is done is to have a table that stores the last used
number and then have a function in your stored procedures that will read
this data update it to the next number and return that number. If you're
doing this for creating primary keys this is how you'll have to do it until
you get to to VFP 8 which has an autogenerate built in.

Next message: Stefan Wuebbe: "Re: How to autogenerate a number in VFP 6?"
Previous message: Trey Walpole: "Re: NVL"
In reply to: Gary: "How to autogenerate a number in VFP 6?"
Next in thread: Stefan Wuebbe: "Re: How to autogenerate a number in VFP 6?"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: New buffer overrun info
... Though the background calls to Stored procedures sounds interesting. ... the other when there's a corrupt index file. ... I ran into something like this in VFP 6. ... but messageis correctly set. ...
(microsoft.public.fox.programmer.exchange)
Re: New buffer overrun info
... One of them, my take on NextIdno(), is called quite often. ... Though the background calls to Stored procedures sounds interesting. ... I ran into something like this in VFP 6. ... but messageis correctly set. ...
(microsoft.public.fox.programmer.exchange)
Re: Performance issues
... very key to optimizing performance with the Rushmore technology for VFP. ... This where clause will recognize that there exists an i index on the ... Only VFPOLEDB can call stored procedures. ...
(microsoft.public.fox.vfp.dbc)
Re: FoxPro Stored Procedures
... Do you have an example of executing this stored proc via oledb? ... in a Vfp view definition or SQLPassThrough statement you ... > For Vfp stored procedures have a look at the examples shipped ... e.g. in the IDE command window type ...
(microsoft.public.fox.helpwanted)
Re: FoxPro Stored Procedures
... > I am a SQL server developer but have never used Foxpro. ... > Select EmployeeID, JobID, Date, TimeIn, TimeOut ... in a Vfp view definition or SQLPassThrough statement you ... For Vfp stored procedures have a look at the examples shipped ...
(microsoft.public.fox.helpwanted)