Joshua Delahunty Message Board Activity

FWIW,, , I tried the conditions you mentioned (test library and form) under Pdox 8 (7 isn't as handy), and it works fine, with the uses statement set to EITHER, , Uses ObjectPAL, "dirlib.lsl", enduses, , OR, , Uses ObjectPAL, dirset() string, endUses, , (your instructions didn't say that you removed the "objectpal" identifier, so I didn't do so either)

Posted to MB Topic: ObjectPAL « Paradox Board

[QUOTE]Originally posted by hypenozys:, [qb] I have a program that does a lot with strings, and is required to work everywhere in the world, so also in Asia for example. What is the way to do this in Delphi? Only use the Ansi... string functions? If ...

Posted to MB Topic: Delphi Object PASCAL « Delphi Board

I have a program that does a lot with strings, and is required to work everywhere in the world, so also in Asia for example. What is the way to do this in Delphi? Only use the Ansi... string functions? If i understand correctly the default string type should support this. If i write code like, , var SomeString: string;, SomeChar: char;, begin, if SomeString[1] = SomeChar then blablaDoes this work in other locales? If not how to do this? How do i get the length of a string (in characters)?, , If i understand correctly the only reason Delphi is not 100% unicode is because it would break Win9x compatibility. Please go ahead Borland! I don't want to worry about this crap...

Posted to MB Topic: Delphi Object PASCAL « Delphi Board

I haven't, but a little googling resulted in this:, , http://web.comhem.se/~u82608896/paradox/errdocs/eid149.htm , , (in case it goes down, and to not force people to click, here's a quote:), , --------, , 149 No more files., , Problem: Getting error "No more files.", , When trying to open a table on a server., , Case 1, , Date: 21 September 2000, , Versions: P9, , Possible cause reported by: John B. Moore (C_Tech) < jbmATmicrops.com >, < QUOTE >, The problem that you are running into with the error message "No more files" is a new issue that we have become aware of in the last few weeks. This appears only to happen when connecting a 32-bit client to a 16-bit server (which should be the case with an Alpha VMS emulating a DOS drive partition). At this point we are looking into the problem to determine if it is an issue with the BDE or if it is a Windows networking problem. At this point there is no estimated time that I can give you for a fix/work-around for this issue. I can tell you ...

Posted to MB Topic: ObjectPAL « Paradox Board

Not how I'd read it., , I think Paul's saying you could create new forms in Pendragon, "talking" to a Paradox database using the Paradox ODBC driver, where the Paradox tables sit on a PC "remotely". This would give you paradox table access from a wireless Palm unit., , On a re-read, I can see it referring to an Access database too, but maybe not... :-), , Call me the optimist...

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

That is what is known as a "not-in" query., , The User's Guide used to have an example of this in the section titled "Retrieving records from one table that aren't in another table", in the chapter on Queries using groups, sets, and inclusive links., , The rumor (as I heard it while in training at Borland) is that a Borland engineer at a User's Group meeting (or conference, not sure which) was asked how to do such a query, and told the audience it wasn't possible. A crack teen-aged user who had a lot of experience with QBE managed to form the solution before the talk was out., , Damned kids. :)

Posted to MB Topic: QBE & SQL « Paradox Board

How can I make a QBE that gives me the records of partno in table X which is missing in table Y ? , The Utility -> Subtract gives me the result, but I want to do the same in a QBE. , I have the same field: "Partno" in both table X and Y. , If I run a query on partno in table X and Y I get the partnumbers which are in both tables. How do I find the ones which are not in table Y ?, , Regards Peter

Posted to MB Topic: QBE & SQL « Paradox Board

The question runs somewhat counter to the "theory" behind SQL, which views result sets as maleable "sets" of information, without necessarily fixed indices., , Don, will double quotes work in your SQL? That's really what they're for..., , SELECT T."My Field Name with Spaces" FROM MyTable T WHERE T."Hire Date" < '01-Jan-1984', , Note: Double quotes for idenfiers, single quotes for string literals -- I have to put that every time, lest I forget the details *g*..., , -- joshua

Posted to MB Topic: ObjectPAL « Paradox Board

I'm trying to refer to a paradox database using the paradox odbc driver on my server and it doesn't like field names with a space. I'm wondering if anyone knows how to refer to a field in an SQL statement using the fields number rather than it's name. Any help would be appreciated. , , Don

Posted to MB Topic: ObjectPAL « Paradox Board

Hello,, Do you know what code to use to PLAY a WordPerfect macro file (mymacrofile.WCM) from objectpal. Thanks.

Posted to MB Topic: ObjectPAL « Paradox Board

You didn't specify versions of Paradox or WP., , I used PdoxWin 8 and WP 10, though I didn't make the OLE Automation name specific to any version of WP here. , , Done as a script, but that doesn't matter., , |method run(var eventInfo Event), |var, | sOLEServerName String, | sDocumentName String, | sMacrofileName String, | oaWordPerfect OLEAuto, |endVar, |, | sOLEServerName = "WordPerfect.PerfectScript", | sDocumentName = "C:\\TEMP\\TESTDOC.WPC", | sMacrofileName = "mymacrofile.WCM", |, | if (oaWordPerfect.open(sOLEServerName)) then, |, | try ; if won't catch an error here, | oaWordPerfect^FileOpen(sDocumentName), | onFail, | msgStop("Error", "Couldn't cause WordPerfect to open document " + sDocumentName), | endTry, |, | oaWordPerfect^MacroFilePlay(sMacroFilename), | oaWordPerfect^Quit(), |, | else, | ...

Posted to MB Topic: ObjectPAL « Paradox Board

We helped a client determine whether Windows XP would do this trick for him, and I could find no problems whatsoever when I ran his Paradox for DOS 4 app under a Windows XP command prompt. The printer took some doing, but it turned out I could capture anything sent to LPT1, and redirect to a modern, USB-only printer, and it worked great. We used Windows XP Pro for our tests.

Posted to MB Topic: Paradox for DOS « Paradox Board

A QBE query file is "just" a text file, so you could load it in Notepad or Wordpad or just about anything else to get it to print. [Interesting side note: there was a strong contingent of Tech Support engineers within Borland who felt that the dev team should "fix" Paradox to automatically invoke Notepad on any query file that Paradox refused to load (usually because of a renamed field that was no longer relevant), but the dev team never did add that rather simple enhancement], , For that matter, you can open a Textstream on a QBE file in OPAL code, reading in the text that way, to either parse into something else you wanted, or to manipulate some other way.

Posted to MB Topic: MS Access Interactive « Access Board

When you first create a SetFocus event, Paradox inserts an if-block that shows how to react based on the form, or every item on the form (using the isPreFilter() call). Use a similar block to only activate your code for the Form show, and eliminate some of the overhead. While it may be tempting to worry about the rest of the overhead (lots of calls that simple "fall thru" for every object), it's best to let that go, since this is the way it was designed to work., , To be clearer, code your SetFocus event as:, , if (not eventInfo.isPreFilter()) then, ;// insert your code here, endif, , -- joshua

Posted to MB Topic: ObjectPAL « Paradox Board

[QUOTE]Originally posted by Marine1:, [qb] Thanks Joshua,, , I wonder is it more by design or mistake that the "bad" ones slip by to the client. I don't think I would have the expertise to recognize a "bad" one., , I know that from a Marine Corps perspective some mistakes are unforgiving and costly too. Or more so is it a matter of "normalization" being influenced by cost? Thanks again., , Until that time....stay motivated, , Kevin [/qb][/QUOTE]It's an experience thing. Once you've had to rearchitect, or even worse work around, a bad data model, you learn quickly what made/makes it a "bad" design, and you avoid it in the future., , Also, you might end up spending a lot, in time, in money, in effort, to fix a bad design. Again, this (hopefully ;-)) smartens you up quickly.

Posted to MB Topic: Just Conversation « PrestwoodBoards Board