[CD3.55] This script works well, but in my SQL no type the guildname

[Yolom]

Hello, I have a script Zordon release.
And there is a problem in this place:


[@main]
#IF
HasGuild
#ACT
FormatStr "FLD_GUILD='%s'" %GUILDNAME
ReadValueSql "TBL_GUILD" %A9 "FLD_GUILD,FLD_GUILDBANK" [@THegoldstuff1]
#ELSESAY
You dont have a guild.\


[@THegoldstuff1()]
#ACT
Mov D1 %ARG(2) ;Retrieves gold amount
Mov A3 %ARG(1) ;Retrieve guild name
#IF
Equal A3 "" ;If there is no guild listed under this name it makes an entry below
#ACT
FormatStr "'%s',%s" %GUILDNAME 0
Mov A8 %A9
FormatStr "FLD_GUILD='%s'" %GUILDNAME
Mov A2 %A9
WriteValueSql "TBL_GUILD" %A2 "FLD_GUILD,FLD_GUILDBANK" %A8
goto @menu
#ELSEACT
goto @menu


That's what I said in CD:


12:32:14:Exception) TFrmSql.ReadSqlValue -> Open
12:32:14: :select FLD_GUILD,FLD_GUILDBANK from TBL_GUILD where FLD_GUILD='Testeo'
12:32:14:Exception) TFrmSql.WriteSqlValue -> ExecSQL 1
12:32:14: :delete from TBL_GUILD where FLD_GUILD='Testeo




I know that the problem occurs in this part of the script, because the first time I donate gold leaves me, and when I talk to says that I have 0 Gold

I was separate the script, put it to pick up gold is another NPC, then let me pick what I donated.
But the problem is: if I talk to the NPC to donate Gold, values ​​again become 0.


Thanks