I used Livecode to create a web stand-alone. Fantastic! Only one problem, on
the first card is a quit button. How do I script it so that it will in fact go
back 1 page as a web page.
In other words a script that does this ""
Thanks
Rick
___
use-livecode
On 11/24/10 1:00 AM, "Mark Schonewille"
wrote:
Hi Mark,
> Hi Jonathan,
>
> I would use an open-source database like SQLite or MySQL in combination with a
> good database editor. Actually, that's what I use most of the time,
> particularly the completely free (open-source) MySQL server. MySQL is
Could this have something to do with the template stack being changed or
deleted?
On Nov 23, 2010, at 9:04 PM, Paul Looney wrote:
> Many times, on many stacks, data grids have simply stopped working - without
> any warning or error.
> The line of code they fail to execute is this, or similar:
Many times, on many stacks, data grids have simply stopped working -
without any warning or error.
The line of code they fail to execute is this, or similar:
set the dgText of grp "Data Grid" to vTheList
The code may have worked for months before is fails.
The only solution I've found is to
Good advice Chip! I feel like a right Wally now - how come I never noticed
this dialog before?
Terry...
On 24/11/10 3:15 PM, "Chipp Walters" wrote:
> Maybe you should check the PLIST settings...
>
> On Mon, Nov 22, 2010 at 10:03 PM, Terry Judd wrote:
>
>> I seem to have a lot of trouble get
Maybe you should check the PLIST settings...
On Mon, Nov 22, 2010 at 10:03 PM, Terry Judd wrote:
> I seem to have a lot of trouble getting the plugin to know which simulator
> to open it in. Choose iPad in the simulator and the plugin often launches
> the iPhone simulator anyway. Once the simula
Hmm, well I seem to remember early in this thread some caustic remarks
about the IT department - maybe they earn their money after all!
Pete Haworth
On Nov 23, 2010, at 4:37 PM, Bob Sneidar wrote:
Actually, this is one of the things about SQL that you have to think
about if you are going to
Actually, this is one of the things about SQL that you have to think about if
you are going to use it. If you are not going to use a file based SQL like
sqLite, you will need some kind of tool that can connect to an SQL server and
create a database for you. You have to have at least one table wi
In the beginning, God created Man, and rested. Next He created Woman, and no
one's rested since! ;-)
Bob
On Nov 23, 2010, at 1:56 PM, Mike Kerner wrote:
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the anima
FlexibleLearning wrote:
Thank you Jacque... Forgot about that one. Had half-remembered it as a
compatibility-only function, but we'll give it a try. We were getting a
'cannot find stack' error which actually meant 'cannot fully load this
stack', as well as no graceful result that memory is runni
On 11/23/10 11:46 PM, "Jonathan Lynch" wrote:
> Honestly, I am still just trying to get my head around using databases.
>
> I use Rev for processing text in all sorts of creative ways at work - vastly
> increases our productivity - but, I know next to nothing about database use.
>
> The logical
On 11/24/10 12:19 AM, "Jonathan Lynch" wrote:
> Should I use SQLite for a database that is going to be used by multiple
> users on a shared drive?
>
> The ongoing thread regarding multiuser use of SQLite has me wary of doing
> so.
>
> Can I use mySQL in the same embedded style that I can use SQ
On 23.11.2010 at 17:19 Uhr -0500 Jonathan Lynch apparently wrote:
My current thought is to set it up with Valentina (demo mode, 10 minute
limit, etc...), then use the fully-working prototype to persuade my boss to
buy a Valentina license.
From everything I read about embedded Valentina, it seem
On 23.11.2010 at 17:19 Uhr -0500 Jonathan Lynch apparently wrote:
My current thought is to set it up with Valentina (demo mode, 10 minute
limit, etc...), then use the fully-working prototype to persuade my boss to
buy a Valentina license.
From everything I read about embedded Valentina, it seem
On 11/23/10 10:34 PM, "Jonathan Lynch" wrote:
Hi Jonathan,
Idea was just simply do:
while( Db.open() is false )
keep trying open it
do some job
db.close()
At least yet in 1999 Valentina was so fast that even in this dummy way was
able handle many users ...
Of co
Hi Jonathan,
I would use an open-source database like SQLite or MySQL in combination with a
good database editor. Actually, that's what I use most of the time,
particularly the completely free (open-source) MySQL server. MySQL is a really
good database that fits the needs of very large companie
Thank you Jacque... Forgot about that one. Had half-remembered it as a
compatibility-only function, but we'll give it a try. We were getting a
'cannot find stack' error which actually meant 'cannot fully load this
stack', as well as no graceful result that memory is running low; just a
suddenly non
Great tool for sqlite but I think they've moved over to mySQL now.
Might be a ggod idea to prototype the app with SQLite (no/very little
db admin required) then port it over to mySQL if it turns out that
SQLite won;t do the job.
Pete Haworth
On Nov 23, 2010, at 2:10 PM, Andre Garzia wrote
Should I use SQLite for a database that is going to be used by multiple
users on a shared drive?
The ongoing thread regarding multiuser use of SQLite has me wary of doing
so.
Can I use mySQL in the same embedded style that I can use SQLite, or does it
have to be installed on user's machines?
My
take it in as a binfile:
set the myCustomProp of button "MyButton" to url
"binfile:c:/filepath/filename.txt"
On Tue, Nov 23, 2010 at 5:10 PM, Charles Szasz wrote:
> How do I put a RTF file into custom properties so that it can be stored in
> a standalone for windows?
>
> Charles Szasz
> csz...@m
Jonathan,
If you use firefox, then pick up a firefox extension sqlite manager. With
this extension you'll have a simple client able to work your database files
which you can then later open and use in LiveCode.
There are other sqlite tools and yes you can do it by script but I think it
is easier
How do I put a RTF file into custom properties so that it can be stored in a
standalone for windows?
Charles Szasz
csz...@mac.com
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage
what are y'all using for a card size (x,y) for your ios projects?
--
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
and did a little diving.
And God said, "This is good."
Honestly, I am still just trying to get my head around using databases.
I use Rev for processing text in all sorts of creative ways at work - vastly
increases our productivity - but, I know next to nothing about database use.
The logical process, to me, would be the following:
- Create database
Jonathan,
That depends on the database you want to use. If you use MySQL then the answer
is yes, although it might be possible to write new database files directly to
the MySQL directory and restart MySQL (for which you will also need to use the
shell function).
Why are you so keen on creating
Mark,
Thanks your script and Jonathan's worked!
Charles Szasz
csz...@mac.com
On Nov 23, 2010, at 4:14 PM, Mark Schonewille-3 [via Runtime Revolution] wrote:
> Hi Charles,
>
> I'm not sure what you want, but this is the syntax to store data from a field
> in a custom property:
>
> set t
Thanks!
Your script worked!
Charles Szasz
csz...@mac.com
On Nov 23, 2010, at 4:16 PM, Jonathan Lynch [via Runtime Revolution] wrote:
> It would be a line that looks something like this:
>
> Set the myCustomProperty of button "MyButton" to field "MyField"
>
> That actual name of the cust
Thanks, Mark.
I am not talking about a database on a server. I just want to create a
database file on a shared drive. Would I still need to use a shell command
for that?
On Tue, Nov 23, 2010 at 4:17 PM, Mark Schonewille <
m.schonewi...@economy-x-talk.com> wrote:
> Hi Jonathan,
>
> You need to co
Hi Jonathan,
You need to connect to the SQL server using the terminal (i.e. the shell
function), login as root and execute the command to create the database. It is
also possible to write a PHP script and have it create the database, if you are
connecting to a web server. Sometimes you need to
It would be a line that looks something like this:
Set the myCustomProperty of button "MyButton" to field "MyField"
That actual name of the custom property can be just about anything, but it
needs to be a single word.
You do not have to precreate custom properties of objects. When you set
them,
Hi Charles,
I'm not sure what you want, but this is the syntax to store data from a field
in a custom property:
set the cCustomPropertyName of control "Some Control" to fld "Field Name"
(control can also be card or stack).
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Softwa
I have been looking through the docs, and this does not seem obvious to me.
I see that opening a nonexistent database using the SQlite driver will
create one - but that only applies to SQLite.
It would seem that the standard way to do this, would be to use
revExecuteSql, but that command requires
SQLite has pretty powerful transaction locking capabilities that seem
like they should handle the circumstances you mentioned but I believe
you;re right that only one person can write to an SQLite database at a
a time - that's because it locks the whole database file not
individual tables o
How do you put the contents of a edit field into the property contents of
custom properties? I am using a custom label property for checkboxes and I
would to add the contents of a field into a custom property when the user
checks a checkbox for that field.
--
View this message in context:
http:/
Hi Ruslan,
What is the open/close trick? Is this the idea of opening the record in
question, loading it into the application, then closing and saving the
record while putting some kind of marker in the record to indicate that it
is locked - then, when the user is done with the record, the applicat
On 11/23/10 8:41 PM, "Jonathan Lynch" wrote:
> I am in the same sort of boat.
>
> I am making an application that would use a database file on a shared drive.
> Maybe 10-20 people would be writing to it during any given day. It seems
> like Valentina would be a good choice for this, but, as sill
On 11/23/10 8:41 PM, "Jonathan Lynch" wrote:
> I am in the same sort of boat.
>
> I am making an application that would use a database file on a shared drive.
> Maybe 10-20 people would be writing to it during any given day. It seems
> like Valentina would be a good choice for this, but, as sill
Yes, mySQL is multiuser out of the box. FYI, I am pretty sure that if a user
has an sqLite database open for writing, no one else can open it to write to
it. Multiple users can have it open for read, but only one can write. Unless
something has changed anyway.
Bob
On Nov 23, 2010, at 11:07 A
I think for a small number of users, and a simple data structure, it is not
much of a problem. The minimum requirement here is avoiding concurrent sessions
into the same records. For instance, suppose user a has a customer record open
for editing. You need to flag is so that if customer B comes
On 11/23/10 3:04 AM, FlexibleLearning wrote:
As data is added to a particular stack, LiveCode runs the risk of running
out of memory. Has anyone figured out how to check this programmatically, or
is it a question for Edinburgh?
I'm not sure you can do it exactly. You could check the size of the
Does MySQL work fine being used by multiple users accessing a MySQL database
file on a shared drive? That is - not being used with a client/server
structure.
On Tue, Nov 23, 2010 at 1:53 PM, David Beck
wrote:
>
> I'd suggest pushing to use MySQL, even though some of these work arounds
> are very
I'm kind of in the same boat there! Busy trying to document this
stuff right now with a hope to having some other people give it a try
in the first couple of months of next year.
Pete Haworth
On Nov 23, 2010, at 10:40 AM, Bob Sneidar wrote:
Hi Pete. That is pretty much what I am doing. I c
I'd suggest pushing to use MySQL, even though some of these work arounds
are very clever and interesting. We had 3 people accessing a SQLite
database and started running into problems with locks on files. We moved
to MySQL and everything worked like a charm right away. Seems best to
start wit
Björnke von Gierke skrev 2010-11-23 19.24:
I think fredrik just uses installed programs and a sqlite file on a network share. Which
is a smart way to circumvent "no server" rules, and sqlite seems to be able to
do that.
Yep, that's how I planned it. Previously I've mostly used text files to
h
I followed your conversation on the Valentina forum. It is amazing how much
help those guys give any customer that asks. It is one of the reasons I love
Valentina.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscr
I think he means Web Server with a database backend.
Bob
On Nov 23, 2010, at 10:04 AM, Ruslan Zasukhin wrote:
> Fredrick says:
>
>> Oh, and the reason I have to use SQLite is that I can't run any database
>> servers (the IT department would be annoyed to say the least).
>
> Once again:
>
I am in the same sort of boat.
I am making an application that would use a database file on a shared drive.
Maybe 10-20 people would be writing to it during any given day. It seems
like Valentina would be a good choice for this, but, as silly as it sounds,
I don't have a practical funding mechanis
Hi Pete. That is pretty much what I am doing. I can't help but think about
reusing the work I do in other apps later, so I am trying to make my forms
reusable by forming a method like you. Since I am really a hobbyist when it
comes to developing, I never get close to finishing.
Bob
On Nov 23
I think fredrik just uses installed programs and a sqlite file on a network
share. Which is a smart way to circumvent "no server" rules, and sqlite seems
to be able to do that.
As for rev not being able to react to multiple clients on sockets, that is not
how it works. if you do not use blockin
Hehe,
Well, no 1 is not an option and no 2 is a bit difficult. I'm making a
small in-house application behind the back of the giant IT-department
(1500 or so people). If I let them know what I'm up to they might begin
to crack down on my (and my other IT-savvy collegues) other
applications. W
On 11/23/10 4:15 PM, "Andre Garzia" wrote:
> Fredrik,
Hi Andre,
> Instead of risking problems by having concurrent queries to a single SQLite
> database, why don't you build a middleware?
> From your email, I understood that the problem is that you can't install a
> server such as MySQL bec
I have to correct myself, it was my fault. Valentina 4.7 runs on Win with
older versions and new LC 4.5.1
(had a typo in my new Valentina serial awkward!)
Tiemo
> -Ursprüngliche Nachricht-
> Von: use-livecode-boun...@lists.runrev.com [mailto:use-livecode-
> boun...@lists.runrev.com] Im
I wrote something like this years ago in a galaxy far away on Hewlett
Packard 3000 computers! My experience was that it could provide
simple add/change/delete/display capabilities for a single table with
forms that could look really bad if there were a lot of columns in the
table so good l
I think the answer to your question depends on the level of
concurrency you expect. You'd definitely need to implement the SQLite
locking mechanisms to support concurrent users (BEGIN/END/ROLLBACK
TRANSACTION).
Check out sqlite.org, the home of sqlite, there's some words on there
about
you can keep connections open, as many as you think is reasonable, so if two
client connects you can loop thru the connected clients answering their
requests in a merry go round fashion.
the only times where LiveCode will fail to answer a connection is if there
is some blocking code running and at
I think you could simply use the try/catch structure. Try yo open the database
for writing, then exit if all goes well. If not, in your catch, just loop.
Increment a counter, so that you can break out of the loop at an inordinate
number of attempts to avoid loop lock. Then you just have to make
Andre. How would you que the requests? Since LiveCode is not multithreaded,
what would happen if 2 clients made a request simultaneously? You still have
the same problem don't you? Or is LiveCode capable somehow of communicating on
multiple sockets simultaneously?
Bob
On Nov 23, 2010, at 6:1
But if in any case you have to handle non pure ASCII characters, like
European Umlaute and accents, then Valentina 4.7 corrupts your data on Mac,
but runs fine on Win (at least for 9 minutes). They made the 4.8b1 patch for
this issue (read my last postings, some month ago)
Tiemo
>
> Good to know
Good to know that new install is working fine on Mac OS. I'm really headed
in the direction of just telling my customers to by Macs.
On Tue, Nov 23, 2010 at 9:07 AM, Tiemo Hollmann TB wrote:
> Yes, LiveCode 4.5.1 runs fine with older Valentina releases, but up to now
> I
> didn't get the latest V
Thanks for the suggestions, I wouldn't have though of that! Unfortunately I
don't think I could run any kind of serverlike program on our network.
I'm actually contemplating using some kind of lock-file that is created
whenever someone is writing to the database (or perhaps I'll even use some
Scott Rossi wrote:
I recently followed an interesting discussion between user interface
professionals regarding the use of "wizards" to aid in data collection and
whether they were still appropriate. Some folks stated that wizards are a
viable means to help guide a user through a process, whil
Fredrik,
Instead of risking problems by having concurrent queries to a single SQLite
database, why don't you build a middleware?
>From your email, I understood that the problem is that you can't install a
server such as MySQL because the IT dept will be shouting. So why don't you
use LiveCode to
Yes, LiveCode 4.5.1 runs fine with older Valentina releases, but up to now I
didn't get the latest Valentina release 4.7 to run on Windows (... as you
know Bill) On Mac I got to run Valentina 4.7 with older Rev releases as well
as with 4.5.1, but on Windows Valentina quits after the demo period of
On Tue, Nov 23, 2010 at 7:10 AM, Fredrik Andersson wrote:
> From reading on the SQLite website I get the impression that it IS possible
> to use SQLite as a multi-user database even though it's not its primary
> purpose. I recently made a small application that was used by very few
> people and th
Hi Andre,
Am 23.11.2010 um 13:00 schrieb Andre Garzia:
>>> Absolutely. Yes, but only in your own sandbox.
>> sorry, no capisce, what does that mean?
>>
> It means that each application has it's own documents and temporary files
> folder. So that they won't share content with each other. It is li
Hello,
>From reading on the SQLite website I get the impression that it IS possible to
>use SQLite as a multi-user database even though it's not its primary purpose.
>I recently made a small application that was used by very few people and the
>app didn't implode or anything.
My question is: D
>
>
> > Absolutely. Yes, but only in your own sandbox.
>
> sorry, no capisce, what does that mean?
>
>
It means that each application has it's own documents and temporary files
folder. So that they won't share content with each other. It is like a
walled garden, you can tend to your own patch of gr
Alex,
For a simple cgi installation, all you need is the standalone engine for
linux. Pick the 3.5 one. There was a recent thread on this list where Jacque
gave us some download links (with permission). Remember to invoke the cgi
engine with the "-ui" option not to load X11 & Friends.
I know RevS
As data is added to a particular stack, LiveCode runs the risk of running
out of memory. Has anyone figured out how to check this programmatically, or
is it a question for Edinburgh?
Hugh Senior
FLCo
___
use-livecode mailing list
use-livecode@lists.run
69 matches
Mail list logo
