How to update SQL database?

[Angelina Garibaldi]

Please excuse English errors I make.

I hope there is solution to this.

I have Filemaker Pro 8.5 database. I want button that will push certain fields from Filemaker database to external MySQL database.

I have ODBC set fine; because I know I test with "Execute SQL":

insert into REGUSERS (Name) values ("This is test")

and it works fine and updates MySQL database.

But I need it to update external database with value from current record, not string literal.

The field name in Filemaker database is "UserName" is what I want to push to MySQL database.

I have tried thises:

insert into REGUSERS (Name) values (UserName)

insert into REGUSERS (Name) values (& UserName &)

insert into REGUSERS (Name) values (&UserName&)

insert into REGUSERS (Name) values ("& UserName &")

insert into REGUSERS (Name) values ('& UserName &')

insert into REGUSERS (Name) values ("UserName")

insert into REGUSERS (Name) values ('UserName')

None of thises work. I get error or the variable name into SQL database, not value of variable.

I do not what to do. Please, please help!

If this can not be done in Filemaker, please tell me.

[Angelina Garibaldi]

Never mind. I finally figured it out. No replies to my question? This forum is worth what I paid for it (absolutely nothing).

[LaRetta]

That was uncalled for. :

[AudioFreak]

lol Welcome to the Forums . How about posting the solution or giving a hand to this person asking basically the same thing you just solved. :

http://www.fmforums.com/forum/showtopic.php?tid/189529

Michael

[mr_vodka]

Never mind. I finally figured it out. No replies to my question? This forum is worth what I paid for it (absolutely nothing).

First of all, these forums are free but people donate to it because they LIKE it.

Second, these forums have helped many many users out there so I am sure that a lot of people would disagree with you.

Third, this is not tech support. Do not DEMAND that your question be answered. We all have jobs to do as well as work. We volunteer our time to help others and if we get busy we sometimes can not help as much as we want to. There is nothing that says that we HAVE to answer your questions... You could have just as easily called FMI's tech support and paid $45 for the call & $3 a minute. http://www.filemaker.com/support/priority.html

Fourth, if you did figure it out and you are not sharing the answer to spite the forums, then you are not a part of the solution. These forums exist so that people can help EACH OTHER.

Now, I do not know your exact situation, but my guess would be because you would have to have the SQL code be something like:

"insert into REGUSERS (Name) values (" & UserName & ")"