Thank you BNPMike.
I will probably just write the DDL by hand as you recommended. However, is it possible to export the tables directly from ACCESS into an Oracle database?
Thanks,
Jason
Hi,
I am wondering how to save an SQL
script including all the SQL involved
in creating 4 tables in a database.
I.E. How do i already have 4 tables
in an ACCESS 2000 db, and i would like
to drop and recreate the tables. How do
i get the SQL script on how to do that?
Thanks
Hello,
I have 4 tables in ACCESS 2000.
I want those 4 tables, and all their correct field types and definitions to be in Oracle 9i. How would i do this?
Can i directly import into Oracle, or can i save the SQL script for creating the tables from ACCESS, and run it into Oracle??
Thanks,
Jason
Hello,
First of all, jdbgmg.exe is still on my c drive. I guess I never deleted it all together, it kept reappearing on me. I dont want to reintall my OS if the file was not even deleted.
Second of all, I use IE due to its popularity. If I were to use any other browser for debugging, I am...
Hello,
I still cant get my IE 6.0 sp1 to recognize javascript errors, which makes it very difficult to debug my script programming. Please help...
Does anyone know of any 3rd party software for IE60 that would recognize and help me debug javascript errors. I know VisualInterdev helps on my...
Thank you for your help.
I will use varchar for select lists, etc so I can avoid any mishap by forgetting to use the trim() function. I will use char for state abbreviations, zipcodes, etc where there is a set length (2,5,etc)
However, I do notice a significant increase in execution speed...
Hello,
If I am just inserting a simple select list field from an HTML form into my SQLTable, should I use the datatype char, or varchar? What is the difference, and is one more beneficial than the other?
Thanks,
JHill
Hello,
I am running IE 6.0. I develop using javascript and the automatic javascript error messages in the status bar to help me debug my applications. However, something happened, and i dont get those error alerts anymore. For instance, now, when there is a javascript error, the page just...
Hello,
When I right click on a table in SQLServer70 Enterprise, and select open table > return all rows, I am getting the following error:
An unexpected error happened during this operation.
[Query] - Query Designer encountered a query error:
Unspecified Error
DOes anyone have any idea what...
ALready reinstalled IE60.
You know, there was an email I got a while back telling me that jdbgmg.exe was a corrupt file adn how to delete it. So I did, and realized that the description of the file was "Microsoft® Debugger Registrar for Java". But, eventhough I deleted it, it is...
Thank you Lrnmore,
IE60sp1 > Tools > Internet Options > Advanced > Browsing > Disable Script Debugging is not checked and Display a notification aabout every script error is checked.
Is this what you mean?
Thanks,
Jason
Hello,
I dont know what I did, but all of a sudden, I dont get javascript errors to show up in the status bar anymore while I'm developing with javascript. This was a great debugging tool. It would tell me that an error occured, what the error was, and what line it occured on. A little...
Hello,
I dont know what I did, but all of a sudden, I dont get javascript errors to show up in the status bar anymore while I'm developing with javascript. This was a great debugging tool. It would tell me that an error occured, what the error was, and what line it occured on. A little...
Hello,
I want to develop web apps on my home computer running WIn2000 Professional. Is WIn2000Pro equipped to develop on my localhost without having to publish over the internet? What is the best way to go without upgrading to Win2000 Server? Do I need to download MS Personal Web Server...
Hello,
Can I do this? And how?
I want the user to be able to view a certain web page for a duration of 7 days.
The user is allowed to enter into my SQLServer70 table the day they want to start viewing the page.
Based on the date entered, the preexisting URL (http://myserver/nopage.htm) will be...
Thank you dmhirsch,
So, you are saying that overall, I should use "nvarchar" over just "char"?
This will allow foreign characters in my table?
Thank you,
Jason
Hello,
I always use "nvarchar" as datatype in SQLServer70.
SOmetimes, I wonder if there is a difference between "nvarchar" and just "char".
What about "int" and numeric"?
Just wondering what is better for sentences as values.
Thnaks,
Jason
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.