I prefer to use the DSN-less connection. Do it like this:
//DSN-less connection to a MSAccess database
string lsDataBase //connect string is assembled in this variable
string lsDBName //actual name of the .mdb to connect to. NOTE, this may be a full
//path and...
The parm to modify() is type string. If you do something like:
lsModString = "columnname(" + string(n) + ").color=255"
lsResult = dw_datawindow.modify( lsModString )
it should work.
I suspect that if you ran the original example with debug and caught the return from...
PB's development environment (IDE) can be a serious memory hog. I think you might be seeing the effects of low memory on your development machine. Presuming that you are developing on a machine that's more or less comparable to what you will install on, that doesn't bode well for your deployed...
I'll have to try this later from home, our company rules are a little "funny" about registering for Yahoo. I don't know if this will help, though. The DB that I need to connect to is MySQL not SQLAnywhere. I already know how to connect to that kind of DB.
Has anyone used PB to work with a MySQL database? I know that the ODBC driver exists, need some feedback if it works well with PB. I'm using PB7.0 or 8.0 on Windows XP.
A PSR file created vis SaveAs from a datawindow can be displayed in a PB application by setting another datawindow's dataobject property to the PSR file name.
Follow up (2)
I agree with the above post about creating the group but I just found that in addition to the code I posted earlier it is necessary to include dw.GroupCalc() after the dw.Sort().
That is what makes the groups appear in the datawindow.
You could use the Timer event in the window holding the picture control to rapidly swap the bmp file using the SetPicture method of the picture control.
See the PB help file for details.
BTW: a more descriptive subject for you post would probably get more responses.
Follow up on my earlier post-
It IS possible to get an external dw to sort but not through the painter definition. You have to do the import and then set the sort order as shown in the code fragment below. This code came from the open event of the window that holds the dw control...
I frequently use datawindows with external data sources and fill them from tab-delimited text files. If that's what you are doing, there is no choice that I've found to get the data into a database other than to do the ImportFile and then loop through the datawindow rows and issue appropriate...
Serial ports are treated in Win 32 like files and it is possible to use the PB file operations plus the Win API to do some of what you're trying to do.
I've used a product called SoftwareWedge from TAL Technologies to communicate with serial devices like credit card readers and modems. This...
This can be another use of freeform datawindow. Assuming your file records have carriage control/line feed at end you can build a freeform datawindow with a single column defined in the detail band and use ImportFile to load your file into the dw.
From there, Rowcount() should let you get to...
Here's how I have done it:
1. Declare Global External Function
Function LONG FindWindowA(string lpClassName, string lpWindowName) library "user32.dll"
2.
In the application Open event use the following code:
IF FindWindowA(lsNull,"xxx") > 0 THEN...
I often use a freeform data window for this kind of requirement. It provides some of the search capabilities you may want without having to write all of the insert/delete code for working with arrays. You can easily load up a freeform data window from delimited text files too (see ImportFile)...
I had to do this for credit card processing recently and was unable to use the PostURL for exactly the same reason. I wound up using the Microsoft MSINET.OCX which allows setting of protocol and proxy name. I am using PB7 but neither 8 nor 9 seems to provide the capability we need either...
I have a PB6 app which has been migrated to PB7. Unlike the PB6 app, I have to open the application object before running the app in the PB7 IDE. If I don't, it crashes with an Illegal Operation message. I have not encountered this behaviour in apps created directly in PB7. I am not using PFC...
How about building a datawindow over the table, using the dw in a (non-visual) datastore and modifying the sort order as required?
That way you could step through the datawindow rows in a loop much as you would use an array.
Try this:
http://gethelp.devx.com/techtips/pb_pro/10min/10min0699.asp
This uses the MS Web Browser OCX.
When you place the .OCX on the window, put it at the upper left to make the resize event work right.
It works fine for a local .html file too.
I am trying to POST a document using HTTPS using the postURL function and getting -5 Unsupported secure (HTTPS) connection attempted. Has anyone been succesful with this function? I began trying to make this work with PB7 but have since moved to PB8 and still have the same problem.
Have tried...
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.