|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Blinking in HScrollBar / VScrollBar Posted by LUIS at 5/30/2007 4:06:04 PM I am using VB6, my Applications has several HScrollBar and VScrollBar. Both
work perfectly, but; when I use any of them and "leave" the control, Scroll
Bar starts blinking. It is extrange. Can you explain that? Is there a way to
correct it? Please, help me.
Beforehand, thank you very much
...more >>
How to "avoid" a GROUP BY - HAVING Posted by LUIS at 5/29/2007 5:19:00 PM I have four tables,
1. First has Items,
2. Second has Features,
3. Third defines the ItemsFeatures
4. And temporary that sets which Items have to SELECT according Features
For this statment we do not need table(2),
IF (SELECT COUNT(*) FROM tblTemporary) = 0
SELECT A.ItemID, B.ItemDescr...more >>
MS Query in EXCEL will not accept additional text Posted by Bobby B at 5/25/2007 6:57:01 PM I am working in EXCEL 2003, to access external data through MS Query. I am
writing code in the SQL query edit pane,. My query and case statements are
large. The SQL query edit pane will not accept additional test. Is there a
limit to the number of characters / size for an SQL query in MS Q...more >>
Filtering out zeros Posted by Tom at 5/21/2007 9:42:01 AM Running a query that adds up certain fields in our database and where
applicable returns a zero total. Looking for a way to return only those
lines that are not zero value.
I'm new to this SQL thing, have experience in Access but am tripped up on
this. Pls Advise...more >>
SQL Syntax Question Posted by Ryan Mcbee at 5/18/2007 1:11:00 PM I have the following syntax:
"select itemnmbr, locncode, (qtyonhnd-atyalloc) as "QTY Available Main"
from iv00102 "
The results look like;
Itemnmbr locncode qty available main
121 944-16 90.00000
121 944-16 ...more >>
Get user syntax Posted by Ryan Mcbee at 5/17/2007 10:24:00 AM I am building a view for a report and one of the requirements is to grab the
user who is running the report. What would this syntax look like? I thought
it was getuser(), but no luck there.
Thanks,
Ryan...more >>
UNION query. Wrong answears. Posted by Scott Burke at 5/17/2007 8:37:01 AM We are running SQLSERVER 2005. The following query give the wrong answear.
WHY????
SELECT * FROM
(SELECT Clearance.ClearDate as CLDATE, ORDER1.FULFILLMENTCODE AS FCODE
FROM Clearance INNER JOIN
ClearanceOrder ON Clearance.ClearanceID =
ClearanceOrder.Clea...more >>
Date reformat question for the group Posted by Graham (Pete) Berry at 5/15/2007 10:42:44 AM I hope I am posting this in the correct group, but if not please tell me
the proper place. I am more of an admin type than a developer and am
having a problem I have been unable to code around. In short, what I
want to do is convert today's date and time into a series of local
numerical cha...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Backup remote database Posted by Jojamie at 5/15/2007 8:24:01 AM Hi All
I am trying to write a SQL statement to use in an automated process which
will run on a SQL 2005 server and backup a remote database from another SQL
server.
From there I am trying to then restore this remote database backup into the
local "Copy" database.
For some reason everytime...more >>
using wildcards [ ] in REPLACE or CHARINDEX functions Posted by Joe Sich at 5/11/2007 8:15:00 AM I'm basically trying to replace non alpha characters of values in a couple
columns, but would prefer to create a ud-function or have a function in my
view do this for me rather than have to manually update every non-alpha
character.
I'm trying to do something like this:
REPLACE(Col001,[^...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |