Search results for query: *

Hi I need to run Microsot Word, the Calcular and other applications but also I need to put those applications inside my window. In other words my application should host other applications. I want to know if developing a control to host third party application is very complex or if I can buy a...

Hi I need to create an MDI application that can run other applications like MSWord, MSOutlook, etc (the end user will define the applications, so I dont know the list of applications my program will run). The problem is that the applications do not have to show in the taskbar but they must be...

Hi I need to create an MDI application that can run other applications like MSWord, MSOutlook, etc (the end user will define the applications, so I dont know the list of applications my program will run). The problem is that the applications do not have to show in the taskbar but they must be...

That's a great idea. I used a DataWindow. Thanks mbalent. [bomb]

It works! Thanks LKBrwnDBA [bomb]

Select C1, C2, C3, (Select Sum(ColSum1) From PAYS P Where P.F1 = C.F1 And P.F2 = C.F2) As TotalPay From Client C Where ToPay <> (Select Sum(ColSum1) From PAYS P Where P.F1 = C.F1...

I'm connecting to MS SQL Server and there is a store procedure that returns a value using an output variable. I declared the store procedure in the Local External Functions of a Transaction object. Where PB calls the store procedure, PB changes the month and the day. Here is an example: // On...

Bitmap("H:\ProductImages\" + (Value_1) + ".bmp") [bomb]

Bitmap(String(Long(Product)) + ".bmp") With that code it will work but make sure the files have a standard: Product File 001 --------> 1.bmp 002 --------> 2.bmp 003 --------> 3.bmp ... 010 --------> 10.bmp 011 --------> 11.bmp ... 101 --------> 101.bmp ... 999 --------> 999.bmp...

Yea, you have to create a new column into the table. The user will select the file of every product (using GetFileOpen) then you extract the path and file name and save it into the new column. In the report, create a new compute field with the expression: bitmap(bmpfilename) and the report will...

Creating a new column - as mbalent said - is the best way to do that. The user can choose an image to every product, and the report will show the image automatically with the expression: bitmap(bmpfilename) [bomb]

Sometimes is better to use Exec instead of sp_executesql? [bomb]

For me the function returns aaa!! Maybe it is a problem of the ocx on ur computer. [bomb]

Thanks Jim [bomb]

Can I disable the sa user? I don't want anybody can use that user. [bomb]

You can specify the keyword Distinct in the SUM function. Select Sum(Distinct Amount) From TableName [bomb]

If the sort columns are specified on a DW level: ls_Sort = <DW Control Name>.Describe("DataWindow.Table.Sort") (You can use DWSyntax program that comes with PowerBuilder to look up more properties of the DataWindow Object). If u want to know the sort columns of the Select statement of the DW...

Thanks Jamfool: The DBCC pss statement displays the isolation_level of any connection with the values 1 to 4 identifying the READ COMMITTED, READ UNCOMMITTED, REPEATABLE READ, SERIALIZABLE. [bomb]

Hi I want to check out the options for any connection. I've used DBCC USEROPTIONS, however this command only applies to the current conection. When I run sp_Who I see some spids and I want to know the options of the conection of the spid x. Can I do that? [bomb]

Thanks gnamachivayam, it worked like a charm! [bomb] Lenin.