Universe has the ability to create programs and subroutines on the server
that are written in Basic. These subroutines can be associated with field
names to give you calculated or virtual fields. But like any complex
programming envirnment, it takes time and effort to learn and become
proficient in it. The Universe documentation has a volume on Basic
programming, you can study that and then check out some source code on your
server to get an idea hoe it works. I am sure it took you a few years to
state " ...simple DDL and DML commands.." I have no idea what DDL and DML
means just as you don't know on how to work with Universe, its commands and
programming language. It takes time and dedication. Personally I find the
Basic language much more powerfull and complete then SQL.
With Delphi you can use UniObjects as API to access Universe. You still can
have your heavy lifting done on the server through the subroutine object.
Martin Scholl
----- Original Message -----
From: "Anita Panda" [EMAIL PROTECTED]
To: <[email protected]>
Sent: Friday, March 02, 2007 1:18 AM
Subject: [U2] Universe Basic questions
I am very new to Universe Basic Database...Please clarify the following as
it could be of very much help to me.
1)Whether we can create stored procedures,functions in this multivalued
database system as we create in SQL.How do we create because it doesnot
recognize SQl keywords to create procedure,But it executes simple DDL and
DML commands.I had put forth some of my queries in the discussion forum
about the same....there I got a reply stating that all application logic
is
written within the database engine.If it is so then how is it written in
the database engine ....is it by Universe Basic language(which I am not
aware off)or any other way.Please help me out to avoid all these
confusions.
2)I had worked in an application having Delphi as the front end and SQL at
the backend ...its a simple design....But when we have Delphi at the front
end and Universe Basic at the Backend,can we create the stored procedures
at the backend or it has to be handled from the front end or any other way
to create and execute the stored procedures and stored functions in
Universe Basic Data base.Please suggest some links or sites which can help
me to smoothly understand Universe Basic.Thanks
Thanks and Regards
Anita
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/