Conceptual database questions...

[Ruslan Zasukhin]

On 5/26/05 6:19 PM, "Robert Brenstein" <rjb at robelko.com> wrote:

>>> However, I think you really mean to ask about using the direct API
>> versus >SQL for working with data. Using SQL, you can do the same
>> without >explicitely creating cursors. You should not mix these, though,
>> and use >either direct API or SQL.
>> 
>> I did not see a non-SQL way of adding records in the docs for vxcmd. Did
>> I miss something, or do we mainly need to rely upon SQL techniques?
>> 
> 
> check out AddRecord and AdddRecords in record methods.
> 
> In the latter case, make sure to explicitely provide delimiters.

Actually VXCMD 1.x provides you SQL way which have 2 branches:

A) using only INSERT, UPDATE, ... SQL commands.
    
    me personally do not like this way because you need
    at first build SQL string in YOUR code.

B) using 
    Vcursor.AddRecord()
    Vcursor.UpdateRecord()
    ...

This is mix of SQL way (because you use SELECT query to build cursor)
    and API way, because you use functions to do some commands.


Again, in Valentina 2.0 we introduce totally new way:

* API way.    

    this way absolutely do not use SQL.
    How it will work?

    you will have such functions as
        Field_FindValue( v)
        Field_FindRange( true, v1, v2, true )

You will get access to new Valentina 2.0 feature  LINKS.
In 2.0 we have not only FOREIGN KEY as link between 2 tables but also
    
    2) ObjectPtr field
    3) BinaryLink.  -- Valentina unique feature.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]