Search found 11 matches
- Sun Aug 18, 2013 2:34 pm
- Forum: Databases
- Topic: Syntax error with multiple requests
- Replies: 28
- Views: 20144
Re: Syntax error with multiple requests
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 timport put...
- Sun Aug 18, 2013 1:44 pm
- Forum: Databases
- Topic: Syntax error with multiple requests
- Replies: 28
- Views: 20144
Re: Syntax error with multiple requests
Do you refer to your example code in previous posts ...?Mark wrote:Hi,
Did you look at my SQLite example and do you understand it?
Mark
Regards.
- Sun Aug 18, 2013 12:50 pm
- Forum: Databases
- Topic: Syntax error with multiple requests
- Replies: 28
- Views: 20144
Re: Syntax error with multiple requests
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 but i do ...
- Sat Aug 17, 2013 10:55 pm
- Forum: Databases
- Topic: Syntax error with multiple requests
- Replies: 28
- Views: 20144
Re: Syntax error with multiple requests
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 treatment...
- Sat Aug 17, 2013 8:53 pm
- Forum: Databases
- Topic: Syntax error with multiple requests
- Replies: 28
- Views: 20144
Re: Syntax error with multiple requests
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&"', '"&t...
- Sat Aug 17, 2013 1:19 pm
- Forum: Databases
- Topic: Syntax error with multiple requests
- Replies: 28
- Views: 20144
Syntax error with multiple requests
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 local ti...
- Thu Jul 02, 2009 10:35 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Documentation for french newbies
- Replies: 11
- Views: 8515
- Tue Jun 30, 2009 7:43 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Documentation for french newbies
- Replies: 11
- Views: 8515
- Tue Jun 02, 2009 6:12 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Documentation for french newbies
- Replies: 11
- Views: 8515
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 ? Tha...
- Mon Jun 01, 2009 6:13 pm
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Documentation for french newbies
- Replies: 11
- Views: 8515
- Sun May 31, 2009 11:11 am
- Forum: Getting Started with LiveCode - Experienced Developers
- Topic: Documentation for french newbies
- Replies: 11
- Views: 8515
Documentation for french newbies
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 statements ...