TADOQuery Throwing "S1000HY000connection is busy with results..."Hi. I asked this question back in 2011 and never got a satisfactory response. My supervisor told me to drop it. But this is now happening to a customer and has become a hot topic again. Hoping I'll get something more helpful this time around. :)
Here are the details. I have an application written in Delphi 7. For my connection string, I check to see what operating system it is being run on. If the OS is Windows 8.0 and greater, I use sqlncli.11, otherwise I use sqlncli.1. The error happens ONLY when connected to a SQL2005 instance when on an XP. It never happens in any other ci...
TADOQuery Throwing "S1000HY000connection is busy with results..." #3Hi. I asked this question back in 2011 and never got a satisfactory response. My supervisor told me to drop it. But this is now happening to a customer and has become a hot topic again. Hoping I'll get something more helpful this time around. :)
Here are the details. I have an application written in Delphi 7. For my connection string, I check to see what operating system it is being run on. If the OS is Windows 8.0 and greater, I use sqlncli.11, otherwise I use sqlncli.1. The error happens ONLY when connected to a SQL2005 instance when on an XP. It never happens in any other ci...
Precedence of "where" ("of", "is", "will")?Nobody on #perl6 today could answer this one. Is:
Str | Int where { $_ }
the same as:
(Str | Int) where { $_ }
or:
Str | (Int where { $_ })
?
Followup questions, Mr. President:
What kind of operators are "where", "of", "is", and "will"?
Is there a reason that S03 doesn't list them?
What are their precedence(s)?
--
Chip Salzenberg - a.k.a. - <chip@pobox.com>
Open Source is not an excuse to write fun code
then leave the actual work to others.
Chip Salzenberg writes:
&...
.ALLCOL("%COLUMN%", " ", ", ", ", ")Do you know anyway for me to exclude a subset of columns returned by this
function. We have two columns (rec_user and rec_datetime) which are in all
of our tables, but when generating triggers I want automatically generate a
script which does not include those two columns but does include all other
columns in that table.
Bruce
I should add that I am using PD 9.0.0.580.
Bruce
"Bruce Lamb" <lamb.bruce@mayo.edu> wrote in message
news:6HgI315nCHA.155@forums.sybase.com...
> Do you know anyway for me to exclude a subset of columns returned by this
> function. ...
Delphi 2010 IDE throws error on "find" and "find in files"I will greatly appreciate any advice how to cure the suddenly appeared misbehaviour:
I just loaded the main project file and then tried to find code snippets fore re-use with "find" and "find in files"
the Eurekalog extract is:
2.2 Address : 20EB30B6
2.3 Module Name : vclide140.bpl - (Integrated Development Environment Specific Components)
2.4 Module Version: 14.0.3593.25826
2.5 Type : EOutOfResources
2.6 Message : Unable to insert a line.
2.7 ID : 61FB
2.8 Count : 1
2.9 Status ...
Banshee 2.0 "export playlist" and "import playlist" results differ
I'm new to banshee but playing with it to see if I like it or not.
I have a playlist of 634 tracks that I export to a file. I then try
to import that same file and only 627 tracks get imported into
the created playlist. The 7 tracks that are missing are:
#EXTINF:125,Elvis Presley - Don't Be Cruel
../../../../media/LinuxHD/Music/Elvis Presley/Elv1s 30 #1 Hits/02.
Don't Be Cruel.mp3
#EXTINF:189,Elvis Presley - Are You Lonesome Tonight?
../../../../media/LinuxHD/Music/Elvis Presley/Elv1s 30 #1 Hits/16. Are
You Lonesome Tonight_.mp3
#EXTINF:181,Elvis Presley - Can't H...
quotes, quotes, quotes...I am getting this error and I know what is causing it, but I have no idea
how to fix it, any help would be great. The script steps through the
/var/log/messages file on a linux server and puts
The entries into a mysql database. However when it gets to the 'hlt' line in
the messages file it just barfs. The single quotes are freaking it out. I
know about quotes but not how to use in
this situation.
Thanks,
Paul
Error:
May 27 17:53:00 localhost kernel: Checking 'hlt' instruction... OK.
<----- doesn't like this in the messages file
DBD::mysql::st exec...
Delphi XE3 "Connection is busy with results for another command"Hi,
I have a little program in DelphiXE3 connecting to MSSQL Sqlexpress 2012 that uses three DbExpress parametrized querys connected to a TSQLConnection that has these parameters:
DriverName=MSSQL
GetDriverFunc=getSQLDriverMSSQL
LibraryName=dbxmss.dll
VendorLib=sqlncli10.dll
The querys open cascade and when I try to open the last one I get a "TDBXError with message Connection is busy with results for another command"
If I use the same program connecting to Firebird, Informix or Oracle databases I dont have this trouble.
Any help will be appreciated,
Hernando.
I...
"2.1pre" (RC2) and search results--can't do much in "Search Messages" windowI am running RC2 on Windows 7, 64-bit and find that when I use the
"search messages" window, there is very little I can do with the listed
search results.
Click, double-click, and right-click do nothing on a search result item.
While I can select any search result item, and highlight it, I can't
open it with the "Open" button. (I can however delete it with the
"Delete" button. "Open Message Folder" will open a new message window
with the message selected.))
This is stuff I used to do all the time with earlier versions of
SeaMon...
Difference between passing "?" versus ":1", ":2", ":3" etc in prepare in Perl DBI !------=_Part_26521_25854351.1225691891708
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi
What's the difference between passing "?" versus ":1", ":2", ":3" etc in
prepare in Perl DBI ?
For example, what's the difference between following two scenarios :-
*Scenario 1*
$sth = $dbh->prepare("insert into tablename values (:1, :2, :3)");
$sth->execute($var1,$var2,$var3);
*Scenario 2*
$sth = $dbh->prepare("insert into tablename values (?, ?, ...
ADSIImport for users retrieves from AD "\" + firstName" + " " + lastName as Username (ver 2.1.2)
Hi,
I've installed both TTTASDIAdmin and ASDIImport and they both seem to run well. I have a problem with importing users from an Active Directory of a subdomain (win2k server). Instead of getting the username as well as other details, all I get is:
First Name: firstName" + " " + lastName
Last Name: (empty)
Username: "\" + firstName" + " " + lastName
email: firstName" + " " + lastName +@myMailserver.org.au (reads the mail server from ASDI setting)
My ASDI setting are:
Win Authentication
RootDomain: subDomain.Do...
Using "+" or "||"Using SQLAnywhere 5.5.04, I've gotten into the habit of using "||" in
ISQL to indicate a string concatenation. I needed to paste my SQL
statement into the PowerBuilder script painter for some embedded SQL, and
PB didn't like the "||" very much at all. I changed it to "+" and it
seems to be ok. Do these two operators indicate ~exactly~ the same
thing?
moin,
afaik these two's are not the same!
if you're using "||" and any term is NULL then in the resultstring the term
will be ignored
if you use "+" then the resu...
Results of "hiatory" or "autocomplete" searchName: Peter Herklotz
Email: softwareatpch-edvdotcom
Product: Minefield
Summary: Results of "hiatory" or "autocomplete" search
Comments:
Hello,
in your release note you mention that the new display makes finding the
web site you're searching for easier.
In my opinion the opposite is true. The new display - at first glance a
seemingly unstructured mixture of different font sizes - makes finding
the result rather quite hard.
What used to be findable with one short look at the result list now
requires a really concentrated review of all the lines appear...
replace the "." with a ","
Oi.... I need to build a small programm in ASP.NET and chose to use C# for it.Now i got everything working but there's one little problem.the first textbox is a double. I need to make it so that when someone enters a "." then it gets replaced by a ","any ideas?Ghan
string blah = "4.2.2.2";blah = blah.Replace(".", ",");Ryan Ryan OlshanASPInsider | Microsoft MVP, ASP.NEThttp://ryanolshan.comHow to ask a question...