Great news. By the way, I am a 17-year veteran developer of Perl/C/SQL code. I have tried all sorts of SQL interfaces over those years - my prefered choice has...
Hi Matthew, ... the developer to specify a ... location. I have this on the list for Oracle, but not Sybase. I'll add Sybase on the list. ... mounted...
Hi, I've put out a new build with some bug fixes. Update instructions below ... ( http://www.aquafold.com/download/datastudio_4_5_6.jar ) thanks -John CHANGES ...
Hi John, Yes, your assumption is right. Thanks a lot and hope that Oracle will take this problem into account. Best Regards, Philippe Diennet...
Philippe Diennet
ho.pdiennet@...
Oct 3, 2005 2:47 pm
2723
There might be a round about way of achieving this, but I'm not sure. I've noticed that if I put the SQL in a PLSQL block, i.e. begin sql statement; end; Then...
Where is all the server-metadata kept? I'd like to use AD at home and at work and not have to re-enter all the server info? Is it an INI file or a REGISTRY...
Hi Matthew, All of the configuration is in <USER_HOME>\.datastudio ... On Windows that is usually C:\Documents and Settings\<USER_NAME>\.datastudio -John...
Hi Reena, As far as I know, a PL/SQL block is not processed in the same manner. I don't think that you can execute a SELECT statement in a PL/SQL block which...
... SELECT thing INTO resultCursor FROM ... ? -- Tom Chiverton Advanced ColdFusion Programmer...
Thomas Chiverton
thomas.chiverton@...
Oct 4, 2005 2:22 pm
2728
Duh. So sorry. I am so "windows" trained that I was looking for Aqua Data Studio in C:\Documents and Settings\<USER_NAME> and completley missed the fact that...
I am used to having autocommit off by default in SQL*PLUS and on by default in isql/sqsh. I find I have to be much more careful against ORACLE servers because...
Hi, You can do a SELECT INTO, but if I am going to "rewrite" the statement to get the line number this would be too much. I don't want to come up with a bad...
Hi Matthew, You can change the application default in File->Options->Query Analyzer for each database. Is this what you need? or do you need it per ...
Hi John, You're right, you cannot execute a SELECT statement in a PL/SQL block. What I do is simply wrap my SELECT statement in a begin and end (like I showed...
Hi, ... 1000 line sql in that way! This might work manually to help debug, but this would not work programatically to solve the problem. I believe getting...
... the problem. Yes, that would be best :) ... From reading the notes on my oracle connection class, the error position is in sqlca.sqlerrd[5]. Only, as far...
Hi, Oracle uses the sqlca.sqlerrd for the native c++ apis, but not for the JDBC drivers. In DB2, the drivers through a DB2 specific SQLException which has the...
Hi John, I understand. I guess I was doing wishful thinking! Also, I've just been lucky that I've been able to debug my errors in this way, but theoretically...
... Nope, that's perfect. I have set all Oracles to be auto-commit off and left all Sybase as auto-commit on 'cause that is the way the they work out of the ...
Hi Matthew, ... to have a namespace for the ... and use the native Sybase BCP client What do you mean by dataspaces? what part of the application are you ...
I've noticed when I've got multiple query windows open and I use the Cntl-Tab key to move across them, I always have to use my mouse to place the cursor inside...
Very good. Thanks for fixing it so quickly. Shawn Hevel, API, AIT Lead Programmer Analyst Information Technology Department South Carolina Farm Bureau...
Other thing I thought would be useful is Shift Del. It will delete the entire line regardless of where the cursor is. I noticed that the Shift Ins works for...
John, I was just wondering, Does this feature work with any of the databases? In our office, we use DB2 and SQL. If so, do you have any documentation about ...
Hi Shawn, In DB2 and SQL Server you will get the line number only on CREATE PROCEDURE/FUNCTION. So, in the case of a source object the error will give you the...
... I will provide an example with screen shots. To what address would you like me to send all that? ... OK ... OK ... Ah, ok I will try this. -John ... -- ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
