- Feb 19, 2007
- 555
- 1
- 125
hey im getting this error
i think its trying to write mehn to the GUILDLEVEL part that should be a number not mehn
Mehn is the test guild i made
Tables are made and so are the FLDs
any help would be great
Code:
9:31:12:Exception) TFrmSql.WriteSqlValue -> ExecSQL 2
9:31:12: :insert into TBL_GUILDPOINTS (FLD_GUILD,FLD_GUILDLEVEL) Values('mehn')
Code:
#ACT
FormatStr "FLD_GUILD='%s'" %GUILDNAME
mov a2 %a9
ReadValueSql "TBL_GUILDPOINTS" %A9 "FLD_GUILD,FLD_GUILDLEVEL" [@Forward]
[@Forward()]
#ACT
Mov A3 %ARG(1) ;Store GUILD in A3
Mov D1 %ARG(2) ;Store GUILDLEVEL in D1
GOTO @Continue
[@Continue]
#IF
Equal A3 ""
#ACT
FormatStr "'%s'" %GUILDNAME
Mov A6 %A9
FormatStr "FLD_GUILD='%s'" %GUILDNAME
Mov A5 %A9
FormatStr "FLD_GUILDLEVEL='%s'" 1
Mov A4 %A9
WriteValueSql "TBL_GUILDPOINTS" %A4 "FLD_GUILD,FLD_GUILDLEVEL" %A6
GOTO [@FinishMakingGuild]
i think its trying to write mehn to the GUILDLEVEL part that should be a number not mehn
Mehn is the test guild i made
Tables are made and so are the FLDs
any help would be great