Trust me, if I could graph out of SQL I would, but we had to bully our customers into SQL from dBase in the first place. One step at a time . Anyways, I officially submit a feature request for CSV groups in FactorySQL!
After a bit of googling and experimenting, I found a way to do it with SQL server. It is not very pretty as it opens up some huge security holes, but it works. You need to create a stored procedure that looks similar to:
exec master..xp_cmdshell 'bcp <database>.<owner>.<table out C:\<path>\<to>\<file>\<filename>.csv -c -t, -T -U<sqluser> -P<password> -S<server>'The gaping security hole is from enabling the use of xp_cmdshell, which basically allows the SQL server to execute anything that you could do from a command line.
Anyways, hopefully this is useful for someone. I’ll be using it for sure, since I don’t care about the security hole as all our databases we ship are isolated from everthing except the machine it’s collecting from.
Back to my original goal: Where is the changelog for FSQL 4.2.0? Or should I wait until it is up in the portal?