When I learned programming in Prime Information back in the early
80's, I was astounded at how easy it was to set up a database, add
data, and run reports.

I would like to do that on a web page, and to make this database
securely available to individuals I choose.
For instance, I would like to create a database of all my books, DVDs,
VHS tapes, and record albums, and make it available to my family and
friends on the internet.
I would like to be able to:
1. include book cover images (can I link to Amazon.com's images, or do
I have to store my own?)
2. scan barcodes which would load Library of Congress information
3. allow people to enter their media data on the same web page

I know how to set up a database, but know of no easy way to get it on
the web.
I know there are web sites like delicious-monster.com, but I want to
store my own data, and use my own database fields, and do it in
UniVerse.

On Dec 18, 6:38*pm, Tony Gravagno <nos... (AT) nospam (DOT) invalid> wrote:
One thing I've occasionally had use for is a way to pass an active
list as selection criteria instead of root IDs for the next filename's
query.

If your select list was a list values (contents of some attribute
resulting from a SELECT FNAME ...(criteria)... ATTRNAME) and the
subsequent statement was going to be SELECT FNAME2 WITH ATTRNAME =
"(all of the select list values separated by " )" without having to
write basic to accomplish it.

Doesn't happen often but I've found myself in situations where it
would have been advantageous.

On Dec 20, 1:46*pm, BillH <bhen... (AT) amsservices (DOT) com> wrote:
It's in QM....
SELECT FNAME WITH ATTRNAME IN LISTNAME


Martin Phillips, Ladybridge Systems

Louie...

Years ago I worked on a project internally called MyDB which allowed
anyone with no knowledge of websites or databases to create a MV-based
dataset just like you describe. One of the great features was that
people could exchange data and database schema, and even write code
snippets to operate on their data. The user interface allowed for
creating dict items for reporting, but they weren't called dict items
and the technical aspect of all of that was completely masked. The
process of creating conversions and correlatives was simplified but
anyone with knowledge of the underlying platform could hardcode the
A7/A8 codes.

This environment allowed the MV DBMS to be exposed in a secure way,
and allowed people with interest to learn more about it, and share
expertise (for fun or profit). It was a part of my long-term wish to
make MV as mainstream a platform as MySQL, and give established MV
professionals a completely new market for their expertise and
services.

At the time there were some issues with my choice of technologies, so
I didn't pursue this to production, but the only thing stopping me
from doing this now (again) is lack of time. If someone invested in
my time to realize this environment, I'd jump to work on it. The
service would be offered to the public with a "freemium" model : free
limited services with advertising, expanded services with
subscription. I'm a firm believer that one of the next revolutions in
the use of the internet will be in the sharing of data. We already
share discussions via forums, thoughts via Twitter, pictures and
videos with Facebook and YouTube, and thousands of sites have
validated the model that people like to share things. Now the time
has come to share data, and doing this "in the cloud" is now
acceptable in business and by consumers.

While I wanted that environment to allow users to add BASIC code to
their database, security was a major issue - and this is one of the
reasons why I never finished it. Today, QM and other platforms
support stronger security, so that BASIC code doesn't reach outside of
an account or into the OS. For this reason I'm trying to find some
time to re-visit this initiative.

Personally I'd do all of the above with ASP.NET, but that wouldn't
matter at all to users. For a database I'd probably use lots n lots
of QM environments. For connectivity I'd either use QMClient or (more
probably) mv.NET because of its many advantages. For broad appeal I
might just make this whole thing as a Facebook app. YMMV

So to respond to your note Louie, what you've described is actually
quite easy, but just takes time. For yourself, you can use Viságe,
DesignBais, Pavuk, or one of the other proprietary tools. You can use
mv.NET, UO.NET, UOJ, or others for connectivity, in conjunction with
any mainstream tools like PHP, Java, or .NET website building tools.
If you want a service built and hosted by someone else, based the
familiar MV platform, as familiar as MySQL is to other people, then
you'll have to wait a while.

"louiebergsagel" wrote:

Martin Phillips wrote:


And for D3 I documented a HowTo in my blog:

nospamNebula-RnD.com/blog/tech/mv/2008/03/d3shell1.html

For other platforms I believe shell variables can be used in a similar
way to achieve similar results.

I don't think what you're asking for is now built-in to Unidata, but
someone outside of the DBMS vendors should be able to code it, and
even make it work using the IN LISTNAME syntax that Martin provides in
QM.

T

"Tony Gravagno" <tony_gravagno (AT) nospam (DOT) invalid> wrote

How does I go about changing the way the uniData command line parses?

And then, how to hook in my new code to handle the select list?

I didn't know that it was possible for third parties to extend uniData
command line... are you thinking about a wrapper for SELECT?

--
frosty

On Dec 21, 7:11*am, "frosty" <fros... (AT) bogus (DOT) invalid> wrote:
Surely you jest? I thought that WAS the whole point of HAVING things
operate via a VOC/MD entry, so that you COULD easily extend base level
functionality. Next thing you will be telling me you have never
written your own replacement for OFF or LOGTO

Ross Ferris wrote:

^^^ What he said ^^^

People do this in Linux and Windows all the time. There are Design
Patterns named after this technique (Façade, Adapter, others). The
OOP concepts of inheritance and derived classes have abstraction like
this at the core. So why are Pick people adverse to such things?

In D3 I override BASIC with COMPILE and I customize that and other
verbs to always flash-compile my code. In QM I setup a dozen aliases
to make my environment more like D3. The tools exist so that we can
do exactly these things.

So yeah, BP SELECT and SSELECT get catalogued, you parse the
SENTENCE(), and if it includes syntax like "def IN listname" then you
pre-process it, otherwise you pass the command (minus verb) to the
base command, something like (O for Original) OSELECT or OSSELECT.

T

On Dec 20, 10:51*am, "louiebergsa... (AT) yahoo (DOT) com"
<louiebergsa... (AT) gmail (DOT) com> wrote:
Take a look at Pavuk (www.pavuk.com) for an easy way to build web
applications.


Martin Phillips, Ladybridge Systems.

"Tony Gravagno" <tony_gravagno (AT) nospam (DOT) invalid> wrote

already-active select list.