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.

October 2025

S M T W T F S
    1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 161718
19202122232425
262728293031 

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Oct. 16th, 2025 02:10 pm
Powered by Dreamwidth Studios