I’m using Kinetic Web Base 11.2.200. I have a BAQ that is returning six numeric fields, but the DataView is receiving the data as strings instead of numbers. In Application Studio I see all six fields coming in, but the Date Type and Format fields are blank and I can not enter anything in those fields. What do I need to do for the DataSet to interrupt those fields as numbers instead of strings?
You might want to try deleting and re-creating your DataView. It should pick up the Type and Formats from the BAQ when you first create it.
I initially used the conversion tool to convert an application in classic to the web. I then went in and saw the DataView was created, but it wasn’t connected to a BAQ (and there were not column names). After connecting the DataView to the desired BAQ the columns names appeared, but I had no ability to edit the Data Type nor Format. So you think if I delete this DataView and reenter is that if might allow me to edit those fields?
I tried creating a new DataView connecting to the same old BAQ and I still cannot edit the Data Type and Format values for the columns.
Must a dataview be connected to a server dataset for the column Data Type and Format to be enabled?
You don’t change it in the dataview, you change the erp editor in the column settings for the grid that is bound to the dataview.
1 Like
If by erp editor you mean the following, then the data type and format are disabled with connecting to a BAQ.
@aosemwengie1 referring to these settings:
Go into your panel card grid properties > Grid Model > Columns… and you can make changes there to the ERP Editor settings.
4 Likes
