Hey, Thanks for all the reply's. Only been using this about two weeks now and
never done programming before.
Not using the Inert command does not speed it up much, it inserts about another
100 recs per minute. Would take 45 mins to insert all 30,000 recs
What I doing now is giving the user the
How would I go about programming the array code to say.if
SplitString(1)(which is customer name) is equal to textbox, then add
Splitstring(2)(Which is the equipmentNumber) to the combo box add item list?
I've done that below, but each time that code is preformed it is just
re-reading the
So i replace the Word INSERT with BEGIN TRANSACTION?
If the code is
Do
recs = File.ReadText(-3)
def= Split(recs,,)
abc = Split(def(3),)
cmd=INSERT OR REPLACE INTO NameDB2 VALUES( def(1) ,
abc(1) )
Set r=db.Execute(cmd)
combobox1.additem def(1)
For the following code where do I use the Begin/Commit transaction? Do I
replace the word INSERT?
Do
recs = File.ReadText(-3)
def= Split(recs,,)
abc = Split(def(3),)
cmd=INSERT OR REPLACE INTO NameDB2 VALUES( def(1) ,
abc(1) )
Set
Yes, with some testing it is the INSERT that is slowing it down... A LOT.
Without the insert the file with 30,000 records gets read within 5 minutes.
Yes the quotes are always present.
Is there no faster way to INSERT records from a text file to the database?
--- In
yup. the Seek worked. thanks
--- In nsbasic...@yahoogroups.com, epank...@... wrote:
Sorry that I don't recall who it was that posted it, but did you try the
other suggestion that was given about doing a Seek to the end of the file and
then writing? As far as I know lots of people use that
yes i am using
AddObject newObjects.utilctls.SFMain, FS3
Is there another way I could get this to work?
--- In nsbasic...@yahoogroups.com, Eric Pankoke epank...@... wrote:
My guess is that you're not using the right command to append to the
file, so it's simply opening the file and
This code is in a command button. All the proper AddObjets are in the
From1_Load.
Every time I click the command button I want what ever is typed into textbox1
and textbox3 to get written to a file
I enter a some info into the textboxes, tap the command button, then retype
some different
Stuck on a coding problem not sure if you can help with it or not
In a module I have the line of code
Declare Function T4FindCOMPort Lib T4CE.dll () As String
In the Form load I have the code
Dim sCom
sCom = T4FindCOMPort()
I have added the resouce T4CE.dll to the project
when i run the