Search results for query: *

Hi all, I have a question reqarding retrieve data from 2 different database. Is it possible to retrieve data from 2 different database in a datawindow? If so, how do I handle it? Thanks!

Hi, I have try the following statement but nothing happens. Anyone know why? I'm trying to do a loop in the datawindow, if pass certain verification...it will change that particular row to red. for n = 1 to dw_datawindow.rowcount() ..... .... ... if xx = yy then...

Hi, I'm using PowerBuilder 7.0. Does anyone know how to set the text color of a specific row in a datawindow? Thanks

Hi all, I have a problem with the language display in PB7 and Sql sever. I input a BIG5 character in PB application. It display alright..however, when I retreive the data in SQL Enterprise Manager, the Big5 characters came out funny. Then I tried to input the big5 characters directly...

Hi all, I wonder how to pass in a parameter to the child datawindow? I need to pass in a parameter for the dwc_drop_down, so it will retrieve the proper data according to the parameter. Here is my script: DataWindowChild dwc_drop_down dw_project.getChild('project', dwc_drop_down)...

Dear all, I am newbie to Power Builder and have some problems with import file. I need to import a file and save the data onto database. I wonder does it is neccessary to import the file onto datawindow first then save the data in the datawindow onto database? Can I directly save the data from...

Hi, Can anyone please tell me how to connect to muliple database. Right now I am connecting to a single database using ini.file. Thanks & Regards

I have a question regarding the datetime format. I have a field with datatype of datetime, how I can change to format when I retrieve from database from (yyyy-mm-dd hh:mi:ss) to (yyyy-mm-dd)? I have tried the Cast function, cast(mydate as char(10)) but this will change the format to (Mon dd...

How can I reset or clear the field of Single Line Edit Control or a drop down datawindow? What I want to do is when user enter a wrong login id and password, a messagebox will warn the user and it will setfocus back to the login window where all the fields (drop down datawindow and...

I have a question regarding the drop down text box. I have a drop down text box where list out all the company name. when user select the an entry from the drop down list box, the a datawindow will display regarding information. Here is the problem. I will need to retrieve the company name...

Hey I have a case here. I need the user to login in the system before moving forward to the other area of the system. Once the user open the application, a login window will pop up. How can I make the background window (main window) to become disable as long as the login window still on vision...

Dear friends, I'm a newer to PowerBuilder 7. I have some questions reqarding MS SQL Server store procedure. 1. How to I call a store Procedure(SqL server) from a datawindow. 2. if I need to reture a set of records from database..how do I do it? I am a Java programmer, I know we can use...

Can anyone tell me the major differences between PB6.5 and PB7.0? Thanks!

I have created a new database through Database profile. I can also retrieve data when I preview my report. However, when I actually run the application, it gave me an error saying "Transaction not connected". I can not find what was the problem. I have copy the Database connection...

I need to show a report on a datawindow control. when I created the report,it was able to retrieve the data (preview mode), However, when i embedded into the datawindow control and run the application, it can not load the data. Only the labels and title of the report shown. Can anyone answer my...

Ah friends, Is there a way in Macro where I can create a function to Compact and Repair the database? I know you can find this function from Data Utilities but I wanna to do you it automatically everytime when user exit the application. Please help!! Thanks