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
