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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement