Time for your 3rd Quarter Update! Are you in the running for the 6th Annual Expert Awards? Click the link to find out.

Third Quarter Hot Shots
 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Time Tested Databases Solutions: 2801 - 2822 of 2822
 
Hi all,   I am learning on Multimedia Storage and Retrieval but i am really lost becos i am not a technical person by nature. Can anyone provide me with ideas on how to store A Video Fil...
guys, is there fast and simple way to drop everything I have in the database assume that I don't have the delete scripts ready. what do you do to accomplish this task? This is for Ora...
Hi, i have two tables. total_time contains total time while busy_time contains the busy time (i.e. time which has been assigned).tt_id is PK in total_time and FK in busy_time. bt_id is PK i...
We have upgraded Oracle from 7.3.4 to 8.1.7. A pro*C application is giving core dump in new Oracle environment,but works fine in older verion. This is due to the absence of indicator variabl...
Hi I have 3 lookup tables: Departments (DeptID,deptName) Sections   (secID,SecName) Devisions (DivID,DIvName) the departments contains sections and sections contains devisions i ...
I have the following stored procedure in MS SQL server that I call in VB 6.0 to add data to the table. CREATE proc sp_Add_Premises      @Prem_Name varchar(50),      @Prem_PhysicalAddress ...
I have used this code : Private Sub cmdSave_Click() Dim ctl As Control Dim frm As Form Set frm = Forms!Best   For Each ctl In frm.Controls     If IsNull(ctl) Then        MsgBox "The f...
Hy, Could anyone help me on how I can use SQL to retrieve the AutoIndex number?
I am trying to create a linked server from my SQL server 2000 box to a LINIX box running a microfocus cobol written application. I am using a OLE DB Provider for ODBC Driver, and when I run a ...
I see alot of applications using Adobe Acrobat to print reports how is this done.  I have Adobe Avrobat installed on my computer
I am setting up the conceptual schema (i.e ERD) for a flight reservation database but have found some difficulty when it comes to relating flight schedule tables and seat allocation. What I ne...
When copying from a flat file to a SQL table, how to skip the first line in the flat file?
can u give me the definition of Internet Database Systems and the hardware and software requirements.If can do u have the diagram that shows the hardware in combination with the software. L...
I had the CCRP Datetimepicker in an EXE that registers it and in Access 2000 if used Tools/References and it was there.  Now I across the country and I cannot find it again on the Internet.  I...
can you explain to me following topics: 1. introdction to internet database systems 2. hardware and software requirements for the internet database and diagram for hardware and software requ...
SELECT tblprofiledef.prof_name, tblprofiledef.ptype_name, tblprofiledef.prof_length, tblprofiledef.prof_macros, tblprofile.prof_mark_text, tbllevel.lev_name, tblNest.nest_name, tblNest.nest_to...
I want a sql st which will take the table name as input and give me the colname of primarykey of that table.
Want to manipulate my data in Access and gettind this error: [Timberline][Timberline ODBC Driver][File Library]Timberline ODBC Driver not activated for this application How do I activa...
This is a wierd and bazar thing happening. I have a TEXT field. I copied a large text and pasted it into the field. It seems like it only accepted 1025 chars. Now when i try to delet...
Hi oracle guys, I need to check a varchar for a positive integer with out raising a oracle exception. can someone help me on the best way of acheiving it. this is relating to oracle,s...
How do I achieve procedure overloading say p1 (a,b) and p1(a,b,c) do i need to create a package for this or not??
How do I create am auto increment field in Oracle 9i. I believe it has something to do with triggers but am unable to create or find example code. Thank you in advance