Good morning,
I’ve just upgraded to 7.7.6.7 and have a couple of Q’s:
1) My previous Imports used double quotes consistently around field names such as "[F1]" – does this mean I need to change each and every one now to remove this? If so, is there a function to change this throughout to make the conversion easier?
- These field are now being imported with quotes around them in the data
2) I can’t find the menu item referenced in #3 below “Correct calculations” – Can you tell me where this is located?
Thanks
*****************************************************
7.7.6.7
Various bugs fixes
Repository creation wizard was introduced
7.7.6.6
Problem with null dates was resolved
7.7.6.5
Major update
Calculations and scripting language changes
Syntax is slightly different now
1 source fields are always strings
a) no need to use "[F1]"
b) [F1]+[F2] will concatenate two fields
if you want to add them use conversion functions
StrtoFloat([F1])+StrtoFloat([F2])
2 use single quotes instead of double quotes
eg GetSystemVariable('SYSTEM_DATE') GetSystemVariable("SYSTEM_DATE")
3 in order to make conversion easier we have added new menu item
"Correct calculations"
4 Lots of new functions, procedures and language changes (see documentation)
Date time fields support
Default Format was changed to YYYY-MM-DD HH:NN:SS.ZZZ for ODBC and SQL server connections
They also support fractions of seconds now
