I need to create a record group at run time that consists of customer names. Users will select the customer name from the LOV and it will be displayed in the text item. This is the reqd. fu...
how to rename user in oracle
i already created user ,now i want to rename that user..
how??????
i tried this but it givs error...eexecute smp_maintenance.reset_sysman();
I have an update statement that updates a few columns of a user table in one of our many production databases running on SQL 2000 SP3. The statement runs fine on the same table of a developmen...
I am just a beginner in Oracle, so be easy on me. I want to create a table in oracle with a primary key that is set up to auto number. For example, each time I create a new record the primar...
I'm using DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT in procedure A on X database forcing the transaction to use a particular rollback segment
I'm calling this procudure from B procedure on Y da...
Hi All Experts,
I want to do the connection from web server to Database server with MS BackOffice Server 4.5 Developer Edition, MS SQL Server 7.0.
when I tried to connect from the web s...
Hi
My problem is this.
I require user to select more than 30, more than 60 or more than 90 days from a combo box.
ASSUME that user select 30 days, on execution my SQL will select o...
I have a database access and trying to input records via an asp page.
When i click on the save button. i got the following message
Microsoft Jet Database Engine error "80040e09"
Cannot ...
Hi
Can any body help me in Sorting this problem.
Whenever i open a previously compiled Report I am getting the following error.
Error Rep- 1247 : Reports Contains Uncompiled PL/S...
Hi,
could someone tell me what is a fish pond diagram and where all can it be applied?
Also, some more URLs/pointers to more information would be appreciated.
Thanks
Regards,
Harmit
Hi all
First post so be gentle :)
I've currently got a temp job building an Access DB for client to include details of various contacts, site names etc. This will be used to craete batc...
I have image file img.jpg. I want to insert into SQL 2000 database through VB.
How can I do this. Does any image file format(i.e. jpg,bmp,tif,gif) can be stored in database.
Thanks.
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 ...
Hi,
In SQL (SQL server 2000), % and _ are treated as wildcard in query.
My question is how can I use escape so that the query will treat a char such as '%' and '_' literally?
For examp...
I having another 3134 INSERT syntax problem. I can't figure out what's wrong here.
====================
DoCmd.SetWarnings True
...
I have an old database that a friend of mine used for storing addresses and booking details, within the addresses part there is an option to print out envelopes and also in other parts of the ...
I am using a table in with the columns are decimal datatypes (28,18) . The issue occures when i try to do a mathimatical operation.The data after a certain decimal gets lost.
The effect of da...
I have a vb program that increments values in a table by "moving to the first record" that contains a "1" and increments values until it finds the next record that contains a "1". Here is th...
I have searched and to this point found nothing on this! I have investigated display labels, the print statement, etc.
I want my SQL query to unload the header row at the top of the file. H...
