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...
TADOQuery Throwing "S1000HY000connection is busy with results..." #2Hi. 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...
.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. ...
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:
&...
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 ...
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...
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...
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...
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...
"-" not "_"
I wrote a SQL statement in the data tab. I wrote a bunch of alaises as example ' word-type ' but when I hit the layout tab it converts the "-" to "_". So now my field name is ' word_type '. Is there any way to prevent this? CardGunner
Don' use a hypen ( - ). It isn't a valid character for column names.
See http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1188931,00.html
Here's an excerpt about column names:
Letters as defined in the Unicode Standard 2.0
Decimal numbers from either B...
Replacing "\\" with "\"
Hi all
I'm getting this value from a CheckBoxList control - a location of file, i have to remove "\\" and replace it with "\" and pass it to Query, how to do it, i tried with Replace, but coud'nt suceed.
"\\\\Blaze10xp\\BLZ_SFS_07\\Sample Excel Files\\Excel Files\\report2.xls"
thank's in advance
- Prakash.C
you tried Replace like this?
string newstring = oldstring.Replace(@"\\",@"\");Plese, do not forget to click "Mark as Answer" on the post that helped you. Thanx!My blog: Scenes From A Developer Memory
yes i tr...
"Me" is better than "You"Yes I know, strings are frozen.
But let me talk about it, I really can't get through the idea of a PC
talkin to me.
I consider my PC as an extension of myself, not a dumb companion who
addresses Me as You. Yes there are times when I get angry with Him while
I work and get wrong calculations etc.., but it really is my fault, Me
using wrong istructions and eventually wanting to find someone else to
blame, but it's Me. And yes, I consider Thunderbird my mail program,
reading my mail on my PC as Me.
So I personally like to have Me in the header bar as a compact address
...
"To" and "From" missingWhen I print emails, the words "To" and "From" are blank, even though
the "To" name and "From name (addresser, addressee) do show up. This
is
not a problem for other users on my system. Suggestions
In mailbox right click, view. On the message window, right click and
choose print options. Make sure print header is checked.
--
Barry Merchant
NSC Volunteer SysOp
*** no email unless requested please!! ***
> In mailbox right click, view. On the message window, right click and
> choose print options. Make sure prin...