Hello,
I administrate a large number of Oracle databases for my company.
Some DBs are easily structured and the staff responsible for keeping
them updated are able to use an Oracle client (SQirreL, PLSQL/
Developer, or even MS Access as a client) to directly access Oracle
and update their tables (without messing around with integrity etc).
Other DBs are too complex in their structure or the staff responsible
for data updating are not able to handle with SQL and have no skills
in working directly on DB objects...
For the later case I wish I could offer them a foolprof'ed, user-
friendly web-based tool for updating data (enter new data; update
existing data; delete data).
I dream of a generic web-based DB-maintenance application which
enables to:
- configure your application by naming the tables, the relations
between them, the constrains, etc, and you get on the fly an
application that enables you to browse from master to slave table, to
move from record to record and from column to column and edit/delete/
insert data in/from/into them.
- perform checks (data type, domain constrains, etc) using the info
from the data dictionary.
- perform pre-defined plausibility checks.
- supports data capture helps like drop-down-lists for foreign keys,
check or radio buttons for flag-columns.
- etc etc etc.
This is something I would love to develop myself... if I only had the
time!
I wonder that (at least as far as I have been able to google around)
there is nothing like this on the market!
Best regards from Bonn, Julian
1  1542 
Hi,
Oracle has a tool they call APEX (Oracle Application Express) that
provides a user-friendly RAD environment for building databases: http://www.oracle.com/technology/pro...ess/index.html
In the web application space, there are applications such as
caspio.com and quickbase.com that allow users to create web-accessible
databases.
Regards,
John Peters
On Nov 21, 10:16 am, jimenezkra...@g ooglemail.com wrote:
Hello,
I administrate a large number of Oracle databases for my company.
Some DBs are easily structured and the staff responsible for keeping
them updated are able to use an Oracle client (SQirreL, PLSQL/
Developer, or even MS Access as a client) to directly access Oracle
and update their tables (without messing around with integrity etc).
Other DBs are too complex in their structure or the staff responsible
for data updating are not able to handle with SQL and have no skills
in working directly on DB objects...
For the later case I wish I could offer them a foolprof'ed, user-
friendly web-based tool for updating data (enter new data; update
existing data; delete data).
I dream of a generic web-based DB-maintenance application which
enables to:
- configure your application by naming the tables, the relations
between them, the constrains, etc, and you get on the fly an
application that enables you to browse from master to slave table, to
move from record to record and from column to column and edit/delete/
insert data in/from/into them.
- perform checks (data type, domain constrains, etc) using the info
from the data dictionary.
- perform pre-defined plausibility checks.
- supports data capture helps like drop-down-lists for foreign keys,
check or radio buttons for flag-columns.
- etc etc etc.
This is something I would love to develop myself... if I only had the
time!
I wonder that (at least as far as I have been able to google around)
there is nothing like this on the market!
Best regards from Bonn, Julian
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: dawnunder |
last post by:
eg.
Someone fills out 3 fields. (There will be more but this is just to
give you an idea)
1. Country?
2. State?
3. City
I want this script to generate a web page and list the people by
|
by: Edward Diener |
last post by:
Version 2.0 of the Python database API was written over 5 years ago, in
1999. While it has been used successfully by many implementations, there is
no generic access into the data dictionary of relational databases except at
the table column level. I am working on some Python which would hopefully
give me a form of generic access to more common data dictionary
functionality such as indices, constraints etc. but no such functionality...
|
by: Steven Bethard |
last post by:
So I'm trying to get a prototype implementation of the 'generic object'
type. (I'm currently calling it 'bunch', but only because I can't
really think of anything better.) I'd like some feedback on what
methods it needs to support. Ideally I'd keep this as minimal as
possible...
Remember that the goal of the 'generic object' type is to allow the
programmer to make the design decision that attribute-style access is
more appropriate...
|
by: SimonH |
last post by:
Hi all,
I would like to make a generic set of methods that could be called regardless
of the database behind the scenes.
One of the methods I would like would take a string sql statement and an
array of DataParameter objects.
The problem i have is there doesnt seem to be a generic DataParameter class
that I can instantiate. There only seems to be specific implementations like
|
by: John |
last post by:
Hi
I have two identical databases A & B with several tables. Each table has an
ID and a timestamp. Is it possible to write a generic procedure that will
take the table name (as it is same in both dbs) and the names of the two dbs
and update tables in db A from corresponding tables in db B depending on
which record is most recent? I am just trying to avoid writing code for each
of the tables.
Thanks
| | |
by: Aya9877 |
last post by:
Alright, I have no idea what level book I need.
I have a basic/decent background in coding. I am advanced in query
building. I have a decent understanding of Visual Basic and some VBA.
My problem is design structure. Where to begin, etc.
I see that everyone recommends The Access 97 Developer's Handbook (I
am looking for a Access 97 book), but is that going to be too advanced
in terms of getting a db off the ground? I am thinking I...
|
by: .Net Newbie |
last post by:
I'm new to .Net and need to create a generic (free) way to update lookup
tables in SQL Server (using C#) in ASP.Net pages. I found an article at:
http://www.dotnetjunkies.com/Tutorial/0C968B48-44E8-4637-9F19-8490B0429881.dcik
which explains how this can be done but does not supply enough example code
my newbie self to go through in detail where I understand it. So, does
anyone have some example code I could use to accomplish this or know...
|
by: shapper |
last post by:
Hello,
I am getting various records from a database:
Dim ds As DataSet = db.ExecuteDataSet(dbc)
Each record has 3 fields: Id, Name and Text.
I have a class named MyClass with 3 properties Id, Name and Text.
|
by: Cirene |
last post by:
Using Visual Studio I created a DataSet using the GUI (XSD file).
Trying to use a tiered methodology I called the functions from my BLL.
Namespace Zzz.BusinessLogicLayer
#Region "DAL Access"
Public Class States
Public Sub New()
End Sub
|
by: phancey |
last post by:
I want to define a class like this
class MyClass
{
List<TMyList<Twhere T : IMyList {get; set;}
}
or something like this. I don't want to put <Ton my class definition
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
