I've got a tool that I wrote years ago that takes an open table and scripts it to a VFP Create Table or an MSSQL Create table.
Also one that creates SQL Select statements for an open alias and Insert statements (That last one is buggy)
If you're interested, I could send you the code.
On 09/02/21 7:05 AM, Alan Bourke wrote:
In MSSQL you can script a table out to a Transact SQL script, including all CREATE statements and multiple INSERT statements for the data.
Is there a VFP equivalent that anyone knows of? This is for including test data in source control, it's better to have a PRG that can generate the database than adding binary DBF files etc.