Search results for query: *

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...

thanks Matt but my window is of type mdi when i check HScrollBar' and 'VScrollBar' checkboxes they did not display in my mdi window

I have a window with 3 datawindow i want ro put scroll bar (vert . and horz.)in the edge of window to scroll this window how can i do this?

i had editmask field of type datetime in formatt dd/mm/yyyy when my app is running in a machine has date format "yyyy/mm/dd" when the user tries to write 31/12/2012 or any similar date -an error message appears -as it must write 2012/12/31 how can i change the format from my app -as did from...

yes using pb 11.5 i can connect to database of type ase15 but i try to connect this db using pb7? is this possible? also how can i install ase 11.9 if O/S is WIN7 32bit? i can install ase15 developper edition - but limit to 25 user is not suitable for me thanks

-is powerbuilder 7 can connect to DB ASE 15 - in DB profile the release available is 10.5,11 and 11.5 so when I try to connect database of type sybase 15 - it fails - note i can connect to this DB using PB 11.5 ??? Also can I install ASE 11.9 on win7 32 bit