aqt : Messages : 866-897 of 4217

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

866	i have never been able to figure out how to do something like this in sql.... example: i have a list of ordernumbers in a text file, one number per line i want...	jim@... jimcoam	Jun 2, 2004 1:10 am
867	As far as I know, there is no way of doing this. Some databases (DB2, Oracle) have functions for treating external files as tables, though I'm not sure if...	Phil Castle cardettnz	Jun 3, 2004 1:31 am
868	When running an update query I have a message of the type: Integraty constraint (SCHEMA.CONST_NAME) violated - child record found. Is there a way in AQT to...	godestalbin	Jun 3, 2004 4:18 am
869	Hi, I've been trying to load dates into one of my column using dataloader but I keep getting "Row=2 error.22008(0)[Microsoft][ODBC driver for Oracle]Error in ...	batboi_1000	Jun 3, 2004 4:32 am
870	thanks for feedback...that is what i ended up doing.... i was just hoping i didnt know some 'neat trick' of sql... ;-) jim warren jim@... ...	jim@... jimcoam	Jun 3, 2004 7:09 am
871	This sound like a foreign key constraint. You can view these by right-clicking a table then selecting "Referenced Tables (foreign keys)". You can view all...	Phil Castle cardettnz	Jun 3, 2004 8:51 am
872	Try date(yyyy-mm-dd). For Oracle it is also a good idea to select "Use To_Date function with dates" (this is on the options tab) Phil....	Phil Castle cardettnz	Jun 3, 2004 8:53 am
873	And can be downloaded from http://www.querytool.com/download.html It has a number of bug fixes and minor enhancements. Details can be found at...	Phil Castle cardettnz	Jun 3, 2004 11:08 am
874	... hmm. both double clicking the Full Install, and right click Save Target As yields 6.1.2. i've had problems before, but not recently, and i don't think...	ryoungbugs	Jun 3, 2004 12:15 pm
875	it seems as it is v6.1.2 in the full install file ... be ... recently,...	Mats Bergman matsspv	Jun 3, 2004 1:19 pm
876	it seems as it is v6.1.2 in the full install file. ... be ... recently,...	Mats Bergman matsspv	Jun 3, 2004 1:21 pm
877	Phil, The download is still version 6.1.2 Nick ... href=\"http://www.querytool.com/download.html\">http://www.querytool.com/ download.html</a><BR> ... <BR> ......	Nick IloveAqt	Jun 3, 2004 1:32 pm
878	Dear Mr. Phil, I am using AQT on both Informix database and DB2 (UDB) and find it very convenient to extract data and get query results. I have one request. I...	markose m v mvmarkose	Jun 3, 2004 3:40 pm
879	Use a question mark (?) as the parameter place holder. When AQT runs the query, it will display a dialog box prompting for the value to put in the query....	james.l.herrmann@... jim_kcsr	Jun 3, 2004 3:48 pm
880	Hi, I have just loaded v6.1.3 of AQT and when I try to connect to a DB2/VM database I get the following message. Error while loading system info in file Code=9...	edschultz2000	Jun 3, 2004 4:42 pm
881	I wonder if this is a caching problem. The file (aqtv6.zip) has the same name for v612 and v613 (I do this as it is pointed to by other sites). It could be...	Phil Castle cardettnz	Jun 3, 2004 8:53 pm
882	Still doesn't work. When I preview the data for insertion, it shows as date(yyyy-mm-dd) too. ... with ... do...	batboi_1000	Jun 4, 2004 2:14 am
883	What I meant is that your load spec should be (for example): <6:date(yyyy-mm-dd)> This will take field 6 (from your source) and format it as a date in the...	Phil Castle cardettnz	Jun 4, 2004 5:21 am
885	Hi, I am still learning all the things that the Extended Edition will do, which is a lot. Today I wanted to see all the tables in my database that did NOT ...	Harold Trammel fatherantox	Jun 4, 2004 4:26 pm
886	Bill, You most certainly can have multiple Run SQL windows. Assuming you are running the full version 6 program, and not the evaluation version, you can get a...	james.l.herrmann@... jim_kcsr	Jun 4, 2004 4:28 pm
887	I am still getting Version 6.1.2 when downloading from AQT site. Is everybody else getting the 6.1.3 version?...	delwork7	Jun 7, 2004 12:22 pm
888	I finally got version 6.1.3 but I still don't see a way to load a tab delimited text file, like a .bcp file. Have I missed it?...	delwork7	Jun 7, 2004 2:23 pm
889	But for the the last 4 days when I download the file it contains aqt612.msi (not 613). I've seen other messages about this in the forum. This is the first...	Mark Confee mconfee	Jun 7, 2004 4:55 pm
890	It looks like a lot of problems have been caused by giving the file the same name as the previous download. I will shortly upload http: ...	Phil Castle cardettnz	Jun 7, 2004 10:49 pm
891	In the Column Delimiter field enter the word "tab" (without the quotes). This is described in the Help. Phil. ... tab ... Is...	Phil Castle cardettnz	Jun 8, 2004 9:34 am
892	I have an ODBC data source I am trying to access. When I open the connection I see a list of file folders icons with no table or column names. If I use...	williamstandkeiii williamstand...	Jun 9, 2004 2:08 am
894	I'm trying to put in the current/fix date on the system but still not successful. In the mapping table, the source doesn't have date column so I try ...	Joe Tan batboi_1000	Jun 9, 2004 3:13 am
895	If you just want to load in a particular date, use of loadspec of (for example) 2004-06-09. No <> brackets or quotes. Phil....	Phil Castle cardettnz	Jun 9, 2004 9:10 am
896	Can you sent a screen-shot of what you see to me at phil@querytool. com. Also it is useful for me to see what you get when you click on Help>Database Details. ...	Phil Castle cardettnz	Jun 9, 2004 9:16 am
897	This is a good idea. I'll add this to v6.1.4. This is due in 4 to 6 weeks. Phil. ... do, which ... did NOT ... restricted ... ...	Phil Castle cardettnz	Jun 9, 2004 9:18 am

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages