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!

Register Log in
  • Congratulations Rhinorhino 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. vfp4ever

    what is IIF() Function

    With the help of function EXECSCRIPT( ) you should be able to use multiline commands like this: a = 0 =IIF( a == 0, EXECSCRIPT( "a = 2" + CHR( 13 ) + "? a" ), EXECSCRIPT( "a = 3" + CHR( 13 ) + "? a" ))
  2. vfp4ever

    Pinning down the Data Session, Command, Call Stack, Locals, and Debug Output windows

    When I start the VFP IDE, it calls a setup.prg where I call Windows API functions like FindWindow, MoveWindow and UpdateWindow to size and place system windows such as "Command" and "Project Manager" the way I prefer (undocked). I have never tried with the Debugger windows, but you might find a...
  3. vfp4ever

    Image alignment

    I tried to overimpose a Shape on my Image and manage the Shape.Click( ), but the behaviour does not change. I feel I have to rearrange the underlying container and see whether that causes this oddity, but right now I must postpone further experiments on this issue until a later time. Thank you...
  4. vfp4ever

    Unable to reinstall old Windows versions

    Thanks pmonett for your ideas, while the creation of a GRUB by Ubuntu (messing up the MBR) might represent a valid explanation, I found out that I completely forgot about the 137GB size limit that Windows 2000 can see when it first installs. So eventually I managed to get Windows Setup to...
  5. vfp4ever

    Unable to reinstall old Windows versions

    Hello, I am experiencing problems in reinstalling old Windows versions on an old PC equipped with a 300GB hard-disk drive (and NO internet access, seemingly virus free), where several versions have worked flawlessly for nearly two decades (Windows 98, ME, 2000, XP)... until the moment I...
  6. vfp4ever

    Image alignment

    Unfortunately I can only see, as an alternative to the picture centered within the frame, the full picture extending to its natural dimension. That happens when I comment out Stretch or Width/Height assignments. An extra Refresh( ) does notthing. I am afraid I cannot use the Image Click event...
  7. vfp4ever

    Record is out of range

    Thank you, Gerrit and Mike With Gerrit's suggestion I managed to avoid the error as I set the ControlSource, but now something is messed up with the refresh. Unfortunately results often change simply by moving the same command further up or down within the same method, so it is a matter of...
  8. vfp4ever

    Image alignment

    Thanks, Tom Sorry, I did not do my best to explain the problem. I want my Image control to display pictures of various dimensions at either fixed width and/or height at 300 pixels (e.g. Pic1_1, Pic2_1, ... PicN_1). The Image is part of a Page, on which I also have an OptionGroup to select the...
  9. vfp4ever

    Record is out of range

    Hello, I have another issue, this time regarding Column controls and their ControlSource. Specifically I have a Grid, whose Columns properties are redefined in a procedure ArrangeColumns every time it is needed (e.g. an Activate event, or when any table name changes). The underlying data is a...
  10. vfp4ever

    Image alignment

    Hello, I am having some trouble displaying an Image control correctly. I assigned a fixed area for it (300x300 pixel) within a Container, and defined an Image Click method that cycles through a set of files according to a global property (image dimensions vary in both size and orientation). In...
  11. vfp4ever

    Varbinary key in tables

    Thanks, Tamar it's always a great pleasure to read your articles. Perhaps also my last chance to learn Sudoku, too. Dario
  12. vfp4ever

    Varbinary key in tables

    @atlopes I'm glad there is no problem at all to be solved, as I still program just for pleasure. Investing much of my free time in outdated software is not my biggest worry, as there is still so much to be explored in it. @Chris I did not realize how closely related that thread was with...
  13. vfp4ever

    Varbinary key in tables

    I'm not sure if I have made myself understood, let me try explain it again. On my local PC I have a database and application for my single use and leisure. It works fine, using dbf tables and primitive commands such as USE, SET RELATION, SEEK, etc... So far I never needed to access remote data...
  14. vfp4ever

    Varbinary key in tables

    Yes Chris, indeed I have always dealt with local DBFs so far. I was wondering what if one day I should create a remote database, based on what I now use (local), and connect to it. I imagine I should use CursorAdapters and make lots of changes in code, but once is done it should work for both...
  15. vfp4ever

    Varbinary key in tables

    atlopes, that is fine, with the latest assignments I was able to display the key field in the browse. And by changing a few more RecordSet properties I can also update fields. Unfortunately I get quite confused in all the examples I see around, so your short, precise answers help a lot. Now...
  16. vfp4ever

    Varbinary key in tables

    Thanks atlopes, but I still cannot see the Varbinary key field in the browse after executing your code. It shows as "Memo".
  17. vfp4ever

    Varbinary key in tables

    Oh, I see... Suppose I wanted to use VFPOLEDB, then the above statements should look like: lnHandle = SQLSTRINGCONNECT( "Provider=VFPOLEDB; UID=; PWD=; Data Source=ex_database.dbc; Exclusive=No; BackgroundFetch=No; Collate=Machine; Deleted=Yes; Null=No" ) SQLEXEC( lnHandle, "SELECT * FROM...
  18. vfp4ever

    Varbinary key in tables

    Hello, I am trying to connect to a local data source: lnHandle = SQLSTRINGCONNECT( "Driver={Microsoft Visual FoxPro Driver}; UID=; PWD=; SourceDB=ex_database.dbc; SourceType=DBC; Exclusive=No; BackgroundFetch=No; Collate=Machine; Deleted=Yes; Null=No" ) SQLEXEC( lnHandle, "SELECT * FROM...
  19. vfp4ever

    DataEnvironment and Cursor objects in code

    I'm afraid I sometimes have too much imagination. [dazed]. Yet I'm happy to see everything clear now, thanks to your help.
  20. vfp4ever

    DataEnvironment and Cursor objects in code

    Olaf, I have played a bit with the above code (and minor changes), verifying what you said about the DataEnvironment. In conclusion, I'd better avoid using it at all, as I would necessarily need a reference to it in order to change relations at runtime (as it's most likely needed in more...

Part and Inventory Search

Back
Top