SQL Search in API-Way

[Chuck Pelto]

On Apr 16, 2006, at 8:12 AM, Ruslan Zasukhin wrote:

> On 4/16/06 4:58 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:
>
> Hi Chuck,
>
>> Morning Ruslan,
>>
>> Sorry to bother you on this day of celebrations, however, I wanted to
>> ask a question that will be gnawing at me all day, unless I ask it
>> now. And I'd rather be focused on this day's feast....
>>
>>
>> What is the syntax for an SQL search against an API-Way developed
>> V4RB2 database?
>>
>> sqlSrchText  = "SELECT recID, * FROM tblQandA WHERE field1 =  '" +
>> data1 + "' AND field2 = '" + data2 + "'" // where tblQandA is a
>> VTable created as in tblQandA = tDatabase.CreateTable("QandAs")
>
> Do you ask how to do this SQL query using API way ?
>
> Your code to build SQL query looks correct.

EXCELLENT!!!!

Now, come tomorrow morning, I can get into that aspect with a vengeance.

>> Happy Easter,
>
> Happy Easter to all!

Regards,

Chuck Pelto
[He is risen, indeed.....]