SQL worker objects

Das Goravani das at Goravani.com
Sun Jan 28 14:57:43 EST 2018


HI, and thanks for this. However, I only wanted those two things, really one thing, explained to me, what is in binds1, what is in it, it’s a list I know, what is on the lines of the list exactly…the naming indicates they are. Bind variables, but I don’t know why they need to be in a list there, and how they are syntax formulated, your code is hard to understand, it’s rich, and it’s large, I like the manuals example, it’s understandable, if only I knew what those bind variable lists do, if they have multiple lines or only one, why they are there, how they work into the SQL, all about them I need to understand. They make no sense to me as they appear in the example
>> 28 jan. 2018 kl. 02:46 skrev Das Goravani <das at goravani.com>:
>> Given this code from the Manual
>> Do work.$definefromsqlclass('scWork')  ;;scWork is defined as query(char) and
>> bindvars(list)
>> Do work.$add('select * from table1 where col1 < @[binds1.col1]',binds1).   <-------------------------
>> Do work.$add('select count(*) from table1',)
>> Do work.$add('select * from table2 where idCol >= @[binds2.idCol]',binds2).   <-------------------------
>> Do work.$add('select oneCol from table3',)
>> Do initRow.$definefromsqlclass('scWorkInit') ;;scWorkInit is defined as
>> hostname(char), username(char), password(char) & work(list)
>> Do initRow.$add(lHostname,lUsername,lPassword,work)
>> Do iWorker.$init(initRow) Returns #F
>> Do iWorker.$start() Returns #F
>> What does the list of binds1 and binds2 actually contain
>> Where binds1 and binds2 appears in the where clause, what do they mean, being there, and matching the list
>> I basically don’t get binds1 and binds2
>> I have heard of and seen bind variables in select statements but am not clear on their syntax 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com

More information about the omnisdev-en mailing list