distal-attribute
distal-attribute
distal-attribute
distal-attribute

auto insertion of ` character in VIEW

User, date Message
Written by Ritesh Mehta
7 months ago
Category: General
4 posts since Tue, 17 Dec 13
Hello Admin,

First of all lots of thanks for developing such a wonderful tool. Its really superb.

I m facing one difficulty in view modification.

1) Have a look at below view which has "`" character, which is auto inserted in view definition. I want to remove it from view definition.
-----------------------------
select `c`.`custcode` AS `custcode`,`c`.`firstname` AS `firstname`,`c`.`middlename` AS `middlename`,`c`.`lastname` AS `lastname`,`c`.`address` AS `address`,`c`.`phone` AS `phone`,`c`.`mobile` AS `mobile`,`c`.`emailid` AS `emailid`,`c`.`active` AS `active`,concat(concat(`c`.`firstname`,concat(' ',`c`.`middlename`)),concat(' ',`c`.`lastname`)) AS `CName` from `ms_customer` `c`

2) I did find/replace. At once, it shows replaced. But after save when i reload it, it again shows it with "`" character.

3) Line breaks also not getting saved.

Please advice corrective action.

Regards,
Ritesh Mehta
Written by ansgar
7 months ago
4936 posts since Fri, 07 Apr 06
That auto-replacement is done by the MySQL server. HeidiSQL cannot do much about it, while trying to get the very original view code you have entered before. In the SQL log window, you should see some "SELECT LOAD_FILE(..." command. You probably don't have the privilege to run that LOAD_FILE, and in that case it all does not help. But if you really want to keep your original VIEW code, than you should enable your user account to run that LOAD_FILE command.
Written by Ritesh Mehta
7 months ago
4 posts since Tue, 17 Dec 13
Oh... got it. tried and working as per need. smile

Thanks a lot
 

Please login to leave a reply, or register at first.