Which control are you using to read the file?
I'm trying to format records in XP pulled from a database and sync them
to a PDA. I want to read the records on the PDA as a direct file ala:
file.Get fileRec, loc
where loc is the record number. I'm not having much luck. DOes anyone
know how to do
Hey! I've actually been doing some work recently on speeding up bulk insert
into Sqlite. My findings may be of interest to you.
First, there's this entry in the Sqlite FAQ:
http://www.sqlite.org/faq.html#q19
The key is grouping as many inserts as possible into one transaction, so what
I've
--- In nsbasic...@yahoogroups.com, bigp...@... bigp...@... wrote:
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
Yes, that stuff is in the program
AddObject filesystem
AddObject file
even if I do this, ignoring the file reads I still get nothing in the list box
ListBox1.AddItem bunch of junk stuff
Do I need something like Sub ListBox1_Load ??
--- In nsbasic...@yahoogroups.com, chris_kenworthy
First question - is there any other code or setup in the program regarding the
File control? There isn't a built-in one in NSbasic - you need to do an
AddObject line or something similar.
Also, if you're not going to do any more error checking, then you should
probably add an 'On Error Goto 0'
I figured out my problem. Thanks for trying to help.
George Walters
-Original Message-
From: nsbasic...@yahoogroups.com [mailto:nsbasic...@yahoogroups.com] On
Behalf Of George Henne
Sent: Tuesday, February 23, 2010 6:21 AM
To: nsbasic...@yahoogroups.com
Subject: Re: [nsbasic-ce] text
3.5.3 Formatting a program
To make your program easier to read, use spaces or tabs to
indent related statements. This is usually done with
statements inside procedures and loops. The default
tabwidth and indentation in NS Basic/CE is two spaces. To
automatically reformat an entire program, choose
This is from Chapter 3, which deals with the Device IDE.
3.5.3 Formatting a program
To make your program easier to read, use spaces or tabs to
indent related statements. This is usually done with
statements inside procedures and loops. The default
tabwidth and indentation in NS Basic/CE is two
So where do you do this on the windows IDE?
-Original Message-
From: nsbasic...@yahoogroups.com [mailto:nsbasic...@yahoogroups.com] On
Behalf Of George Henne
Sent: Tuesday, February 23, 2010 2:15 PM
To: nsbasic...@yahoogroups.com
Subject: Re: [nsbasic-ce] Manual on Tabs
This is from
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
If you want to indicate to the user that it is doing something then use the
following:
WaitCursor(True)
do you stuff here
WaitCursor(False)
This will display the standard twirly 4 quadrant busy cursor.
In my application I also have data files that are huge and the application
Hello,
I did a few performance tests with SQLite, with the desktop version though, not
CE. I suspect, but can't test it at the moment, that the CE version will behave
in a similar way roughly.
First of all, I ran a loop of 1000 inserts to a table (I used the SQLite
example program from NSBasic
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
Thomas,
Do you have any code examples?
Jay
On Tue, Feb 23, 2010 at 2:22 PM, bigp...@rogers.com bigp...@rogers.comwrote:
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
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
Hi - Not sure if this helps, I have not written anything with NSB for 2 years
but I did create an App in CE to allow capture and updating of fault data on
construction sites.
After several tries I found it much quicker to create the SQLite db file on the
desktop and transfer it to the CE
17 matches
Mail list logo