SQL command in a macro against a view

[sblocher]

Can i execute a SQL command in a macro to create a recordset from a view rather than using .Browse/.Fetch in a loop? If so, is an example available?

 

[zemp]

I don't believe that you can throught the COMAPI or the xAPI. However you can add parameters or criteria to the browse statement so that you return only a specific portion of the view. This would remove the need to loop trough (if your criteria are specific enough) the entire view.

Otherwise you woould have to use ADO and go directly to the database. Not recommended because the views hold the business logic and prevent data corruption.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[sblocher]

As i suspected, unfortunately. I can make do with .browse parameters and a loop. Thanks! And thanks, in general, for your excellent replies to many questions on the forum.

 

[zemp]

Thank you for the kind words. I am glad to be helpful.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."