MySQL Keyword problem

Classic Servoy
1

Using Servoy Version: 8.4.0.3402 on Windows 10.

I’m generating Servoy forms using the Solution Model.

When I make a text field using code like this:

var oTextField = goJSForm.newTextField( sTblFldName, oCoords.iFieldX, oCoords.iFieldY, giFieldW, giFieldH );

If the value of sTblFldName is a MySQL keyword, such as Security or Status for example, there is no problem. The screen is generated and properly populated.

But when I add a JavaScript variable like:

var oJSVar = goJSForm.newVariable( sTblFldName, JSVariable.TEXT );

When the form is displayed the following truncated error trace is seen:

ERROR com.servoy.j2db.util.Debug - there is a keyword with name Security (Form Context: main), JSEvent(type = action, source = Component: <'svy_1073742067' of parent FormUI for FormController[form: main, fs size:0, selected record: null,destroyed]>, formName = main, elementName = <no name>, timestamp = 2019-04-15 09:13:13.408,modifiers = 0,x =146,y = 37,data = null)
	at C:\Users\terry.QUANTECH\servoy_workspace\quantech\SnappMXStuff.js:370 (addTextField)

It is hard for me to understand why the TextField is fine but the JavaScript variable has a problem.

I see that there is an option when importing a solution called:

Allow reserved SQL keywords - This option will allow reserved SQL keywords to be used for names in the database

Is there a way to apply that to a solution being developed?

thanks,

Terry

2

I have tried making a screen that has these other reserved keywords: Engine, Status.

I was able without any problem to create both the TextField and JavaScript variable with a dataProvider value of Engine or of Status. And those are both MySQL Keywords.

Anyone have any thoughts on this?

3

After more exploration I’m starting to suspect the following, subject to correction by those who actually know what is going on:

  1. That the Servoy Developer runs in a mode where it does not give errors for the use of SQL keywords

  2. Because “Security” is a Servoy keyword, using that for a JavaScript variable name produces an error.

That still leaves unclear to me what it means to have a screen widget like a TextField with a dataProvider name of MyColumn and a JavaScript variable with a dataProvider name of MyColumn.

I have seen that in example code but nothing in the Servoy Wiki explains what if means or is used for, if anything.

Can anyone shed any light on that?

thanks,

Terry

4

tkilshaw1553613063:
That still leaves unclear to me what it means to have a screen widget like a TextField with a dataProvider name of MyColumn and a JavaScript variable with a dataProvider name of MyColumn.

I’m not entirely sure what you want to know, but to use a textfield, it needs to have a data provider. This can be a column from a table, but also a form variable or scope variable.
If a user enters a value in the field, it ends up in the column or variable and vice versa.
Having a textfield without a dataprovider doesn’t make much sense, because you can’t really get the value if the field was filled.

5

Joas,

my thanks again.

Your reply helps a bit and what you have written would certainly be of value in the Wiki.

That still leaves me with horsey and ducky question of, how do you get the value of a TextField that has a column data provider?

Terry

6

See my answer here, because it is basically the same question :)