Search results for query: *

Hi, Right click on the desktop, choose property. Go to tab effect, check the checkbox name "hide desktop icon when viewed as web page" Thanks...

Hi, Can share with us what was the problem? Thanks.

Hi, I am new to WinAPI, i can't found EnumProcesses api function but EnumWindows, How to use EnumProcesses API function? Thanks a lot.

Hi, How to create a link between 2 database? Last time i try to use a SQL statement to cross database, eg: Insert into databaseA.tableA select * from databaseB.tableA both table have a same set of data type and structure, i used to compile following scripts in SQL Server and Sybase which...

Hi, How to see the content of SYS.STANDARD package? Thanks.

Hi, Try getitemnumber() or using dot notation.

Hi, That statement i was not learn from book, it's from my work experience. The help file in PB do have a help regarding of EXECUTE IMMEDIATE. :)

Hi, The columns selected in statement 1 and statement 2 must be same type in a same order. eg: select name, age, telno from table_1 where xxxxxxxxxx union select name, age, telno from table_2 where xxxxxxxxxx the only different could be is the table and where clause.

Hi, String s_str s_str = "alter table table_name add name varchar(20)" EXECUTE IMMEDIATE :s_sql USING SQLCA; Hope this help.

This could be cause by one or more of the null value you trying to insert into a non-nullable columns in the database. One of the way to check which one is a null value try to use this: if isnull(ls_string) then ls_string = ""

if your sle control is on window, just simple type sle_name.text = '' if your sle control is inside datawindow, type dw_name.reset() or dw_name.object.sle_name.text = '' hope this help.

Usage of Data Pipeline is to port the data from one table in DB_a to the same table in DB_b with a condition that have the same table structures, like no. of columns, datatype....etc

I think there is no built-in function in PB that return your appl path, but you can call a external function which is API, if i am not mistaken the API name, it is getDirectoryA( Value handle, Ref string)

Hi, I guess the problem most properly cause by the Where Clause. Is it the ":in_total" same as the people u want to count?(Is it a numeric?) What data is "total_d" stored? U may try to select * where total_d = :in_total by backdoor, see is there any rows return? If no rows...

hi, Can u check what is the columns specific in PK_Colposcopy_chart? I think u already have a record in yr database, and u are trying to insert a same value into it, thats y u hit the message of "Cannot insert duplicate key". The columns that specific in PK_Colposcopy_chart and marked...