SQL Search in API-Way

[Ruslan Zasukhin]

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.

 
> Happy Easter,

Happy Easter to all!


-- 
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]