IonicWind Software

IWBasic => Database => Topic started by: Brian on December 31, 2011, 09:46:35 AM

Title: Database Viewer
Post by: Brian on December 31, 2011, 09:46:35 AM
Hi,

I was just looking round at some of my old stuff, and came across this offering
from Fletchie, so I calafudged it a bit for IWB

Load up an MDB file, select a table from the lefthand listbox, select a field to
display from the righthand listbox, and then press Try it!

Your selection is displayed at the bottom of the screen, and the data is put
nicely into the listview

Have fun!

Brian

Slight mod: Added ShowSelectionAlways and Gridlines to listview. Program updated

Another mod (kludge): You can now type in your own sql expression and then use the
Manual Try it! button to see the result

Last mod: Added some colour, moved the buttons to more logical places,
and put in sql error checking when using the Manual Try it! button


Title: Re: Database Viewer
Post by: Doc on December 31, 2011, 03:36:33 PM
After d0ing some system maintenance and re-installing IWB2, I decided to try out your code Brian, but ran into a problem needing Fletchie's "ctl.inc" file. I've searched high and low on the hard drive as well as on my backup USB drive, but am unable to find it.

...doing a search here on the forum netted me 14 pages of results, which I prefer not to wade through. Can someone point me to a copy that might be easy to find? Please?

Best regards,
Doc

Edit:  Problem solved!!!  -- Thanks Bill   ;D
Title: Re: Database Viewer
Post by: Brian on January 01, 2012, 03:34:13 AM
Glad you solved the problem Doc - I saw your message at nearly midnight last night,
so it was a bit late to do anything about it!

Anyway, I have attached my version of the Control Pak, as there were one or two,
and I was in a lot of contact with Ian, and I probably have his latest version

Brian
Title: Re: Database Viewer
Post by: Doc on January 01, 2012, 10:40:09 AM
Thanks Brian! :)
Title: Re: Database Viewer
Post by: Brian on January 04, 2012, 11:28:46 AM
Hi,

Program updated - download again from first post

Brian