Toad World® Forums

Export dataset|Insert statement

There is a new format for DATE types in the generated script, it uses ‘.’ instead of ‘/’. How can we override this behavior and set the terminator character to the old one?

change your date format in Toad’s main settings window. It will follow whatever settings you have there.

In Data Grids -> Data

John,

I like the yyyy.mm.dd date format in Data grids, but using it in the script outputs with the same format is not so good: SVN shows all my .dat files has been changed :slight_smile:

Can we use a Date format also for the requested output, or at least override the delimiter char?

Thanks

OK, I’ll add that.

EurekaLog 7.3.1.0

Application:


1.1 Start Date : Mon, 15 Feb 2016 21:32:42 +0100

1.2 Name/Description: Toad.exe - (Toad™ for Oracle®)

1.3 Version Number : 12.9.0.28

1.4 Parameters :

1.6 Up Time : 2 minute(s), 0 second(s)

Exception:


2.1 Date : Mon, 15 Feb 2016 21:34:43 +0100

2.2 Address : 00000000047B19A4

2.3 Module Name: Toad.exe - (Toad™ for Oracle®)

2.5 Type : ERegularExpressionError

2.6 Message : Successful match required.

2.7 ID : B3400000

2.8 Count : 1

2.11 Sent : 0

Active Controls:


4.1 Form Class : TDateFormatForm

4.2 Form Text : Date Format

4.3 Control Class: TToadCheckBox

4.4 Control Text : Use system default

Computer:


5.2 Total Memory : 8500920320 (7,92 Gb)

5.3 Free Memory : 5002121216 (4,66 Gb)

5.4 Total Disk : 255953203200 (238,37 Gb)

5.5 Free Disk : 116511780864 (108,51 Gb)

5.6 System Up Time : 1 day(s), 9 hour(s), 13 minute(s), 34 second(s)

5.7 Processor : Intel® Core™ i7-4710MQ CPU @ 2.50GHz

5.12 Virtual Machine:

Operating System:


6.1 Type : Microsoft Windows 7 (64 bit)

6.2 Build #: 7601 (6.1.7601.18015)

Steps to reproduce:


8.1 Text:

Call Stack Information:


|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |


|*Exception Thread: ID=1216; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|

|7FFFFFFE|04 |0000000000000000|00000000047B19A4|Toad.exe |00000000006219A4|System.RegularExpressionsCore|TPerlRegEx |GetGroups |612[2] |

|00000040|03 |000000000042C9A8|00000000047B2DFC|Toad.exe |0000000000622DFC|tdPerlRegEx |TtdPerlRegEx |GetMatchedExpression | |

|00000040|03 |000000000042C9F8|00000000085D8446|Toad.exe |0000000004448446|frmDateFormat |TDateFormatForm |SetDateFormat | |

|00000040|03 |000000000042CAF8|00000000085D8B52|Toad.exe |0000000004448B52|frmDateFormat |TDateFormatForm |chkSysDefaultClick | |

|00000040|04 |000000000042CB28|0000000004478984|Toad.exe |00000000002E8984|Vcl.Controls |TControl |Click |7320[9] |

|00000040|04 |000000000042CB68|00000000044B22B3|Toad.exe |00000000003222B3|Vcl.StdCtrls |TCustomCheckBox |Click |5836[2] |

|00000040|04 |000000000042CB98|00000000044B236F|Toad.exe |000000000032236F|Vcl.StdCtrls |TCustomCheckBox |SetState |5865[6] |

|00000040|04 |000000000042CBD8|00000000044B2123|Toad.exe |0000000000322123|Vcl.StdCtrls |TCustomCheckBox |Toggle |5816[10] |

|00000040|04 |000000000042CC88|00000000044B2655|Toad.exe |0000000000322655|Vcl.StdCtrls |TCustomCheckBox |CNCommand |5928[1] |

|00000040|04 |000000000042CCB8|000000000419CE6E|Toad.exe |000000000000CE6E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042CD08|00000000044780C3|Toad.exe |00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042CE78|000000000447F4A3|Toad.exe |00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|04 |000000000042CF48|00000000044AFFC0|Toad.exe |000000000031FFC0|Vcl.StdCtrls |TButtonControl |WndProc |5002[13] |

|00000040|04 |000000000042CF88|0000000004477B9D|Toad.exe |00000000002E7B9D|Vcl.Controls |TControl |Perform |6982[10] |

|00000040|04 |000000000042CFE8|000000000447F689|Toad.exe |00000000002EF689|Vcl.Controls | |DoControlMsg |10045[12] |

|00000040|04 |000000000042D028|00000000044809F3|Toad.exe |00000000002F09F3|Vcl.Controls |TWinControl |WMCommand |10320[1] |

|00000040|04 |000000000042D068|00000000045F56A8|Toad.exe |00000000004656A8|Vcl.Forms |TCustomForm |WMCommand |6105[3] |

|00000040|04 |000000000042D0A8|000000000419CE6E|Toad.exe |000000000000CE6E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042D0F8|00000000044780C3|Toad.exe |00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042D268|000000000447F4A3|Toad.exe |00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|04 |000000000042D338|00000000045F0B1B|Toad.exe |0000000000460B1B|Vcl.Forms |TCustomForm |WndProc |4344[201] |

|00000040|04 |000000000042D3F8|000000000447E717|Toad.exe |00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |000000000042D448|000000000426E144|Toad.exe |00000000000DE144|System.Classes | |StdWndProc |13895[8] |

|00000040|03 |000000000042D498|00000000778B9C0A|user32.dll |0000000000019C0A|USER32 | | (possible TranslateMessageEx+662) | |

|00000040|03 |000000000042D558|00000000778B72F2|user32.dll |00000000000172F2|USER32 | | (possible SetWindowTextW+638) | |

|00000040|03 |000000000042D5B8|00000000778B6836|user32.dll |0000000000016836|USER32 | | (possible IsDialogMessageW+358) | |

|00000040|03 |000000000042D618|0000000077B0D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |

|00000040|03 |000000000042D6A0|00000000778B686A|user32.dll |000000000001686A|USER32 | | (possible IsDialogMessageW+410) | |

|00000040|03 |000000000042D6A8|00000000778B3805|user32.dll |0000000000013805|USER32 | | (possible GetWindowLongPtrA+113) | |

|00000040|03 |000000000042D738|00000000778B6BB8|user32.dll |0000000000016BB8|USER32 | |SendMessageW | |

|00000040|03 |000000000042D788|000007FEFBC20C6E|comctl32.dll |00000000000A0C6E|comctl32 | |CreateMRUListW | |

|00000040|03 |000000000042D7C8|000007FEFBC248AD|comctl32.dll |00000000000A48AD|comctl32 | |CreateMRUListW | |

|00000040|03 |000000000042D888|00000000778B9C0A|user32.dll |0000000000019C0A|USER32 | | (possible TranslateMessageEx+662) | |

|00000040|03 |000000000042D948|00000000778B3BCF|user32.dll |0000000000013BCF|USER32 | | (possible CallWindowProcW+151) | |

|00000040|03 |000000000042D998|00000000778B3B4B|user32.dll |0000000000013B4B|USER32 | |CallWindowProcW | |

|00000040|04 |000000000042D9D8|000000000447F62C|Toad.exe |00000000002EF62C|Vcl.Controls |TWinControl |DefaultHandler |10017[30] |

|00000040|04 |000000000042DA18|000000000447902A|Toad.exe |00000000002E902A|Vcl.Controls |TControl |WMLButtonUp |7453[1] |

|00000040|04 |000000000042DA88|000000000419CE6E|Toad.exe |000000000000CE6E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042DAD8|00000000044780C3|Toad.exe |00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042DC48|000000000447F4A3|Toad.exe |00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|04 |000000000042DD18|00000000044AFFC0|Toad.exe |000000000031FFC0|Vcl.StdCtrls |TButtonControl |WndProc |5002[13] |

|00000040|04 |000000000042DD58|000000000447E717|Toad.exe |00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |000000000042DDA8|000000000426E144|Toad.exe |00000000000DE144|System.Classes | |StdWndProc |13895[8] |

|00000040|03 |000000000042DDF8|00000000778B9C0A|user32.dll |0000000000019C0A|USER32 | | (possible TranslateMessageEx+662) | |

|00000040|03 |000000000042DEB8|00000000778B9925|user32.dll |0000000000019925|USER32 | | (possible TranslateMessage+485) | |

|00000040|04 |000000000042DF48|00000000045FEA5F|Toad.exe |000000000046EA5F|Vcl.Forms |TApplication |ProcessMessage |10164[23] |

|00000040|04 |000000000042DFC8|00000000045FEAD3|Toad.exe |000000000046EAD3|Vcl.Forms |TApplication |HandleMessage |10194[1] |

|00000040|04 |000000000042E038|00000000045F7BA8|Toad.exe |0000000000467BA8|Vcl.Forms |TCustomForm |ShowModal |7035[33] |

|00000040|03 |000000000042E0D8|00000000085D8BBE|Toad.exe |0000000004448BBE|frmDateFormat |TDateFormatForm |EditDateFormat | |

|00000040|03 |000000000042E128|00000000085EAD94|Toad.exe |000000000445AD94|frmGridSaveAs |TFormGridSaveAs |btnDMLDateFormatClick | |

|00000040|04 |000000000042E178|0000000004478984|Toad.exe |00000000002E8984|Vcl.Controls |TControl |Click |7320[9] |

|00000040|04 |000000000042E1B8|00000000044B0536|Toad.exe |0000000000320536|Vcl.StdCtrls |TCustomButton |Click |5160[3] |

|00000040|04 |000000000042E1E8|00000000044B14B2|Toad.exe |00000000003214B2|Vcl.StdCtrls |TCustomButton |CNCommand |5621[1] |

|00000040|04 |000000000042E228|000000000419CE6E|Toad.exe |000000000000CE6E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042E278|00000000044780C3|Toad.exe |00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042E3E8|000000000447F4A3|Toad.exe |00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|04 |000000000042E4B8|00000000044AFFC0|Toad.exe |000000000031FFC0|Vcl.StdCtrls |TButtonControl |WndProc |5002[13] |

|00000040|04 |000000000042E4F8|0000000004477B9D|Toad.exe |00000000002E7B9D|Vcl.Controls |TControl |Perform |6982[10] |

|00000040|04 |000000000042E558|000000000447F689|Toad.exe |00000000002EF689|Vcl.Controls | |DoControlMsg |10045[12] |

|00000040|04 |000000000042E598|00000000044809F3|Toad.exe |00000000002F09F3|Vcl.Controls |TWinControl |WMCommand |10320[1] |

|00000040|04 |000000000042E5D8|000000000419CE6E|Toad.exe |000000000000CE6E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042E628|00000000044780C3|Toad.exe |00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042E798|000000000447F4A3|Toad.exe |00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|04 |000000000042E868|000000000447E717|Toad.exe |00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |000000000042E8B8|000000000426E144|Toad.exe |00000000000DE144|System.Classes | |StdWndProc |13895[8] |

|00000040|03 |000000000042E908|00000000778B9C0A|user32.dll |0000000000019C0A|USER32 | | (possible TranslateMessageEx+662) | |

|00000040|03 |000000000042E9C8|00000000778B72F2|user32.dll |00000000000172F2|USER32 | | (possible SetWindowTextW+638) | |

|00000040|03 |000000000042EA28|00000000778B6836|user32.dll |0000000000016836|USER32 | | (possible IsDialogMessageW+358) | |

|00000040|03 |000000000042EA88|0000000077B0D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |

|00000040|03 |000000000042EB10|00000000778B686A|user32.dll |000000000001686A|USER32 | | (possible IsDialogMessageW+410) | |

|00000040|03 |000000000042EB18|00000000778B3805|user32.dll |0000000000013805|USER32 | | (possible GetWindowLongPtrA+113) | |

|00000040|03 |000000000042EBA8|00000000778B6BB8|user32.dll |0000000000016BB8|USER32 | |SendMessageW | |

|00000040|03 |000000000042EBF8|000007FEFBC20C6E|comctl32.dll |00000000000A0C6E|comctl32 | |CreateMRUListW | |

|00000040|03 |000000000042EC38|000007FEFBC248AD|comctl32.dll |00000000000A48AD|comctl32 | |CreateMRUListW | |

|00000040|03 |000000000042ECF8|00000000778B9C0A|user32.dll |0000000000019C0A|USER32 | | (possible TranslateMessageEx+662) | |

|00000040|03 |000000000042EDB8|00000000778B3BCF|user32.dll

What was in the “Date format” box before you clicked the “…” button? Sounds like it might have been blank.

It was mm/dd/yyyy.

My Date format setting in Toad Options|Data grids|Data is yyyy.mm.dd.

Hmmm. In WIndows, if you go to “Region and Language”, what do you have for the “Short Date” format?

I noticed that a space is allowed there as a date separator - that could be a problem but I fixed it for next beta.

www.dropbox.com/…/Névtelen.png

Thanks. That window should open without error next beta.