Search found 8 matches

by jfwhite
Thu Nov 23, 2017 5:30 am
Forum: Databases
Topic: Sanity Check
Replies: 10
Views: 7207

Re: Sanity Check

Thanks, I'll pick this back up on Friday - can't wait to dig in. Goodnight and enjoy your Thanksgiving.
by jfwhite
Thu Nov 23, 2017 5:15 am
Forum: Databases
Topic: Sanity Check
Replies: 10
Views: 7207

Re: Sanity Check

No but I am fluent in SQL and thought it would make constructing the export files easy, especially if the specs change in the future. In doing more reading it seems like getting the tab separated input files into a data grid would then make it easy to get into the db tables. But I'm very open to any...
by jfwhite
Thu Nov 23, 2017 4:55 am
Forum: Databases
Topic: Sanity Check
Replies: 10
Views: 7207

Re: Sanity Check

Not large, maybe a few k, but probably 20+ columns each.
by jfwhite
Wed Nov 22, 2017 9:56 pm
Forum: Databases
Topic: Sanity Check
Replies: 10
Views: 7207

Sanity Check

I have a project that shouldn't be too hard and I will learn a lot, but I want to be sure I have a solid concept. The requirement is to read two text files, then export combinations of that data into three different text files. I think the easiest way would be to import the data into a SQLite databa...
by jfwhite
Thu Dec 06, 2012 8:42 pm
Forum: User Groups and Events
Topic: Oklahoma
Replies: 7
Views: 8227

Re: Oklahoma

There's at least one more of us in Tulsa! I'm a database programmer by day, keep swearing I'll write some useful apps using LC at night but just getting motivated again. I was a Hypercard geek back in the day, but this is so much more. I'd be happy to let anyone bounce ideas off me if I can do the s...
by jfwhite
Thu May 17, 2012 9:31 pm
Forum: Windows
Topic: Populate list of local DSN's
Replies: 7
Views: 6742

Re: Populate list of local DSN's

I couldn't get Mark's code to return the data I need (although it did work fine for other registry keys), but the shell approach worked fine. Now I have several entries like: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\OSUMC_BI Driver REG_SZ C:\Windows\system32\SQLSRV32.dll Server REG_SZ osumc-boedged...
by jfwhite
Thu May 17, 2012 5:24 pm
Forum: Windows
Topic: Populate list of local DSN's
Replies: 7
Views: 6742

Re: Populate list of local DSN's

Thank you - that is good to know and it works to pull the value of a specific key. But I described the requirement poorly. What I really need is the listing of key names. For instance, when I click on ODBC\ODBC.ini\ODBC Data Sources in the registry tree, the right pane displays the listing of DSN na...
by jfwhite
Wed May 16, 2012 9:22 pm
Forum: Windows
Topic: Populate list of local DSN's
Replies: 7
Views: 6742

Populate list of local DSN's

I need to be able to populate a dropdown list with the names of all local DSN's. This is contained within the registry key:

HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/ODBC Data Sources

Now what? :roll:

Go to advanced search