I need to get a file form C drive which its path is different everytime, then transfer this file name into a fixed one and do the file open, file read , also insert into several tables, close ...
Hi
My datawindow sql is talking more time to retrieve data,This data is retrieve and print the report,So my code is talking more time to print the report ,i am sending code of datawindow ...
hi all
i want to do something when a field gets focus and loses focus in a datawindow.............
ya.. with the itemfocuschanged event i can able to do when a column field gets focus......
My application uses a standard date format of the type dd/mm/yyyy. This is verified from Settings > Control Panel > Regional Settings > Date. If the Regional Settings has a different format ot...
HI All,
I have a problem wherein I need to get the printer name(both local and networked),printer driver, and port information of all the printers connected to a computer. This is required ...
Hi Guys,
I have a problem. I have datawindow which sometimes retrieves only one row depending on the retrieval argument. I have placed some code in the rowfocuschanged event of this datawin...
Hi,
Does anyone have general pipeline utility to transfer data from ORACLE to SQLSERVER or vice versa? I need realtively same functionality like the pipeline do at design time.
Thanks in...
Why IsDate("Jan 1, 95") returns False?
I use PB 6.5 under windows 2000.
I used the setcurrentdirectoryA before and it still didn't work after I had to open file using GetFileSaveName in diffrent directory.
It took the chosen dir...
hi
I am using PB 7 as front end and oracle 9 as back end .I am getting error
ORA08002 :sequence SEQ_BATCH_ID.currval not yet defined in session.this sequence is using in one procedure. this...
I've been working on an independent project, a PowerBuilder (Version 7.0) front-end with an Access back-end. I want to create a window in this application that will allow users to search the ...
I am using Installshield5.0 free edition which come with in powerbuilder cd.
1) I have some problem when creating setup. I am not able to add desktop icon and also not able to add on startm...
Lo, I'm trying to use a treeview and I have 2 questions. Here we go:
1 - How can I expand all the items of this treeview?
2 - Is it possible to change the font color of each item?
Thanks fo...
Hi,
Can we set environment variables thru PB application.
If yes, will it effect without restarting the system.
Thanks in advance
Srinib
Greetings All,
I seem to be having trouble passing a date as an argument to an ASA database.
I know that I have done this before but it escapes me now.
I seem to recall having to do a...
I'm creating a grid datawindow dynamically with the dw.create function.
ll_rtn = dw_1.create(ls_syntax, ls_error)
Now I want to go through the columns and for each column heading, make i...
I have a procedure in oracle that looks something like the following:
/**********************************************/
Procedure p_result(o_result_set OUT cursor_type)
AS
BEGIN
...
It looks like I need expert advice once again.
I have a composite datawindow with a nested report (datawindow) in the Detail band and around 12 lines of text in the Summary band.
Here's...
Hi,
My datastore is not getting updated. How to access datastore events, if we want to write code for sqlpreview event, to check sqlsyntax.
Thanks in advance.
I have a datawindow that colors rows red or yellow or white depending on the data. On screen it works fine, but when I go to print preview, or I print it, the colors disappear. How do I keep...
Hello...I am attempting to make use of the Lotus Notes Lotus.NotesSession COM object from PB 7. Everything works fine under W2K with a Notes 5 client using the following code:
// create an...
Hi,
Earlier I asked a question here for migration. Thanks for all those answers.
Now I am fixing the migration issues. The approach I followed is, copied PB9 PFC pbls into my application o...
Hi,
Currently, I change a user's password as follows:
ls_SQLText = 'sp_password ' + sapass + ', ' + newpass + ', ' + is_user
EXECUTE IMMEDIATE :ls_SQLText;
That works fine EXCEPT.....
Hi,
I need to have general search utility for my powerbuilder window. If i click on search button then, it should take all the current datawindow columns and perform a record search based o...
Does anyone know how to take a picture (colour .jpg) change it to black and white and resize it. I have managed to find a few ways of resizing a picture but none of them are very good qualit...
