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.
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
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...
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...
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...
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...
-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
Is it possible to automate (in powerbuilder application), changing the screen resolution? For example, I wish to change the res to 768*1024 when my program starts, and back to original res when exits.
I use powerbuilder 7
I want to make CC contains my program exe file,database file,pbd and dll files so that the user installs it on his computer as he do when he installs Mswords or even powerbuilde
thanks
I have xls file
I want to open it using MsExcel
when I write
run("excel.exe "+ ls_path)
where ls_path is the path of the file
it does not work
I must write
run("D:\Program Files\Microsoft Office\OFFICE11\excel.exe "+ ls_path)
where D:\Program Files\Microsoft Office\OFFICE11\excel.exe
is the...
I want to make my app run from CD
I put Exe file and database on Cd
I edit the registry using RegistrySet
I connect to database at CD using profile made in registry
but how I know what is the correct letter for CD drive
may be it is d: or e: or f:
or may be the computer have more than on CD...
I want to delte a file in a specific location on my computer
my program display image at specific path specified in my database when i delete this path from database i want to delete this file physically from my computer
how can i do this?
thanks
I developed winform powerbuilder-11.5 application
my aplication read data on a spicific field that contain a path of jpeg image and then go to the path ,open the image
the user can modify this image and save thes changes to the file
the problem is ....
If i run this appliction from net using...
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.