Syntax Error near "?"

[westingtyler]

In the image. I get an error here, and I'm not sure why. 

Also as a second note, if the requested response string starts or ends with a space, will this also throw an error since it messes with the synax? if so, is there any way to avoid this? the players can edit these files, and if they make a mistake, I don't want the game to break. So is there a way to modify this action to send an error event in the fsm that I can do a special event for, instead of breaking the game? like a field for "if error" (send event)? Like "if table doesn't exist, or if cell doesn't exist, or if cross-referencer does not exist". or "if response exists but is empty." then I could send an in-game error message saying specifically what was missing that needs fixing. It would also sometimes be handy to have actions such as "Table Exists?" "Column Exists?" "Cell Exists?" "Cell is Empty?" etc. but if I had to choose, modifying the original single row query action to allow error cases would be simpler.

Also I realized... does this mean I can't include ? in the dialogue text entries because it will throw an error? So i can never have a character say "Biscuits? No, thanks. But do you want a pet rock?" If this is true, it would be great if I could specify which symbol would be a wild card int the query action. so instead of ?, I could use / or * or @.... something my characters would never need in normal dialogue?

Here's the full console error: 


SQLiteException: near "?": syntax error
SimpleSQL.SQLite3.Prepare2 (IntPtr db, System.String query)
SimpleSQL.SQLiteCommand.Prepare ()
SimpleSQL.SQLiteCommand.ExecuteQueryGeneric ()
SimpleSQL.SimpleSQLManager.QueryGeneric (System.String query, System.Object[] args)
SimpleSQL_Query_SingleRow.DoQuery () (at Assets/PlayMaker/Actions/SimpleSQL/SimpleSQL_Query_SingleRow.cs:75)
SimpleSQL_Query_SingleRow.OnEnter () (at Assets/PlayMaker/Actions/SimpleSQL/SimpleSQL_Query_SingleRow.cs:29)
HutongGames.PlayMaker.FsmState.ActivateActions (Int32 startIndex) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:205)
HutongGames.PlayMaker.FsmState.OnEnter () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:175)
HutongGames.PlayMaker.Fsm.EnterState (HutongGames.PlayMaker.FsmState state) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2767)
HutongGames.PlayMaker.Fsm.SwitchState (HutongGames.PlayMaker.FsmState toState) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2714)
HutongGames.PlayMaker.Fsm.UpdateStateChanges () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2642)
HutongGames.PlayMaker.Fsm.DoTransition (HutongGames.PlayMaker.FsmTransition transition, Boolean isGlobal) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2681)
HutongGames.PlayMaker.Fsm.ProcessEvent (HutongGames.PlayMaker.FsmEvent fsmEvent, HutongGames.PlayMaker.FsmEventData eventData) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2252)
HutongGames.PlayMaker.Fsm.SendEventToFsmOnGameObject (UnityEngine.GameObject gameObject, System.String fsmName, HutongGames.PlayMaker.FsmEvent fsmEvent) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2621)
HutongGames.PlayMaker.Fsm.Event (HutongGames.PlayMaker.FsmEventTarget eventTarget, HutongGames.PlayMaker.FsmEvent fsmEvent) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2388)
HutongGames.PlayMaker.Actions.SendEvent.OnEnter () (at Assets/PlayMaker/Actions/SendEvent.cs:42)
HutongGames.PlayMaker.FsmState.ActivateActions (Int32 startIndex) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:205)
HutongGames.PlayMaker.FsmState.OnEnter () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:175)
HutongGames.PlayMaker.Fsm.EnterState (HutongGames.PlayMaker.FsmState state) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2767)
HutongGames.PlayMaker.Fsm.SwitchState (HutongGames.PlayMaker.FsmState toState) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2714)
HutongGames.PlayMaker.Fsm.UpdateStateChanges () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2642)
HutongGames.PlayMaker.Fsm.UpdateState (HutongGames.PlayMaker.FsmState state) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2783)
HutongGames.PlayMaker.Fsm.Update () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:1994)
PlayMakerFSM.Update () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/PlayMakerFSM.cs:579)






=============================
Now I keep getting this error that there's no column by the name none:





and here's what my sql looks like:



What am i getting wrong?


in the debug of the fsm you can see a correct response. i get that when I use "SELECT ResponseEng FROM Jeff WHERE ResponseEng = ResponseEng" which seems totally messed up? At runtime I'm altering this statement to try to get it to work. does that work?

Attachments:

[westingtyler]

I did two different queries here. one got a response, the other didn't. the weird stupid one got the response. am i going nuts?

[echo17]

The ? parameters are optional and are only to be used in either where clauses, update values, or insert values, like:

SELECT * FROM Location WHERE LocationID = ?

or

UPDATE PlayerStats SET PlayerName = ?, TotalKills = ?, Points = ? WHERE PlayerID = ?

or

INSERT INTO PlayerStats (PlayerName, TotalKills, Points) VALUES (?, ?, ?)

Take a look at the user manual here for more examples and explanations. You can also find numerous examples of usage in the demo scripts that come with the plugin. They are all scripted, but the sql query strings should give you some idea of how to formulate your queries for Playmaker since the sql queries themselves use the same format.

You can still use question marks in your values that are being substituted. SimpleSQL will take something like:

SELECT * FROM MyTable WHERE MyValue = ?

And if you substitute a value like "A Rock?", it will generate behind the scenes:

SELECT * FROM MyTable WHERE MyValue = 'A Rock?'

Keep in mind that using the question mark parameters is entirely optional and there for convenience. You can easily just build your own strings using Playmaker string concatenation functions and leave out the question marks entirely if you choose.

To get the list of tables in your database, you can use:

SELECT name FROM sqlite_master WHERE type = 'table'

(from the FAQ: link)

[westingtyler]

Thanks. I have a really specific question. Using all the provided examples, etc. I have an IDEA of how to phrase what I need, but I keep getting the error, so i was asking for specific help about that specific example. Here is what I am trying to do, and I can't figure out why it doesn't work. Is there a space somewhere? or a missing equals sign? 

Here is a picture explaining exactly what I'm trying to get:




What specifically am I doing wrong in my phrasing? Thanks!

PS. Also, these links do not work: 

""Q: Where can I find API documentation or a user guide?



All links relevant to this plugin can be found on the webpage at:



www.echo17.com/simplesql.html



Direct links:



User Guide: www.echo17.com/support/simplesql_user_manual.pdf

API Docs: www.echo17.com/support/simplesql_api_documentation/index.html""

[echo17]

So the problem you are having is that you are using parameters for the field list and the table name. Parameters should only be used in the three instances outlined in my last post. If you need to generate dynamic field lists or table names, you will have to use a string concatenator (BuildString action seems to fit the bill) in Playmaker. Keep in mind that parameters are completely optional and you could build the string entirely yourself. Parameters take care of the minutia of the sql syntax, like quotation marks, etc for the WHERE clause, INSERT fields, or UPDATE fields.

Also, your response field should be static unless I am misunderstanding your project design. It would seem that the response field will always be ResponseEng so you should not need to build that dynamically. Here is an example of how I set up a BuildString in conjunction with SimpleSQL_Query_SingleRow with your setup:

Note: there is a space after the first element of the BuildString, after the FROM. There is also a space before the WHERE in the last element. You could probably use a separator of a space in the BuildString. I have not used this action, so I am not entirely familiar with it. This is so the final string gets built like (example using Jeff as the value of the TableName variable):

"SELECT ResponseEng FROM Jeff WHERE ItemEquipped = ?"

These are the variables used:

The final result of the response is stored in ResponseEng.

Thanks for the heads up on the links. I copied my old forum over to this new one and forgot to update all the links. Appreciate it!