Search results for query: *

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" ))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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