Yes, I see Nulls in Red. Turning off that option allowed me to see the date value of 0001-01-01 (which is a valid date in the eyes of DB2 but evidently not in...
4471
glen.wenzel
May 21, 2010 5:29 pm
Hi, I am trying to create a temp table based on records that are stored in an Excel spreadsheet. The db is Informix 9.52 . Here is what I'm trying: Create...
4472
glen.wenzel
May 21, 2010 6:29 pm
Hi Phil/Tony, I'm not exactly sure what I changed, but this is working now. My only remaining issue is what I need to do to prevent the Excel spreadsheet from...
4473
LBZH
May 21, 2010 11:16 pm
I am in Query Builder and the table I am working on is quite large. I attempt to scroll down to the bottom of the field list and can only get so far, then it...
4474
cardett_troy
May 24, 2010 10:27 pm
Hi Glen, AQT will always open Excel when doing an export. It needs Excel active in order to comminicate/export to it. You can use --aqt closexl to close Excel...
4475
cardett_troy
May 25, 2010 8:41 pm
Hi, Can you tell me what version of AQT you are using: Help > About Also, do you know how many items are in the field list? Would you be able to send me a...
4476
bjorn.lanzen
May 26, 2010 7:43 am
The problems below seems to be solved in 9.04. There is a new problem now when I try to edit an IN/INOUT-parameter in the 'Run Procedure' window. If the...
4477
sandromos@...
sandromos...
May 26, 2010 5:13 pm
Hi, if I work with many sql windows, it's very helpful to rename the sql window button. To relate a sql window to a result window, an automatic renaming of the...
4478
cardettnz
May 26, 2010 6:17 pm
There's currently no way of doing what you suggest. When you are viewing a Data Display window, you can go Window > "Go to SQL Window" (or Ctrl+W) to go to the...
4479
voyagr7
May 26, 2010 8:15 pm
When trying to export data to a spreadsheet this error occurs: "Processing error at export_data at line 550 SaveAs method of Workbook class failed" Can you...
4480
cardett_troy
May 26, 2010 10:38 pm
Hi, Can you tell me what version of AQT you are using? Also, what version of Excel? Does this happen all the time or periodically? Thanks in advance. -- Troy...
4481
cardett_troy
May 27, 2010 12:04 am
Hi, I'm having some difficulty reproducing this behaviour, could you provide some screenshots? Send to: troy@... Thanks in advance. -- Troy Pascoe ...
4483
WilliamS
williamstand...
May 27, 2010 4:48 pm
2 features that would be very helpful are: 1) in the query builder window; put an icon on the results tabs expand to data display window view 2) display full...
4484
voyagr7
May 27, 2010 8:54 pm
AQT Standard Edition 8.2.8 and MS Office Excel 2007. Thank you for looking into this! We did try re-installing 8.2.8 over the existing install, but that didn't...
4485
addm92
May 27, 2010 8:54 pm
What does it mean when the Default Objects Value1 is a period and Value2 is null or empty? Keep in mind this is NOT the Default Value....
4486
WilliamS
williamstand...
May 27, 2010 9:17 pm
When I try to load an Oracle table from Access and both connections are open I get a message stating that I'm not logged onto access. Thanks in Advance Phil...
4487
cardett_troy
May 27, 2010 9:26 pm
Ok, I'll put these on the Requested Feature list. Regards. -- Troy Pascoe Technical Support Cardett Associates Ltd troy@... =================== AQT...
4488
cardett_troy
May 27, 2010 9:58 pm
Would you be able to create a debug file to help me diagnose the problem? Can you go to Options > General - and select "Debug Mode", reproduce the problem, and...
4489
cardett_troy
May 27, 2010 11:12 pm
Hi, Could you tell me what type of DB you are using? Also, what version of AQT? If you look at the table in the Database Explorer window and select "Columns"...
4490
cardett_troy
May 27, 2010 11:56 pm
In the Database Explorer window, from the main menu, if you select: File > Reconnect to all Databases - Do you still get this message? Regards. -- Troy Pascoe ...
4491
addm92
May 28, 2010 7:00 pm
yes, originally, moved from an ms access to SQL server 2005. Now we are moving from SQL server 2005 to 2008 Version 8.2.5...
4492
Dan
addm92
May 28, 2010 7:00 pm
Not sure if this is the email you wanted me to send the attachment, but this is the only one I found available. Dan Re: Compare Tables Default object Value1 <>...
4494
cardettnz
May 29, 2010 7:26 am
Could you send the attachments to troy@... - they get stripped out if you send them to this group. Phil....
4495
cardett_troy
Jun 1, 2010 1:24 am
Hi, I have a fix for you. I have added a "Edit parm" button at the bottom of the "Run Procedure" window. You can download from: ...
4496
cardett_troy
Jun 2, 2010 12:56 am
I'm not sure why Default Object is returned as "." - we will look into it further. In the meantime, if this is something you do not need to test for, you can...
4497
bjorn.lanzen
Jun 2, 2010 10:41 am
Hi, I have downloade the fix (aqtdbinterface.dll 1.0.3777.38541) and it's in the aqtv9 directory, but no Edit button turns up. (I´m now running on a trial...
4498
bjorn.lanzen
Jun 2, 2010 10:54 am
Hi, I have downloade the fix (aqtdbinterface.dll 1.0.3777.38541) and it's in the aqtv9 directory, but no Edit button turns up. (I´m now running on a trial...
4499
Janice
itsonlyme4
Jun 2, 2010 2:00 pm
When I use the generate DDL function of AQT Version 8.2.8 against this DB2 V9 mainframe table (DDL BELOW) it is only generating 5 of the 6 columns for the...
4500
Peter Backlund
backlunddb2
Jun 2, 2010 3:07 pm
This column will be automagically generated by DB2 when you create a table with an XML-column DB2 9 for z/OS is handling all the needed infrastructure for...
4501
Dan
addm92
Jun 2, 2010 3:35 pm
Thank you for looking into this. Before we can determine if this is not to be tested for we would like an explanation of what the "Default Object" represents....
