![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
[9.2.349 Pro] - B: Scripting Table/View Data |
|
When Scripting Table/View Data, the resulting script contains semicolons instead of commas in VALUES part.
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
/************************************************************
* Generated by SoftTree SQL Assistant © 9.2.349
* Time: 2017-11-16 14:21:50
* Source:
************************************************************/
/* Inserting [DATA].[dbo].[foldhely] data... */
INSERT INTO [DATA].[dbo].[foldhely]([foldhely_id],[foldhely_nev],[foldhely_rnev],[foldhely_zona],[foldhely_gps_x],[foldhely_gps_y],[foldhely_gps_z],[felirat_id],[hang_id],[WAP_kod],[aktiv_e],[datum_tol],[datum_ig],[gyakorisag],[foldhely_helyi_nev],[veg_nev],[megallo_kod],[PihAlk])
VALUES(4721;'Kisfái, aut. ford. ';'Kisfái, aut. ford. ';0;0;0;0;126;35;' ';FALSE;'2014-10-28 00:00:00';'2015-04-15 00:00:00';0;N'Kisfái, aut. ford. ';'Kisfái, aut. ford. ';'';NULL);
INSERT INTO [DATA].[dbo].[foldhely]([foldhely_id],[foldhely_nev],[foldhely_rnev],[foldhely_zona],[foldhely_gps_x],[foldhely_gps_y],[foldhely_gps_z],[felirat_id],[hang_id],[WAP_kod],[aktiv_e],[datum_tol],[datum_ig],[gyakorisag],[foldhely_helyi_nev],[veg_nev],[megallo_kod],[PihAlk])
VALUES(4721;'Kisfái, aut. ford.';'Kisfái, aut. fo ';0;0;0;0;126;35;' ';TRUE;'2015-04-16 00:00:00';NULL;0;N'Kisfái, aut. ford. ';'Kisfái, aut. ford.';'';NULL);
.
.
.
|
|
|
Thu Nov 16, 2017 9:27 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Is that a reproducible issue? Occurs for all tables?
|
|
Thu Nov 16, 2017 3:41 pm |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
It happened consistently on all the tables I tried in SQL Server and in an SQLite database as well. It seems it is mixing exporting data to script with exporting it to csv.
|
|
Fri Nov 17, 2017 6:22 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
I got some help and can now assist you with restoring the default value separator.
In SQL Assistant SQL Editor export any table data to CSV using the Export to... menu. Select CSV output format, in export dialog change "Value Separator" to "," click Ok to export it.
Now if you restart the editor, scripting table/view data should revert back to "," separator.
|
|
Fri Nov 17, 2017 3:06 pm |
|
![](templates/GreenTech/images/spacer.gif) |
gemisigo
Joined: 11 Mar 2010 Posts: 2109
|
|
|
|
Thanks, that did the job.
Any reason for having scripts using that separator setting? I mean scripts will always have to have the comma in VALUES.
|
|
Sun Nov 19, 2017 8:39 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
That behavior is unintentional. It will be fixed in the next maintenance release.
|
|
Sun Nov 19, 2017 12:39 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|