I have a sysbase 12 stored procedure that has two cursors declared which are nested. I have modified the @@fetch_status
tests to the MSQL server equvilants but it is still producing unexpec...
Dear All,
Here is the scenrio.
In the form 6i
1- We use a non database block
2- And apply some dml(insert,delete,update) in database
3- when we commit it gives either of the above two m...
Could someone please enlighten me on the issues and seriousness of keeping transitive dependencies in a database. More specifically, are transitive dependencies a necessary component of some ...
i m using oracle 8i datbase. the db is in archive log mode. the archive log list contains too much files. Since the data is commited and saved into datafiles, and i want to delete oldest archi...
hello everybody;
I have a master detail form and I have a toolbar canvas that contain a button that is used to delete a record the trigger on that button is :
Do_key('delete_record');
c...
I have two select statements joined together by a union. But if one table does not have the constraints then no data is returned from either table. What can I do to fix this??
Dear Experts,
Can I create any complicated Reports with
Data Report of VB6?
(According to the Input, Connecting 4-5 tables)
Is it possible?
Can anybody give example procedures to
gen...
Hi guys.
I got an Access frontend for a MS SQL backend. One of the query is running so slow so I decided to use view instead. To reuse the old code, I created a linked table to that view. The...
I'm having problems with a procedure that i want to implement in my database .... Oracle 8
I created a procedure for the database but the triggers don't work..
Here is my procedure ...
...
Hi all,
i'm having trouble querying sharepoint from dotnet
first i tried using classic ADO
--
ConnectionClass connection = new ConnectionClass();
CommandClass command = new CommandCla...
I having another 3134 INSERT syntax problem. I can't figure out what's wrong here.
====================
DoCmd.SetWarnings True
...
I have a large table in Excel...around 212 columns by 1000 rows...each column is a stock symbol, each row is a date...
I need to convert this into a rows table to bring into an Access databas...
hi,
i am hoping to do the following - export a list of all tables and their fields, for a particular schema in an Oracle 8i database, into a text file.
i can use the command select * fr...
Resources: Two non-system tables are available,
abc_tbls (with 1 column, table_name), and
abc_flds (with 2 columns, table_name and field_name).
Requirements: A sql script to return ...
Hello EVeryone,
I'm working on a a critical report and I was forced to used MS-ACCESS over ORACLE. Now I'm stuck with a basic select statement. Anyway, to make a long story short, I want ...
trying to start an online banking project, but not sure what technologies to use. Was thinking of using MySQL along with a java based middle tier and probably using jsps as well. Thinking of u...
For those of you who support one of these ERP solutions below or others, please tell me of your perspectie/experiences and rate from a scale of 1-10 on how well you like your ERP system overal...
I have three table
supplier(sid,sname)
part(pid,pname,color)
catalogue(sid,pid,cost)
I want to find the sname of suppliers who supply EVERY RED part
My query is as the follow :it doesnt...
From my job defination table I have (dbms_recat.do_deferred_repcat_admin("ABI"', FALSE);
what is the right setting to be there,false or true?.
How can I fix this error...when i double click on my .mdb file I get the following error instead of the database application running... db comes up saying the command or action "windowHide" is...
SQLPLUS spool question.
I have to spool data so that it has following particulars
1. linesize is 1700 characters
2. pagesize is zero
everything is working fine but I get the first li...
I have been testing Log Shipping and everything looks fine with the exception of one thing.
Our transaction logs continue to grow each day and do not apear to be truncated by the log backup...
hy
I am trying to develop a system where a client using vb6 accesses a sql server on a dial-up PPP network.
The server is not automatically detected and really need some help on how to ...
Hi, i'm designing a online sports centre booking system using mySql. I would appreciate your input with regards to the design of the database. Currently i have identified the following tables:...
Hi,
I'm a novice in Oracle , and I hope that somebodycan help me on this subject.
I've migrated an application running on IBM DB2 and using EBCDIC collating sequence to Oracle
The app...
