--- In [email protected], "Shawn K. Hall" <[EMAIL PROTECTED]> wrote:
> Hi Chris (Ha! You used your name!),
LOL
> I wouldn't. Instead, I'd just use something like this:
Even though I have been writing DB apps in VB6 for about a year
now, I am still pretty much in the dark on how to implement SQL
statements in the code. I remember you all showing me a while back
so I guess if I search the messages I can find the references I need.
What this particular program does is retrieve a member id and
first and last name from a text file then searches the DB to see if
it already exists in the DB. If it does NOT then it is written out
to another file to be processed.
Once I figure out how to implement the SQL statements properly I
think I will be on the correct path! It has to be a lot faster since
it currently takes about an hour to check 5000 records to see if they
are already in the DB, with the main DB at almost 300k records and
growing. This is using findfirst.
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
