Good day, I have a datawindow with a select statement Select charA, intA where charA = arg1 group by charA in my script, I declared it as a datastore. when I...
REYES, ORWELL L.
olreyes@...
Apr 1, 2005 11:39 am
14491
Hi TY, First of all your SQL is incorrect. If you use GROUP BY clause, you have to apply some aggregate function (SUM, AVG, COUNT, and so on) to each column in...
dw.Find() does not raise a runtime error if the find expression is invalid, it simply returns -5. Is the column you're searching a computed field? I suspect...
Look at the DataWindow.Print.Duplex property. The value should be 2 or 3, depending on the orientation you want. Of course, this only works if both the...
Since Close is not a pre-defined action for a DW button, you must be using a user-defined event. Put the code in the DW's buttonclicked (or buttonclicking)...
hi folks ... i need some a sample of ISAM files .. do you have any ?? thanks .... ... Do you Yahoo!? Yahoo! Small Business - Try our new resources site! ...
Pb8 I have a problem with the following code that converts dw to a word file. I get an error message that states the following: "Error calling external object...
//Open document and merge new data and save ls_document_name = "c:\database\testdocument2.doc" ole_Word.Documents.Open(ls_document_name) I later discovered...
Hi All I am having a column whose value can be a,b,c,... etc. I need a querry to select all the values from this single column one by one so that the output is...
bino.thomas@...
Apr 4, 2005 6:17 am
14500
Hello All concerned with the above subject, I posted this problem but still I didn't get the solution as to why I can't get the function called when I run from...
Hello We have migrated the application from PB v7 to PB v10. In the code we have written the function to save the datawindow in the excel! format. We have...
My guess is that you need to reference a child datawindow now that you're working with a composite datawindow. ... From: Shahzad <shahzad1435@...> To:...
Dear All, The following package,procedure are wrote by me, and connect through PB successfully. I want to know more things about how can assign Resultset in PB...
For PB 9.0.1 running under Windows 2000, when users print reports, does PowerBuilder leave temporary files on the local hard drive? If it does, where are...
hi Folks, Please let me know where i can get Powerbuilder 10 PFC's, since i want to implement in my application. I searched in my installation, i couldn't find...
I remember reading somewhere, probably here, that it does not install anymore. You will find it on the install disk though. Look there. IIRC under Support. ......
PFC is now open-source. Look in Code Exchange: http://pfc.codexchange.sybase.com/ HTH -- Jim Espaillat Delphinus Consulting, Inc. www.delphinusinc.com...
Try to UNION Function from SQL Statement. Ex. select 'A', <other column> from <table> where <column> = 'A' union all select 'B', <other column> from <table>...
Hi, I'd like to develop an application with plugins, which would add functions, menus and windows to a basic program, like a container. I've seen it's viable...
Hello How can i execute dynamic sql for custom Update / Delete / Insert where parameters are in any variable type I Try string as_sql any values[] as_sql =...
Hi! I have this file transferred from a unix system to a windows system. When I checked the transferred file, it has garbage within it. How do I clean up the...
How to sort a query with distinct clause by a column which is not provided in the select clause? Say my Query is like Select distinct first_name from Employee ...
Prabhakar
rprabhakar@...
Apr 5, 2005 10:42 am
14515
In this case, i think that it has no sense try to do it. Think about: You have a table with this datas Id FirstName 1 David 2 Carl 3 David 4 Rob Ok, you're...
Hi everyone! Just a quick question, I have a datawindow and I used the inv_sort service to allow sorting by clicking on the headers. The problem is this, when...
Check the static text/columns names. the static text control name must be same as column with '_t' at the end. Regards ... [Non-text portions of this message...
