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!
Thanks for your reply!
But what if I want to do it in coding? Let say, I have a store procedure to save all the rows from the datawindow into the database. Meanwhile, it will do some validation to check each record whether is qualify to save into the database. If does not pass the...
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)...
Sorry is me again!
I encountered a problem when I tried to import a file into a datawindow.
I want to let user select the file to import..so I specify a Null string for the filename. But I keep getting a return value of 0. What have been wrong? I even tried to point to a specific file and I...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.