kriki wrote:kriki wrote:datFirstDayOfMonth := DMY2DATE(1,DATE2DMY(datSomeDate,2),DATE2DMY(datSomeDate,3)));
Did see that also the last day of the month was needed:datLastDayOfMonth := CALCDATE('<1M>',datFirstDayOfMonth) - 1;
datLastDayOfMonth := CALCDATE('<CM>',datMyDate);
Hi dipakpatel2505,dipakpatel2505 wrote:Hi Alex9,
The code field is primary key field and in other table, Fields are connected with this field using Table Relation.
The problem might be that when you try to rename field "Code" shown in screenshot, it also goes to update other field value whose are connected with "Code" field in Table relation Property. You should check for all fields and their data type which are connected with "Code" field and their data type.
I think data type of any one field does not match with the data type of "Code" field .
If suggestion has solved your problem then please do not forget to mark it as solved.
LOCAL ReplaceString(String : Text;FindWhat : Text;ReplaceWith : Text) NewString : Text FindPos := STRPOS(String,FindWhat); WHILE FindPos > 0 DO BEGIN NewString += DELSTR(String,FindPos) + ReplaceWith; String := COPYSTR(String,FindPos + STRLEN(FindWhat)); FindPos := STRPOS(String,FindWhat); END; NewString += String;
ReplaceString(XMLBody,'"','\"');