Viewing 15 posts - 226 through 240 (of 251 total)
No I don't mind, but here it is modified ro do exactly what you wished to do. And I greatly improved the speed, by only doing the casts for unicode...
January 9, 2003 at 2:18 pm
Wow, weird, I have been writing a script this morning to do that very thing. I
am searching for ASCII zeroes in all of my string columns. This is probably...
January 9, 2003 at 1:45 pm
It is not a security issue, or the default size for the datatype, it is just that with longer text your display output will wrap in the results window. Often...
January 9, 2003 at 1:39 pm
Having an interesting time trying to implement this control in VB. Probably need someone with more API knowledge than I to work on it. Useing RegisterClass, and CreateWindowEx I was...
January 9, 2003 at 10:02 am
Ok, the control that QA uses is one I am not familiar with. The class name is a "DimensionEdit" where as the base class name for a textbox is an...
January 9, 2003 at 8:45 am
LOL, if he could I would polish his resume... But as far the sp_OA methods are
concerned, it is nothing more than a way to create com objects in
TSQL...
January 7, 2003 at 4:00 pm
K, Are you modifying the xml directly through the text variable? Maybe instead using the sp_OA methods you could use the dom object directly in your code to work on...
January 7, 2003 at 3:40 pm
Why not perform this logic within the web service itself? Long string manipulation would be better suited for a language more suited to that task. (VB, C++, VB.Net, or C#)
IMHO...
January 7, 2003 at 3:22 pm
Watch out for the problem with using @@IDENTITY with a table that has a trigger that inserts into another table that has an identity. Then you are back to selecting...
January 7, 2003 at 3:15 pm
Do you mind my asking what are you doing to the xml in stored proc A? and what is the purpose of stored proc B? I ask to see if...
January 7, 2003 at 3:04 pm
Oops, just read that he is using an Access front end. If the back end is SQL Server 2000, he can use the scope_identity, and using it from a stored...
January 7, 2003 at 11:23 am
quote:
Not sure if you can get it in Access, but you can get @@scope_identity (select it) to get the last identity value...
January 7, 2003 at 11:16 am
Turn ON In QA - Options - Results :
1) Scroll results as received (*)
Specify that the results should be scrolled as they are returned.
Edited by - tcartwright on 01/07/2003 ...
January 7, 2003 at 10:22 am
Typically the error trap you have presented here can leave the user confused and
scratching their heads. What if is not a duplicate record, but some FK violation
has occurred,...
January 6, 2003 at 5:06 pm
Why would casting to a different datatype not work for you? A simple cast to the float datatype seems to work almost exactly as you wanted it to in your...
January 3, 2003 at 8:30 am
Viewing 15 posts - 226 through 240 (of 251 total)