LiveCode Forums.

I shaked my brain and I have tried this :


--Sélection du fichier d'importation des profs
answer file " Sélectionner le fichier :"
if the result is not "cancel" then
put URL("file:" & it) into timport
put "INSERT INTO profs" into tSQL
replace "'" with "" in timport
replace "ç" with "c" in ...

Mark wrote:Hi,

Did you look at my SQLite example and do you understand it?

Mark

Do you refer to your example code in previous posts ...?

Regards.

Hi Mark,

Ok, but to do the job your way, i cannot use variables and loops, can I ?
When you said :

Multiple requests don't work because the programmer decided to do it that way


... do you mean my way is not correct and there is a syntax error ? But where ?

I'm sorry for all these questions ...

Thanks Mark.

If i well understand you, you advise me to :
- read a line of my file,
- execute the relative MYSQL query,
- read the next file, etc.

I will try. However, i have used this piece of code (multiple query) with success in a SQlite database. But i have caught your notice about the ...

Hello Mark,

If i try "into" instead of "after", it works but i have just one insertion (one line). Here :

--if tPasse >1 then
put "INSERT INTO profs(ID, nom_prof, prenom_prof, login_prof, passe_prof, matiere_prof, pp_classe)" & \
" VALUES(NULL,'"&tNom&"', '"&tPrenom&"', '"&tLogin&"','"&tMdp ...

Hello,

i have a little problem with my program.
The answer advises me to check the correct syntax up to my mysql version, but i caught the result and try to inject it with another soft (sequel) and the request is correct ! So i think i mistake with Livecode syntax.
Here my code :

on mouseUp ...

Hello,

We are sorry : jmburnod offered me an help file under runrev in french; i have got a version but it is old and some problems occurs with new versions of runrev.
It appears that his one is corrected, so i was asking him to send it to me .

I hope my english is understandable

Hello,

Oui je veux bien cette doc ' si cela ne vous dérange pas.
Ce sont les vacances, et il faut que je m'y mette pour être prêt à la rentrée

Merci,

Arnaud.

Hello :D

I suscribed to the RunRev Yahoo's group : there is the french help file you mentionned (your link doesn't work :roll: ). But i have a problem with it : stack "Documentation Revolution": execution error at line 215 (Handler: can't find handler) near "revDocsSetupColors", char 1

An idea ...

Hello,

Thanks for these links.

(J'étais déjà tombé sur le site de domotique et je trouve cela passionnant ! Félicitations au créateur )

I would like to find a good book about RunRev, but it seems to be hard, quite impossible, isn't it? (i mean even in english language)

What a pity...

Hello,

I would like to start with Revolution to write my own apps. I am a french math's teacher and i've had few ideas for a long time now.

Last month, i tried RB. SO i would try REv who seems to me to be the best way to do what i want to.
But i have never used hypercard before i have no ...