Search results

@isladogs I don't build apps any more. I have never used 64 bit. What would I need to do to be able to make the demo simultaneously 32 and 64 bit enabled? I don't know that I have a huge need to do this thing, though I am willing. I would think that any devs using 64 bit would be able to...

Events form an "asynchronous" interface for doing things. I am teaching how to use events, and frameworks. I could teach how to use public subs I suppose, but most devs know that already. Not necessarily true with using custom classes and events. I wrote a framework which, when a form...

I have a new blog up about clsMsgPD which is a predefined or predeclared class which I use to pass messages around. In this case a client asked me to create a "big edit" form. The user could dbl-click into any text box following a naming convention and doing so would open a form with a single...

I think this is a geo database, not the one I was trying to import.

Welcome @chgeiselmann. A lot of us started as self taught, myself included. Many of us continue that way. This board is a great resource for real world experience from helpful folks.

:)

The file is a 36gb download for the text download. I can't just append it to a message here. And that is zipped.:eek:

@Gasman How can I PM you?

It took me hours to download, although my internet down speed isn't particularly speedy.

https://www.transportation.gov/gis/national-address-database

BCP was unable to handle the very common field data like Peoria,,,"Country Meadows Units 5, 6, & 7",,,,,,AZ, With field delimiters of "" and inside that comma delimited strings. Failed to import every record with such data and there were a ton of them. So BCP kinda worked but not well...

Having done that I successfully pulled in several million records out of (apparently) somewhere around 60 million addresses. I got some dat from around 20 states, many just a few thousand records. Some states with tens or hundreds of thousands of records. My guess is that those states were...

What I don't have is it imported into SQ Server! To use BCP I had to go into the ini and manually copy the ini field lengths into the BCP field mapping thingie. Thingie is a very scientific term I picked up somewhere. :ROFLMAO:

I have a schema.ini

I have an xml file

I have a text file. It appears to be a csv file.

What is this? And how do I use it?

IIRC it is a 36 gb file. Compressed. However I might have it in a usable format already. Do you know what GDB files are?

I know for a fact that the data heavily used "" around commas in long strings. From my reading BCP does not have a switch to tell it to ignore that. I managed to pull in about 3.6 million records by telling BCP to use a batch of 10K (write every 10K) and ignore a million errors. It was...

Sometimes it is important to know stuff just because. If you ever want to insert records to "fill in a hole", recover archived records etc, you probably want to run another query that finds the highest PKID, increments by one, and inserts that record as well. This allows the autonumber to...