Hi, Björnke,
SQLite by default is in autocommit mode when you open a database.
That means that a commit is executed after each INSERT INTO statement.
This makes bulk inserts into a table very slow.
To bring it out of autocommit mode modify your code to do a
'revExecuteSQL(BEGIN TRANSACTION)'
Hi, Bjoernke
Do your inserts within a transaction:
revExecuteSQL yourDbID, BEGIN
all inserts go here
revExecuteSQL yourDbID, COMMIT
Viktoras
Björnke von Gierke wrote:
Hi persons that know database-fu
I am trying to convert the xml docs into sqlite. It does work fine.
However, it's also way
Thanks, Sarah. Cookies..
-
Stephen Barncard
San Francisco
http://barncard.com
2009/6/21 Sarah Reichelt sarah.reich...@gmail.com
I've seen some scripts that appear to use globals but I couldn't see
that is was really necessary. As you say, variables only seem to
It seems that revcommitdatabase is doing the commit part, but not the
begin part, and therefore it's utterly useless, am I seeing that right?
I tried to use begin/commit transaction, but it seemed to slow down
even more. but i didn't experiment with that aproach much, so I
understand that
Hi, Björnke
make sure the begin and commit part is outside any loop, eg.
revExecuteSQL yourDbID, BEGIN
#loop starts here
repeat for each...
revExecuteSQL yourDbID, INSERT INTO table VALUES()
end repeat
#loop ends here
revExecuteSQL yourDbID, COMMIT
Without begin-commit stated explicitly,
I use the 'Hardware' preference pane in CHUD 3.1 to turn
on NAP each time I boot up so my G4 doesn't stew in its own juice.
Should you choose to install the latest Developer tools from Apple:
https://connect.apple.com/cgi-bin/WebObjects/MemberSite.woa/wa/getSoftware?bundleID=20414
it will
I encountered a strange behavior of the datagrid. Actually two times
a similar, but not identical kinda lockUp of a cell(s).
1. In the IDE, suddenly a cell of my Datagrid stayed 'open', meaning
the 3D layout, as when you select a cell for editing. It would not
close anymore. I can't
Hello,
I am using a standard scrollbar and put two text fields min max below
the scrollbar.
On Win2000 and on Win XP, when switching the windows style to windows
classic a scale with vertical lines appears below the scrollbar and lays
upon my text fields.
I didn't found any option to switch off
Hi Tiemo,
have you tried setting the showValue to false or the pageInc to 0?
Keep i mind that this might have other unwanted effects. You'll need
to figure out what is the best solution for you.
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Hello Mark,
setting the pageinc to 0 gave me a fat line under the scrollbar, but
setting showValue to true (I didn't showed a value yet) let the scale
disappear.
Thanks
Tiemo
-Ursprüngliche Nachricht-
Von: use-revolution-boun...@lists.runrev.com [mailto:use-revolution-
We have hide menuBar andhide taskBar
but we don't seem to be able to hide the Mac Dock
the GNU Panel(s), Cairo-Dock, Avant Window Manager,
or any other item of screen furniture that might be
better tucked away whilst our stack/apps are running.
RR stacks running under GNOME will cover
Hi Richmond,
We have hide menuBar andhide taskBar
but we don't seem to be able to hide the Mac Dock
hide menubar will also hide the dock on OS X!
Åt least it did a minute ago here...
the GNU Panel(s), Cairo-Dock, Avant Window Manager,
or any other item of screen furniture that might
kl...@major.on-rev.com wrote:
Hi Richmond,
We have hide menuBar andhide taskBar
but we don't seem to be able to hide the Mac Dock
hide menubar will also hide the dock on OS X!
Åt least it did a minute ago here...
the GNU Panel(s), Cairo-Dock, Avant Window Manager,
or any other item
On Jun 22, 2009, at 5:25 AM, Beat Cornaz wrote:
I encountered a strange behavior of the datagrid. Actually two times
a similar, but not identical kinda lockUp of a cell(s).
1. In the IDE, suddenly a cell of my Datagrid stayed 'open', meaning
the 3D layout, as when you select a cell for
Hi Richmond,
kl...@major.on-rev.com wrote:
Hi Richmond,
We have hide menuBar andhide taskBar
but we don't seem to be able to hide the Mac Dock
hide menubar will also hide the dock on OS X!
Åt least it did a minute ago here...
the GNU Panel(s), Cairo-Dock, Avant Window Manager,
or
Richmond-
Monday, June 22, 2009, 5:57:04 AM, you wrote:
Bye-the-bye, there are quite a few 'docks' around for Windows:
http://rocketdock.com/
I've used RocketDock for some time now to make Windows bearable.
There's a layering option in the Dock Settings that is by default set
to always on
Heaven forfend the thought of over-riding your UI selections PERMANENTLY,
but as it seems perfectly reasonable, under certain circumstances, to make
the Windows Taskbar or the Mac Menubar take a holiday, it might be
equally reasonable to clear away an end-user's screen clutter so that s/he
can
kl...@major.on-rev.com wrote:
Hi Richmond,
kl...@major.on-rev.com wrote:
Hi Richmond,
We have hide menuBar andhide taskBar
but we don't seem to be able to hide the Mac Dock
hide menubar will also hide the dock on OS X!
Åt least it did a minute ago here...
see what I wrote about
Dear Richmond
Heaven forfend the thought of over-riding your UI selections
PERMANENTLY,
but as it seems perfectly reasonable, under certain circumstances,
to make
the Windows Taskbar or the Mac Menubar take a holiday, it might be
equally reasonable to clear away an end-user's screen clutter
Peter W A Wood wrote:
Dear Richmond
Heaven forfend the thought of over-riding your UI selections
PERMANENTLY,
but as it seems perfectly reasonable, under certain circumstances, to
make
the Windows Taskbar or the Mac Menubar take a holiday, it might be
equally reasonable to clear away an
Hello Folks,
I've just created a minimal ETag include file for On-Rev. For those not
familiar with ETags, they are unique identifiers that are sent as HTTP
Headers. When your file change, your ETag for that file also changes. So a
browser or any http client may sent a web request like, give me
Sivakatirswami wrote:
Au contraire... , I already have a number of titles, for free, on the
internet. If you look at access logs, I see a lot of traffic to these
pages, but not a lot of downloads.
http://himalayanacademy.com/resources/children/dws_youth/
what if
set the systemWindow of stack your_stack to true
?
I do not have any furniture to play with, but this will keep at least
the stack window floating above everything else.
Viktoras
Richmond Mathewson wrote:
Some 'screen furniture' will float over everything else in the GUI
regardless.
viktoras d. wrote:
what if
set the systemWindow of stack your_stack to true
?
I do not have any furniture to play with, but this will keep at least
the stack window floating above everything else.
Gosh, you poor chap; no furniture (I hope that means 'screen furniture',
rather than you sitting
Richmond-
Monday, June 22, 2009, 10:06:00 AM, you wrote:
Will this work on Win, Mac Linux ?
Handy thing, that documentation stack...
On Mac OS systems, the systemWindow property has no effect.
--
-Mark Wieder
mwie...@ahsoftware.net
___
Sorry chaps; a hoary old chestnut I know:
Wondering about trying to present the odd movie clip in a RunRev
stack/standalone
on my Ubuntu boxes in the school . . .
Shall I embed AVI files and then . . . what?
Or shall I forgo RunRev and just convert everything to Real Player
(a format I
Mark Wieder wrote:
Richmond-
Monday, June 22, 2009, 10:06:00 AM, you wrote:
Will this work on Win, Mac Linux ?
Handy thing, that documentation stack...
You sarcastic . . . ! :)Mind you, I did deserve that.
I have been doing 'stomach surgery' on my G3 iMac; whipped out
Andre, I notice that you use the .inc suffix for on-rev includes. I know
that's the convention for PHP includes, unfortunately, that suffix will not
allow the on-rev client to read or edit the file, even though it contains
code. I'm assuming you are using your own tools for on-rev development.
I
Hi list,
How to apply the set the numberFormat to #.000 into the datagrid ? I have
the numeric values with 6 positions for decimals but only I want show 3. I
put it into the FillData but nothing happen..
Any idea?
Salut,
Josep
--
View this message in context:
Hi Josep,
Hi list,
How to apply the set the numberFormat to #.000 into the
datagrid ? I have
the numeric values with 6 positions for decimals but only I want
show 3. I
put it into the FillData but nothing happen..
Any idea?
Yep :-)
the numberformat will only affect the result of a
Hi Stephen,
Andre, I notice that you use the .inc suffix for on-rev includes. I know
that's the convention for PHP includes, unfortunately, that suffix will not
allow the on-rev client to read or edit the file, even though it contains
code. I'm assuming you are using your own tools for
Stephen,
if you go to your on-rev client preferences, you can set it to edit .inc
I am not using the client for my developments, I use it only for debugging.
I do all my dev using TextMate and Interarchy.
:D
On Mon, Jun 22, 2009 at 3:08 PM, stephen barncard
stephenrevoluti...@barncard.com
Hi Trevor,
Trevor wrote :
.Is this a stock data grid with no code added or are there any of your
.scripts that are processing data that is entered?
It is a stock datagrid, with external scripts for retrieving the
data. It has two label flds in the datagrid template, but they do
nothing.
I
Grunt, grunt, grunt . . .
Just downloaded a trial of 3.5 to my Ubuntu test machine and came up against
xanim again
which . . . by-ther-way . . . in no longer available; and has not been for
quite some time
so stuck for movies in Linux . . . until . . . Please, Please, Please . . .
RR 4.0
On
Hi Richmond,
Grunt, grunt, grunt . . .
Just downloaded a trial of 3.5 to my Ubuntu test machine and came up
against
xanim again
which . . . by-ther-way . . . in no longer available; and has not
been for
quite some time
so stuck for movies in Linux . . . until . . . Please, Please,
I gotta poke around more. My apologies.
-
Stephen Barncard
San Francisco
http://barncard.com
2009/6/22 runrev260...@m-r-d.de
Hi Stephen,
Andre, I notice that you use the .inc suffix for on-rev includes. I know
that's the convention for PHP includes,
Thanks, Klaus . . . will give it a try.
Somebody ought to have a look at the documentation
(apart from Mark Weider and myself).
Klaus on-rev wrote:
Hi Richmond,
Grunt, grunt, grunt . . .
Just downloaded a trial of 3.5 to my Ubuntu test machine and came up
against
xanim again
which . . .
Hi,
The Datagrid is fantastic but has anyone seen an issue like this?
Set the dgText to 5.8 megs of tab delimited text.
Everything about the datagrid works great.
Save the stack.
Try to re-open the stack. Nothing happens. Stack never loads.
Can't even read the script of the stack via the
Richard Gaskin wrote:
So when comparing adoption rates of apps to documents like PDF, I
believe there's a lot more going on than just the format.
Like McLuhan told us, The medium is the message:
Actually, he said it was the massage. ;-)
Curry
___
To be honest the word 'EduTainment' makes me feel extremely queasy.
Conservative rant follows.
There has arisen, in the English-speaking world at least, a theory that
children
always have
I use expandrive which creates webdav access via FTP in the background
so I just move files to any of my web servers via the finder.
Filezilla when I need to change permissions.
Neal Campbell
Abroham Neal Software
Programming Services for Windows, OS X and Linux
www.abrohamnealsoftware.com
(540)
Hi All,
I'm trying to debug a script that populates the dgText of a DataGrid, but
can't find the cause of the problem.
The scripts are run from a button on the main card.
The script is reading text that has been loaded withput URL... into
tData
Here's the script that builds each line that
In the wake of my recently deceased hard drive, I have a CD that may
contain a few files I lost. It was created while standing at the Apple
Genuis Bar with my fingers crossed while my Mac was booted from their
utility hard drive. 90 percent of the copying completed before the drive
gave up and
I just tried populating the DataGrid from the Message Box while the current
card was card Help.
Result: the DataGrid was populated.
But issuing the script from the Message Box while the card Help was not
focused (from a different card), returned an error message: no such object.
So I guess the
I'm trying to debug a script that populates the dgText of a DataGrid, but
can't find the cause of the problem.
snip
I think this line is incorrect for at least one possibly 2 reasons.
set the dgText [firstLineContainsHeaders] of grp HelpDataGrid of card
Help to tHelpLines
Firstly, the
On Mac OS systems, the systemWindow property has no effect.
Blast!
My initial posting largely referred to Linux and Windows faux docks
(obviously, even if nothing else, the Dock.app in Mac OS is something
that everyone wants to imitate).
Be careful here... when the docs say Mac OS,
Friends, are you aware of any application build in Revolution to
produce and manage Forms?. The system should be accessible in the LAN
and the data filled in the forms stored in a database. From there it
should provide some kind of login mechanism.
Saludos,
Javier Miranda V.
On Jun 22, 2009, at 3:24 PM, Jim Lambert wrote:
The Datagrid is fantastic but has anyone seen an issue like this?
Set the dgText to 5.8 megs of tab delimited text.
Everything about the datagrid works great.
Save the stack.
Try to re-open the stack. Nothing happens. Stack never loads.
Can't
Hi Klaus,
I have it in the FillData but nothing happen, all the values are showed with
6 decimal places..
Salut,
Josep
--
View this message in context:
http://www.nabble.com/numberFormat-to-datagrid-tp24152520p24156822.html
Sent from the Revolution - User mailing list archive at Nabble.com.
Hiya,
I recall Nero having some settings that would force a copy. I haven't
used it in a while, so ymmv.
Cheers,
Luis.
J. Landman Gay wrote:
In the wake of my recently deceased hard drive, I have a CD that may
contain a few files I lost. It was created while standing at the Apple
Genuis
Ken-
Monday, June 22, 2009, 3:08:07 PM, you wrote:
Be careful here... when the docs say Mac OS, they mean OS 9 and earlier
(Classic). SystemWindow works perfectly fine in OS X...
Well... so much for snippy documentation remarks... silly me, I read
the docs and assumed they were correct. I
Richmond-
Monday, June 22, 2009, 12:23:26 PM, you wrote:
Somebody ought to have a look at the documentation
(apart from Mark Weider and myself).
rotfl. Yep, no more documentation for me today. I have to drive.
--
-Mark Wieder
mwie...@ahsoftware.net
Recently, J. Landman Gay wrote:
I have a CD that may contain a few files I lost.
...
I've tried a couple of data recovery programs but they won't work unless
the CD will mount, and this one appears blank in both OS X and WinXP.
Anyone know of a utility that could deal with this? Either OS is
Well, i think i tried everything suggested, and then some...
It seems that to create 1 mb of sqlite data, rev takes approximately
half a minute, no matter what one does to speed it up. too bad.
On 22 Jun 2009, at 11:05, viktoras d. wrote:
Without begin-commit stated explicitly, SQLite
Jacque-
Monday, June 22, 2009, 2:41:37 PM, you wrote:
I've tried a couple of data recovery programs but they won't work unless
the CD will mount, and this one appears blank in both OS X and WinXP.
Anyone know of a utility that could deal with this? Either OS is fine.
I think my guess is the
Hi all,
I am sure that we had discussed this topic in the
mail list, but could not found the exact keywords
to search for in the archives.
How could i show a Gigantic Text file in a scrolling
field without bogging down the system resources?
Thanks in advance!
alejandro
Visit my site:
2009/6/23 Björnke von Gierke b...@mac.com:
Well, i think i tried everything suggested, and then some...
It seems that to create 1 mb of sqlite data, rev takes approximately half a
minute, no matter what one does to speed it up. too bad.
Without knowing much about it, I wonder is the problem
I think she's talking about a data disc that didn't get finalized
-
Stephen Barncard
San Francisco
http://barncard.com
2009/6/22 Scott Rossi sc...@tactilemedia.com
From what you describe, it sounds like the CD (we're talking standard data
compact disc here yes?) is
Hi,
I originally got that script line from Trevor's web site.
I tried it with the [] brackets, both with space and no space.
I tried it without the [] bracket value.
All 3 ways the script stops running at this line, with no returned error.
Trevor, anyway to find out what's going on setting a
Recently, stephen barncard wrote:
I think she's talking about a data disc that didn't get finalized
Yeah, just saw that -- read too quickly, as happens too frequently. Sorry,
don't have any utility suggestions.
Regards,
Scott Rossi
Creative Director
Tactile Media, Multimedia Design
The SQLite database is local. A code that writes a similar amount of
data into text files (where each file would be a record) is too fast
to bother with any user feedback (at least on this machine).
As for not using an array, I haven't tried that yet, good idea. I'll
try tomorrow, but i
stephen barncard wrote:
I think she's talking about a data disc that didn't get finalized
Right. Thanks everyone for the suggestions. Toast doesn't see anything
on the disk either. But now I'm thinking maybe all these utilities are
correct and the disk really is empty. I suspect that the 90%
Hi,
I have a trouble with the aggregate values for columns. I'm trying the
sample:
getprop uSumTotal [pColumn]
local theTotal=0
put the dgData of me into theDataA
repeat for each key theIndex in theDataA
add theDataA [theIndex][pColumn] to theTotal
end repeat
return
On Jun 22, 2009, at 2:34 PM, Beat Cornaz wrote:
Trevor wrote :
.Is this a stock data grid with no code added or are there any of your
.scripts that are processing data that is entered?
It is a stock datagrid, with external scripts for retrieving the
data. It has two label flds in the
On Jun 22, 2009, at 9:53 PM, Josep wrote:
I have a trouble with the aggregate values for columns. I'm trying the
sample:
...
Into the default column behavior, and I call it from the FillData or
SelectionChange to update the values, but only get empty.
What I'm doing wrong?
The script in the
On Jun 22, 2009, at 8:14 PM, mfstuart wrote:
I originally got that script line from Trevor's web site.
I tried it with the [] brackets, both with space and no space.
I tried it without the [] bracket value.
All 3 ways the script stops running at this line, with no returned
error.
Your
Hi,
I found it... the error is that I call:
set the text of field f_importe_portes to the uSumTotal [Col 9] of group
dg_
And the correct is:
set the text of field f_importe_portes to the uSumTotal [Col 9] of me
I call inside the FillData, but I think that isn't the correct place. I want
On Jun 22, 2009, at 10:29 PM, Josep wrote:
...
I call inside the FillData, but I think that isn't the correct
place. I want
to update the total if the user change any value, but when the user
add one
row or delete one row I need to recalculate.
What is the best place to put it?
Where
I've not even considered using the datagrid control, but I've noticed
an awful lot of traffic regarding it on this list.
Since, once I understand how something really works, I've wondered if
a description of the concept behind datagrid has been provided.
Probably a real stupid question,
On Jun 22, 2009, at 7:25 PM, J. Landman Gay wrote:
stephen barncard wrote:
I think she's talking about a data disc that didn't get finalized
Right. Thanks everyone for the suggestions. Toast doesn't see anything
on the disk either. But now I'm thinking maybe all these utilities are
correct
70 matches
Mail list logo