andrewducker: (Default)
[personal profile] andrewducker
I use VFP a lot. It's a fantastic database, and I I use it occasionally to extract reports for some people in Kent who use it to keep track of neonatal care on a system I wrote, some years back.

I was getting some data off just now, and wanted to check I was pulling off the right info. I wanted to get the SQL output to them, (and was chatting to the person who wanted it over MSN), but couldn't think of a super easy way.

Until I remembered that VFP has a 'save as web page' option, that saves SQL output in a dead simple HTML table. So I saved it into the web directory, checked the URL worked, pasted it into MSN, and they were able to look at the data 3 seconds later.

This is fantastic. I can do RAD a lot easier if the people down there can check my results as I go along. Saves me pulling off tons of data only to find it's not quite right.

March 2026

S M T W T F S
1 2 34567
891011121314
15161718192021
22232425262728
293031    

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Mar. 4th, 2026 05:49 am
Powered by Dreamwidth Studios