🚀 go-pugleaf

In article <349166DE.339E@corp.borland.com>, kmayer@corp.borland.com says...
> Gerald Fay wrote:
> > The sql designer in VDB7 is giving me problems. And as you know SQL is
> > where it is at in VDB7.
> 
> Gerald -- just a point -- you don't _have_ to use SQL commands much, and
> don't need to use the SQL builder or .SQL files. It's certainly a way to
> do anything in dBASE, but it's (like usual) not the only way ...
> 
> > My greatest difficulty is the inablity to get any return with using the
> > LIKE compare.
> 
> > For example under criterion field I enter a character field by dragging
> > from the database, choose like as the compare and enter a value in the
> > third column. When running the query I get notified "Database Error.
> > Operation not applicable".
> 
> What does the SQL look like that's being streamed out? 
> 
> Ken
> 

Ken with the new database objects it appears we will need to use SQL quite a bit.
The Borland extra CD is obviously prodding us in that direction.
Some instruction on how to set filters, order, etc in the new model would be of value. It 
appears the generated code when using data objects does not do the traditonal:

Select A 
Use Custinfo

But uses the dbf as an object (especially with browse grids)
How do you order a grid?
How do you filter a grid?

I know it will be logical. I'm just dumb. But I'm willing to learn!