Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
USE myview NODATA... and VFP ask for parameters???
Message
From
06/01/2000 13:22:56
 
 
To
06/01/2000 12:43:53
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00313345
Message ID:
00314021
Views:
53
You can use a cursor created by SQL as the recordsource for a grid- I do it all the time.

>Erik,
>
>How about you want to use the view as a RecordSource for a Grid?
>
>Just a thought
>
>Rex
>
>>>Dear friends,
>>>
>>>I will try to answer to all...
>>>
>>>My code for the view is:
>>>
>>>select az.codArm, az.descricao, aaz.lote, Sum(aaz.quant) ;
>>> from tabAtAz aaz inner join tabAz az ;
>>> On az.stamp = aaz.st_tabAz Where aaz.st_tabAt = ?st_Artigo ;
>>> GROUP BY az.codArm, az.descricao, aaz.lote ORDER BY az.CodArm, aaz.lote
>>>
>>
>>I'm not sure wshat is causing the problem- I've never run into it because I have never tried to create a view with a GROUP BY clause. If your view does not need to be updatable, why not just use a plain ol' SQL query?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform