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) &""")"
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)
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 fi
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
Also When using the File.Find command how to I code it so that for the specific
line in the file .eg. 1,C0AAA006,"AAA MOBILE STORAGE(ON)"0001,,
I only want it to search the data in the second comma, in the examples case
above it would be "C0AAA006" and not have to read the entire
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 nsbasic...@yahoogroups.com,
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 tha
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" 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 wiping ou
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 info
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
I use a Socket Mobile Somo 650 and when i try to hotsync project gives me error
"Can't find any usernames to install programs for. Installation cancelled". how
do i fix this?
--
You received this message because you are subscribed to the Google Groups "nsb-ce" group.
To post to this group, se
11 matches
Mail list logo