Search results for query: *

I have a ObjectDataSource (ods) linked to a GridView (gv) on a web page pulling data from Oracle storred procedures. The defined (corporate) solution involves statically setting properties in the ods and gv and the method is quick and reliable. But I have desktop VB6 code and some 50 SQL...

I was afraid someone might suggest that. You are right I must steel myself and do it as I have no other ideas. Thanks for your time, I'll report back when its done.

I have a word template which (when invoked) produces a document with an active X tick box which used to fire an event which ran some code. The tick box no longer fires the event. If I add a new similar tick box to the template then it also does not fire. But if I create an entirely new...

If I have two tables which must be joined, but one of those tables is missing some data then I use an outside join to link the two tables. That way I get data from the first table even when data from the second is absent but I get data from both tables when it is available. My problem comes...

OK, I'll do it as two queries. Thanks [bigglasses]

When I try the second method I get data such as... 25 B1 C1 24 25 B2 C2 24 2 B3 C3 1 3 B4 C4 2 SUM(C) is always 1 less than C ! Where is it getting this last value (the SUM) from ? There are no negative values in the entire column. I should say that the real query is...

How do I do the following... SELECT A, B, C, SUM(A) FROM X I found the following on an Oracle error site... ORA-00937: not a single-group group function Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column...

It turns out to be an icon file with a 32 bit icon inside "attached" to the MSFLXGRD. I redrew the icon at 16 bit (which is quite adequate) and the problem went away. [bigglasses]

No "SP6" in my version. I'll request it is updated and report back in a few days. Thanks. [bigglasses]

If the status box is on a form then status.text will work if the code is in the same form. But if you switch the code to a module then you have to tell module code which form the status box is on eg Formname.status.text form_activate will run every time the form is activated (eg if you click...

I have SP6's version of MSFLXGRD.ocx. How do I tell whether I am fully SP6 ? [bigglasses]

Good thinking SBerthold, never thought it could be me that is out of date. How would I know which version I have ? About does not give any SP numbers. I have a corporate system, I do not do my own upgrades and I have limited access. [bigglasses]

I recently released the latest version of one of my programs after testing it on numerous PC's. But upon release to some 80 users, 3 get an "Unexpected Error" messagebox followed by the program stopping at startup. I copied the program to a new project and systematically cut it back and cut it...

Thanks. Just the mention of subclassing makes my knees go week. But your reply did make me think that maybe something got corrupted, perhaps during the time I was debugging the user control and it was not working. I took everything apart as much as I could, and reconstructed it all again - it...

Worth a try... http://www.xtremevbtalk.com/showthread.php?t=179880 Also, you are not behind a proxy or something similar are you ? Boggg1 [bigglasses]

I have a form with many controls on it including two control arrays. I have recently added a user control which gives me the functionality I want in a special button. The program works fine with just two copies of the user control on the form but when I add a third user control the IDE itself...

How much text is there in your stream ?. I have no idea what a command line will take but I would guess its fairly restricted. To access command line text just use... Dim TextStream As String TextStream = Command() I would guess that the easiest way to process moderate volumes of text would...

With all due respect DebiJo there is no real chance of diagnosing this without a whole heap of technical data about how the program works and what it does. You only hint its a database on the last line of your posts ! I mentioned the items I did because I guessed a few things that can prevent...

I have been using asynchronous ADO for some time now but I know that you can query a synchronous connection to ask if it is complete so is this not possible with synchronous ADO ? This example uses an asynchronous stored procedure but its the principal that counts, asking the storing recordset...

Any databases /connections / recordsets or anything unusual open when the VB6 closes ? How do you close - big red X button on a form or run a closing routine of some sort or ...? Boggg1 [bigglasses]