LiveCode Forums

Hi Jim, Hi Klaus, you obviously did not take a look at UPDATE example in the "SQLite Sampler.rev" stack, where you can see a working example of the UPDATE syntax. Well, I actually did check this sample out and I found it difficult to follow. I would also say, its not exactly a "working example" sinc...

The difference between "repeat with i = X" and "repeat fore each" will only be noticable
when it comes to < 1000's of cds/lines etc.

But then the difference is HUGE!

Hi Jim, you obviously did not take a look at UPDATE example in the "SQLite Sampler.rev" stack, where you can see a working example of the UPDATE syntax. Hint: "revdb_execute" is a function! ... put "UPDATE Questions SET XX = '" & lblX & "' WHERE _id='" & txtID & "'" into tSQLQuery put revdb_execute(...

Hi Paul, why not download into a variable first, check this and then save to disk on success? ... put url t_img_url into tImageVariable ## Network problem? if the result <> empty then ## error exit HANDLERNAME end if ## check content of variable: if tImageVariable contains "404" then ## or maybe ......

Hi Paul ... Using my example: if my image area is 200x100 and the remote image is 600x200, what is see in my image area is 200x100. If I inspect its size, it is 200x100. So I can no longer resize it in the way I want. I must be missing something?--paul This sound as if your image is "locLock"ed! In ...

Forget RealBasic, there is no equivalent to these commands in Livecode!

Stupid question: Did you ever EXECUTE tSQLQuery?

Hi Jack

I'm afraid this is not much faster than: repeat with i = 1 to the num of cds

One shouldn't have too many cards anyway


Best

Klaus

EDIT:
Corrected an ugly syntax error

You mean "Speech Recognition" à la SIRI?
Huh, a BIG task, I think...

Monte?

Hi Jim, given that: lblX = a valid column name txtID = a valid ID and your database field ID is really named: _id Then this should work: UPDATE Questions SET Column_name = 'content_of_fld_lblx' WHERE _id='1' Add an ANSWER to check your SQL string! ... put "UPDATE Questions SET XX = '" & lblX & "' WH...

Hi Nakia, well, there are two possibilities top use repeat": 1. repeat with i = 1 to the num of lines of fld XYZ ## do someting with "line i of fld XYZ" end repeat This will do for most cases and is fast enough for lots of repeats. But when unsing "repeat with x =..." the engine will always start to...

Hi Knightlite, rs.Edit rs.field("XX").StringValue=trim(lblX.Text) rs.Update Fire2.Commit // Fire2 is the name of the database - Fire2.sqlite :?: :?: :?: 8) well, like all the other db commands you also need to create the appropriate SQL command for this, just like the other examples in the lessons y...

Hi Nakia, 1. file operations do not work with wildcards! You need to get a list of the files, do your filtering and then apply your actions to the list of files. Like this (out of my head): ... put the folder into olddir ## Need this later for the list of ABSOLUTE pathnames put specialfolderpath("ca...

Hi Paul,

I have been bitten by this before!
Add this line before every post/access to HTTPS connections:
...
libUrlSetSSLVerification false
post whatever to url "https://wherever.com/mycgi"
...

Its not documented, but should do the trick.


Best

Klaus

Hi ju11,

I have a little stack with showing the "custom property set" solution.
Go to my page and scroll a little down to "CP-Sets1":
http://www.major-k.de/xtalk.html

That may get you started.


Best

Klaus

Hi John,

fingers crossed!


Best

Klaus