🚀 go-pugleaf

Steve Koterski wrote:
> 
> What does "does NOT work" mean, exactly? You're getting an error message?
> No error, but no or incorrect results?

Sorry about that!  It was giving me an error "data type mismatch"
I knew it could be done but not the syntax.

> 
> One potential problem I see is that the date literal (represented by your
> sdate variable) winds up with no delimiting quotation marks. Local SQL
> requires that date literals in SQL statements be surrounded by quotation
> marks. I would suggest a change something like:
> 
>   results.query1.sql = 'SELECT * FROM dbmaint.dbf WHERE (unit_num = ' +
>   unit + ') AND (entrydate >= "' + sdate + '")'


This was exactly what i was looking for!!!  it works great and I learned
something.
Now all I have to do is learn about a million other thing and I'll be
able to 
convert my programs to vdb7.

I thank you a lot for your help..

Mike Kikrland