On 5/26/05 6:19 PM, "Robert Brenstein" <[EMAIL PROTECTED]> 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] _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution