For this particular project, this will get done once a quarter. But I will have similar projects coming down-the-line, so what I thought I'd do was make an .asp admin page and let operations guys do the table creation, etc. Then I'd have a VFP COM object do the table creation, etc. I thought it would be better to go that route to get maintenance off of me and I'd also have code ready for VSS.

One thing I haven't seen yet is how to declare an integer when creating a column in a table/view in Oracle. What is the syntax for that? I was trying

cString = 'create table sitesc (iID integer(9) primary key)'
nResult = sqlexec (gnHandle , cString)
? cString
? nResult

And I keep getting the -1 error (table didn't create).

Also, have you worked with parameterized views inside of SQLExec?



Thanks again!






>Are these database modifications just one time mods? I do not use VFP to make changes to the database. All my work on the database is done from SQL*Plus and script files. That way, if all is lost, I can re-create my database by re-running my script files. This will not replace any data, but I now have database documentation in these script files.
>
>When I make changes to the tables, add new tables, create views, etc., I also include these changes in my script files.