Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rgwith

    ODBC in powerbuilder using a INI file??

    You can use ProfileString() to read the value for lsDBName from an .ini file. See PB Help for details.
  2. rgwith

    ODBC in powerbuilder using a INI file??

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

    Modify( )

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

    PBL library size

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

    ODBC or DSN-less connection to MySQL?

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

    ODBC or DSN-less connection to MySQL?

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

    SaveAsAscii() Functions Returning -1???

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

    Import file

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

    Help!

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

    Import file

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

    Import file

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

    Capturing data from a serial port

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

    FileSeek/FileRead?????

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

    Application Launch

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

    How to use multidimensional arrays ???

    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)...
  16. rgwith

    Using a proxie in the PostUrl

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

    PB7 App gets Illegal Operation error when started

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

    Sorting of Arrays - How is it done?

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

    Open an HTML file from PB App

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

    HTTPS POST using PB?

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

Part and Inventory Search

Back
Top