--- In [EMAIL PROTECTED], Alex Peters <[EMAIL PROTECTED]> wrote: > --- Erik wrote: > > > Does anyone know whether there is any way of launching SQL queries > > (against SQL Server in my specific case) and then being able to walk > > through the returned recordsets, all this using PP? > > Can your SQL server write its output to a text file if it's called? > Can you specify your queries as command line parameters to the server? > > If the server outputs the results to a DOS box then this can be piped > to a text file, which PowerPro can subsequently process. > > Cheers, > Alex > > ICQ# 37414292
Yes I could indeed take the hardcore approach and do everything by hand and do my own parsing. I was however looking to something more generic and integrated such as ODBC support: I was hoping that someone would tell me this was either built in or in a plugin. This would open a whole new realm of possibilities! There are also ODBC drivers to handle CSV files, XL files, etc... So havhing something like this would now allow integration with databases but also use SQL querying with text files. Erik. ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/JV_rlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/power-pro/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
