Oracle has no integer type. Just use number(9). Also, getting maintenance transferred to the data owner is a very good idea.

>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.