Update mySQL-Database
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Update mySQL-Database
Helo ,
Since hours I try to find my folkd by using:
put "UPDATE Customers SET Foto_pfad = " & Fotopfad & " where kndnr =" & customernumber into SQL_Befehl
executeSQL (DB_ID, SQL_Befehl)
Any idea out there?
best regards and thank you
Horst
Since hours I try to find my folkd by using:
put "UPDATE Customers SET Foto_pfad = " & Fotopfad & " where kndnr =" & customernumber into SQL_Befehl
executeSQL (DB_ID, SQL_Befehl)
Any idea out there?
best regards and thank you
Horst
Horst, have you tried the sql syntax without spaces before and after the equal sign?
put "UPDATE Customers SET Foto_pfad=" & Fotopfad & " where kndnr=" & customernumber
Best,
Mark
put "UPDATE Customers SET Foto_pfad=" & Fotopfad & " where kndnr=" & customernumber
Best,
Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
Hi Mark,
Thanks for answering )
Yes, just tried, the result is the same error:
Handler: can't find handler
button ID 1615
revdb_execute (DB_ID, SQL_Befehl)
revdb_execute
Now, To make it realy easy I tried:
put "UPDATE knddaten SET Foto_pfad='Test' where kndnr=1318" into SQL_Befehl
Same result, same error-message as abowe.
I know, the SQL Syntax is correct, tryed directly on the database.
any idea?
best regards
Horst
Thanks for answering )
Yes, just tried, the result is the same error:
Handler: can't find handler
button ID 1615
revdb_execute (DB_ID, SQL_Befehl)
revdb_execute
Now, To make it realy easy I tried:
put "UPDATE knddaten SET Foto_pfad='Test' where kndnr=1318" into SQL_Befehl
Same result, same error-message as abowe.
I know, the SQL Syntax is correct, tryed directly on the database.
any idea?
best regards
Horst
I think you should post your entire script. Do you know that revdb_execute is not a command but a function?
get revdb_execute(DB_ID,SQL_Befehl)
shouldn't return an error. Do other SQL-related commands and functions work correctly?
Best,
Mark
get revdb_execute(DB_ID,SQL_Befehl)
shouldn't return an error. Do other SQL-related commands and functions work correctly?
Best,
Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
Hi Mark,
Thanks again for answering,
It is frustrating. I'm a runRev newby and tray to work with RunRev and mySQL.
The original Idea was just to save a picture into a file which didn't work
"UPDATE knddaten SET Foto_image = "& the imagedata of image "Foto_Image" & " where kndnr =" & kundennummer into SQL_Befehl
revexecuteSQL (DB_ID, SQL_Befehl)
the Foto_image is defined as Bin
So, step by step and hours later I just want to write a word like Test into a field in the database, which also don't work
put "UPDATE knddaten SET Foto_pfad='Test' where kndnr=1318" into SQL_Befehl
revexecuteSQL (DB_ID, SQL_Befehl)
the foto_Pfad is defined as text in SQL
I think in the near future I will give up and go to Filemaster or Realbasic. To understand RunRev with this lousy description costs Hours of my time I coulds use better, is frustrating and you always feel like a stupid looser. The only hope is the board but you have to be lucky, to find a helpfull hand like you are.
best regards and thanks
Horst
Thanks again for answering,
It is frustrating. I'm a runRev newby and tray to work with RunRev and mySQL.
The original Idea was just to save a picture into a file which didn't work
"UPDATE knddaten SET Foto_image = "& the imagedata of image "Foto_Image" & " where kndnr =" & kundennummer into SQL_Befehl
revexecuteSQL (DB_ID, SQL_Befehl)
the Foto_image is defined as Bin
So, step by step and hours later I just want to write a word like Test into a field in the database, which also don't work
put "UPDATE knddaten SET Foto_pfad='Test' where kndnr=1318" into SQL_Befehl
revexecuteSQL (DB_ID, SQL_Befehl)
the foto_Pfad is defined as text in SQL
I think in the near future I will give up and go to Filemaster or Realbasic. To understand RunRev with this lousy description costs Hours of my time I coulds use better, is frustrating and you always feel like a stupid looser. The only hope is the board but you have to be lucky, to find a helpfull hand like you are.
best regards and thanks
Horst
Horst,
You didn't answer my questions, which I really need an answer to in order to help you. Do other SQL-related commands in Rev work fine for you? Do you realise that revdb_execute is a function and not a command? I think you do something wrong and, as I said, you should post your entire script.
Mark
You didn't answer my questions, which I really need an answer to in order to help you. Do other SQL-related commands in Rev work fine for you? Do you realise that revdb_execute is a function and not a command? I think you do something wrong and, as I said, you should post your entire script.
Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
Hi Mark,
I'm sorry that I didn't answer correct, but, as you see, that's the stack:
on mouseup
GLOBAL DB_ID, Kundennummer, Rec_ID
put fld "kndnr" into kundennummer
put "UPDATE knddaten SET Foto_pfad='Test' where kndnr=1318" into SQL_Befehl
revexecuteSQL (DB_ID, SQL_Befehl)
end mouseup
Where is my fold?
best regards
Horst
I'm sorry that I didn't answer correct, but, as you see, that's the stack:
on mouseup
GLOBAL DB_ID, Kundennummer, Rec_ID
put fld "kndnr" into kundennummer
put "UPDATE knddaten SET Foto_pfad='Test' where kndnr=1318" into SQL_Befehl
revexecuteSQL (DB_ID, SQL_Befehl)
end mouseup
Where is my fold?
best regards
Horst
Horst,
OK, you changed revdb_exe into revExecuteSQL. That's fine, the latter is a command while the former is a function. You added brackets to the revExecuteSQL command. Functions need brackets around paremeters, but if you put brackets around the parameters of a command, Rev gets confused.
When using a command, you can do this:
doSomeCommand (parameter1),(parameter2)
but not
doSomeCommand (parameter1,parameter2)
This is a general rule in Revolution and has nothing to do with the built-in SQL and other database commands.
Now, your script should look like this:
on mouseup
global DB_ID, Kundennummer, Rec_ID
put fld "kndnr" into kundennummer
put "UPDATE knddaten SET Foto_pfad='Test' WHERE kndnr=1318" into SQL_Befehl
revexecuteSQL DB_ID,SQL_Befehl
put the result
end mouseup
I am sure this will work fine. I have added a line that puts the result into the message box. You might want to change this line and show an error message if item 1 of the result is revdberr.
Best regards,
Mark
OK, you changed revdb_exe into revExecuteSQL. That's fine, the latter is a command while the former is a function. You added brackets to the revExecuteSQL command. Functions need brackets around paremeters, but if you put brackets around the parameters of a command, Rev gets confused.
When using a command, you can do this:
doSomeCommand (parameter1),(parameter2)
but not
doSomeCommand (parameter1,parameter2)
This is a general rule in Revolution and has nothing to do with the built-in SQL and other database commands.
Now, your script should look like this:
on mouseup
global DB_ID, Kundennummer, Rec_ID
put fld "kndnr" into kundennummer
put "UPDATE knddaten SET Foto_pfad='Test' WHERE kndnr=1318" into SQL_Befehl
revexecuteSQL DB_ID,SQL_Befehl
put the result
end mouseup
I am sure this will work fine. I have added a line that puts the result into the message box. You might want to change this line and show an error message if item 1 of the result is revdberr.
Best regards,
Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
Hi Marc,
to make a long long story short, lets continue with one of your last sentences:
" I am sure this will work fine"
That's what it does
I've spent a long and frustrating day, you gave me a few minutes and...
... it's done!
Puhhh, 1 day for one line... When do I possibly have a chance to fix my aplication? In 150 years? Might be
Could you tell me a documentation about Transcript, that realy works?
Hey Marc, people like you are like sun in the grey winter Thanks a lot
Horst
to make a long long story short, lets continue with one of your last sentences:
" I am sure this will work fine"
That's what it does
I've spent a long and frustrating day, you gave me a few minutes and...
... it's done!
Puhhh, 1 day for one line... When do I possibly have a chance to fix my aplication? In 150 years? Might be
Could you tell me a documentation about Transcript, that realy works?
Hey Marc, people like you are like sun in the grey winter Thanks a lot
Horst
Hello Horst,
I'm always glad to help. Little mistakes like these can happen to any beginning Revolution programmer. I know it is frustrating in the beginning, but once you know it, the problem is solved for once and forever.
Actually, the only really good documentation that I know of is for HyperCard. If you find a book for HyperCard, I'd buy and read it. For example, the Complete HyperCard Handbook contains very useful parts:
http://books.iuniverse.com/viewgiftoc.a ... 427&page=5
particularly chapters 21, 22, 24, 28, 32 and 35.
After reading this, you could have alook at the scripting conference stacks at
http://support.runrev.com/scriptingconferences/
Among other things, this will show you that there are also important differences between Revolution and HyperCard.
You should also look in Revolution Online, where you will mostly find very simple stacks from which you can learn how things work. Rev Online can be found in the Development menu of the Revolution IDE.
You can also use gmane to search the Rev Mailing list. It was possible to do this with Google, but this doesn't work well currently.
http://news.gmane.org/gmane.comp.ide.revolution.user
Maybe, others can add more resources.
Best regards,
Mark
I'm always glad to help. Little mistakes like these can happen to any beginning Revolution programmer. I know it is frustrating in the beginning, but once you know it, the problem is solved for once and forever.
Actually, the only really good documentation that I know of is for HyperCard. If you find a book for HyperCard, I'd buy and read it. For example, the Complete HyperCard Handbook contains very useful parts:
http://books.iuniverse.com/viewgiftoc.a ... 427&page=5
particularly chapters 21, 22, 24, 28, 32 and 35.
After reading this, you could have alook at the scripting conference stacks at
http://support.runrev.com/scriptingconferences/
Among other things, this will show you that there are also important differences between Revolution and HyperCard.
You should also look in Revolution Online, where you will mostly find very simple stacks from which you can learn how things work. Rev Online can be found in the Development menu of the Revolution IDE.
You can also use gmane to search the Rev Mailing list. It was possible to do this with Google, but this doesn't work well currently.
http://news.gmane.org/gmane.comp.ide.revolution.user
Maybe, others can add more resources.
Best regards,
Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode