Search results for query: *

Hi Tony, Thanks for your quick response. The filesystem types worked just fine. Scanning the table created by enumFileList, I noticed the DOS "." and ".." hidden files. They caused an "Access is denied." error when I attempted to copy them. Once they were filtered out the filesystem copy...

There's a suite of directories on the network containing data tables, queries, answer tables etc. I've created local directories of the same names. I'd like to copy the contents of each network directory to its corresponding local directory temporarily. The intention is to speed up the...

This may be a containership issue. I have a button on a form. The button has code attached to its "pushbutton" event. The code triggers a library method. The code appears to run twice. This is apparent as ".view()" statements, placed temporarily for development, are displayed twice for each...

Thanks Tony, It worked like a charm. A bonus is that it created a script which I'll incorporate into my project. dblarch

When selecting fields for a query based on a table with over two hundred fields I scroll the query window till it's found, often passing by the very field I'm looking for. Is there a search utility whereby I can find the field? Wildcards would be a plus.

I traced a query's "calc max" error to a field type in an imported table. In the original text file all fields were tab separated numbers including many integer fields. Paradox imported some of these number fields as alpha fields. The "calc max" field in the resulting Paradox table contained...

I too was working on the "while" loop. But, your solution is more concise and elegant than mine so yours will be used. During coding I fell into a trap where my loop was endless. I was using the view() method for more than one variable so it cycled through the message boxes endlessly. How...

Thanks for the quick replies, dblarch

Is there a function analogous to ToHex that will convert decimal integers to octal?

That's indeed it. The line: returnVar=formvar.wait() : did the trick. Thanks Tony, dblarch

I discovered that the code exists in two places. The same code was placed on the pushbutton (PB) event of a PB on the calling form and in the open event of the called form. The code calls methods in a library. I removed the code on the calling form's PB and the doubled appearance of popups...

When debugging code for objects on a form I sometimes use ".view" or "msgInfo". These popups appear twice indicating that the code runs two times. As a result results from button presses, etc. take twice as long to appear. It seems a containership issue which I don't know how to resolve.

Thanks for the advice Tony. I will not be given Admin privileges so I'll have to investigate further. dblarch

When starting Paradox as an end user after admin had installed it I get "1706" error. It appeared to be trying to continue installation. When admin logged on Paradox opened without problem. When logged on as an end user, I found Pdoxwin32 executable. I could then start Paradox but the alias...

Thanks Tony, Paradox 10 Help alludes to "CHANGETO" but offers no example of the straightforward and quite helpful query you supplied which was perfectly suited to my problem. The "_a" in your query has the same form as the join string used when querying on two or more tables linked by a common...

I have a field in a table which contains a list of integers used as IDs. I'd like to offset them by a fixed amount as follows: 1->201, 2->202, 3->203, etc. Is this possible in a live query? If not is there some code that will accomplish the task? Thanks, DblArch

Agreed! DblArch

Thanks Perrin, Following your tip I discovered that I could archive the source code to another application using the "Publish As" selection in the "File" menu. This safeguards the code against a complete meltdown of Paradox which protection was my aim. Thanks again, DblArch

Is there a way to dump all the code for a project? I would like to document it in case of a disaster. At present I'm clicking on each object and selecting each method and/or event and copying the code to a word processor. It's very tedious. Thanks, DblArch

Hello Langley, Thanks for the tip. I'm in the process of reading and reproducing Tom Krieg's code. Once I understand what he's getting at I'll apply it, if appropriate, to my situation. Thanks again, dblarch