tables not pulling through correctly when using sql code
Calum Gale
Tried importing info through posting SQL code and using Eddy to generate within the editor. Below is the screenshot of the code for which EddyAI created new column names
The issue is to do with the conversion of the DB column names in the SQL code.
The DB column names are shown in square brackets in the code.
They want the AI tool to create one row in the table for each DB column and put the name in the Column Title column, then add extra information in the other two columns, but the DB column names are sometimes altered - for example:
[ID] should be ID not IDENTIFIER
[CORE_ENTITY_ID] should be CORE_ENTITY_ID not PRIMARY_ENTITY_ID
[IS_FINAL] should be IS_FINAL not FINAL_STATUS
The first time they ran the AI convert to table, it kept all the DB column names, and the second time it changed them, so it doesn’t seem to be consistent. Is there any way to get it to always recognise the DB column names from the SQL code?
Log In