Recent content by powerbuilde

We have many word documents that have been saved as blobs via Column -ole- (longbinary(max) "blob") to the DB (SQL Server 2012). Now we need to have the ability to search text in this Blob column (such we do with "like" in varchar column ) Need to be able to do this programmatically.

Hi DDeenniiss (MIS) No no solution found yet

Hi mbalent I run database trace with following events Exception under Errors and Warnings RPC: Completed under Stored Procedures RPC: Starting under Stored Procedures SQL: BatchCompleted under TSQL SQL: BatchStarting under TSQL and I run my app there are generated rows...

1- No i don't run a datbase trace - i did not use it befor - i will try to do it 2- no any information provided when the crach occurs header oe message "sybase powerbuilder 11.5 detail of message sybase powerbuilder 11.5 hasstopped working shown in next image (i ut it AT LEFT of image) then...

i am trying to update a datawindow via stored procedure update. The stored has no input or output parameter. When i call the update method, pb crashes. any idea? i am using pb 11.5 (also tried 12-12.5 ) and sqlserver 2012 sp1 thanks in advance for any help

Hi Tóth Péte replied "we use informix: select skip 10 first 10 * from table order by …" i found similar in sql server 2012 that is " OFFSET N ROWS FETCH NEXT X ROWS ONLY In SQL server 2008 i can use ROW_NUMBER() OVER( as replied from Gökalp AKYÜZ) but offset and fetch is more easier as...

I search in windows (that contain dw retrieve its data from sqlserver database)either by using argument or filter if there are 5000 rows(for example) that satisfy search criteria i don't want to retrieve all rows that satisfy search criteria , i want to retrieve only first 50 rows and display...

how to select a record based on user entry with out retrieve all rows then filter by using expression? if i used select top 100 then i use filter - dw filter out rows which not have filter from 100 row i prev retrieved Regards

​Hi I have window- with dw object - when i open this window i retrieve all records in the datawindow (dw_1.retriev()) when user wants to search for a specific record i put criteria he enteres in valid expression(ls_filter) then dw_1.setfilter(ls_filter) dw_1.filter() my app works fine when...

Hi all My app connect to sqlserver DB in our local network Now I try to connect DB that is in web using IP of server DB is on it i make router setting , firewall inbound rules , ..... all is OK I can connect using microsoft sql server mangment with server name like "...

when changes on the current row are not saved, how can I stop the scrolling to other rows caused by using the vertical scroll bar (pageup, pagedown,arrowup, arrowdown )and enter keys

Hi, for column in datawindow , if one field is of richtext style when i on this field the richtext menus appears with some default value ( for example font is "times new roman" - size is"11" - alignment is "left to right" how can i change this default values (for example font size =14 or...

thanks Matt but when i re-retrieve data , any changes made by the user will be discarded(omitted) unless i forced the user to save the changes but to force user to save changes that may be no completed yet , make user to be uncomfortable also when i re-retrieve data i must retrieve to the...

Hi, when two users (from different machine) run my application - each user open window w1 one user insert new record then save it to database (commit) this new record can not be displayed for the other user ( by using ScrollNextRow() or ScrollPriorRow() ) the new record display to other user...

I read article that discuss how to make primary key using Using Autoincrementing Columns from a PowerBuilder DataWindow http://scn.sap.com/community/developer-center/powerbuilder/blog/2012/10/25/using-autoincrementing-columns-from-a-powerbuilder-datawindow can i use primary key that generate...