Steve Caple Message Board Activity

Remotely supporting a user who is getting the following message on trying, to open Paradox:, , "An attempt was made to access an unknown file past it's end", , This follows a long wait with just the Paradox9 splash dialog and an hour, glass., , I couldn't find a reference to this in Bertil's error message page, and on, the web the only hits seem to be in support sites forother programs: Roxio, and Reference Manager., , Paradox 9, XP Home SP1, P4 2.2GHz, 256MB RAM (!!!  -  yes, yes, I know, but, her boss is on vacation otherwise it'd already be up to a gig), , , The same user has often got messages that her virtual memory was below, minimums, but after walking her through manually setting it to 768/1536, that may have disappeared., ,

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

John, Is there any chance you have some printers that aren't connected?  Windows can spend a lot of time looking for those.  I've also heard that you may need to do a registry scan to clean out some old or missing printers.     Also, some like to spin their own print form and to use the ReportPrintInfo dynArray syntax. It's not that hard and many have had good luck with it.

Posted to MB Topic: ObjectPAL « Paradox Board

Yesterday I got a call from my wife that a printer in the library on developmental disabilities was not working properly. Another low cost PDF writer is CutePDF. It's freeware, which was handy since she was doing some work at a really, really, non-pofit site. Over the phone I walked her through Googling for CutePDF, downloading and installing the required files, and after a restart she was able to print the Paradox report to a .PDF and eMail the .PDF to the behavioral analyst requesting it. An IT guy showed up an hour later and fixed the Lexmark printer setup in Windowsb (something I REALLY didn't want to try to walk a non-computer person through on the phone), but at least they have the backup AND a way to send reports via e-mail.

Posted to MB Topic: Paradox Reports « Paradox Board

Hi - My wife and I have taken over Administration of a large Amateur Theatre company in London - the only salaried position (as a jobshare).  We have inherited "interesting" old procedures and equipment, including a PC running Windows 98 and a Paradox-based Box Office system called Databox.  It is my wish to develop better-looking sheets of daily bookings for the Box Office volunteer staff to use.  I have managed so far to create QBEs that select the desired data, but seat numbers have been defined as alphanumeric (by the Databox people, so I can't change the definition), with the result that they are sorted thus:26, 27, 3, 33, 34, 4, instead of 3, 4, 26, 27, 33, 34.  I have 25 years' experience of programming, so I can cope with adding zeroes on the left and taking a three-character right substring, but the help in Paradox 7 doesn't give me enough idea as to how/where to insert this code so as to produce the required query results.I should be grateful for specific ...

Posted to MB Topic: Member Introductions « PrestwoodBoards Board

Jonathan,I'm not sure how the SQL will turn out for you with the new BDE, so as an alternative,  do you have access to permanently change the seat numbers in the Databox tables?  That is, run a tCursor scan loop using the format() and string() function to change "3" to "003", etc.?  That would allow you to use the QBE queries you've already developed.  Show me the table structure and a sample of the data and I'd be happy to write the code for you.

Posted to MB Topic: Member Introductions « PrestwoodBoards Board

To my knowledge the only way you can do that is to use a "resource manager" to edit the Paradox executable  -  not the sort of thing I'd want to do.   I did an advanced groups search on all the Paradox newsgroups for "change tackbar icon" and "custom taskbar icon" and found no help there.

Posted to MB Topic: ObjectPAL « Paradox Board

To amplify what I meant by doing it another way, what I would do is create a table (use the table type create statement) of the appropriate structure, then scan my data source, process it however you are doing now using breakApart(), etc., and as I broke down each line I'd use a tCursor opened on the table I created to insert the data in fields; then I'd use a small dialog form to display the data in a tableFrame, the columns taking care of alignment despite proportional font effects.

Posted to MB Topic: ObjectPAL « Paradox Board

I am having a problem in alignining the list box string display, when string is combination of two or more variables.

Posted to MB Topic: ObjectPAL « Paradox Board

Mike, I think he wants to track and search information about the files  -  including their locations  -  in Paradox, and double click on hte name or press a button or some such and trigger the Acrobat application.

Posted to MB Topic: Paradox Forms « Paradox Board

[QUOTE]Originally posted by cc108:, [qb] i am trying to export a report to a txt file, but i need it to line up in a specific way. I need to data to be on specific lines in specific spaces. Is this possible, and how do I do it? Any help would be greatly appreciated [/qb][/QUOTE]Sorry not to get to youy sooner; I usually get e-mail notices of questions in the Paradox area, but I've been in Europe the past month and a few things have changed here also., , It sounds like you might be trying to export text data to be printed on a paper form, or else that you need to export a text file with particular formatting requirements. For the time being I'll assume it's the latter, and suggest a few areaas to start looking at., , The basic approach you want to take involves scanning the data with a tCursor (or tCursors if you're relating two or more tables - let me know just what the case is) in a scan loop - or nested scan loops - and with appropriate qLocate() actions - and writing it to a text...

Posted to MB Topic: Paradox to/from Other Data Sources « Paradox Board

i am trying to export a report to a txt file, but i need it to line up in a specific way. I need to data to be on specific lines in specific spaces. Is this possible, and how do I do it? Any help would be greatly appreciated

Posted to MB Topic: Paradox to/from Other Data Sources « Paradox Board

You want a "not in" query - , , CUSTOMER | CustID | CustName | CustAddr |, | Check _CID! | Check | Check | , ORDERS | CustID |, | _CID, count = 0 | This finds all customers who are not in the Orders table. The inclusion operator (!) after the example _CID tells the QBE engine to find all records even where there is no match; the count = 0 in the Orders CustID field says find only those where the count of CustID in Orders is zero.

Posted to MB Topic: ObjectPAL « Paradox Board

I'm glad you found that doc error - I was out of ideas about why it wouldn't work. , , Steve

Posted to MB Topic: Paradox Third Party Software, DLLs, and Controls « Paradox Board

Hi, , , trying to setup references to DLL file. The DLL has several methods, which i have example code for for Access, VB, ASP not Paradox (surprisingly!) Most of the methods work fine for eg,, , Uses afdnn32, GetPostcode(nnRec CPTR, RecNo CLONG, nnFlags CLONG) CLONG, endUses, , this method in Access looks like this,, Declare Function GetPostcode Lib "afdnn32.dll" (nnRec As nnRecType, ByVal recNo As Long, ByVal nnFlags As Long) As Long, , Not a problem, the problem is the following method, which in MS Access looks like this..., , Declare Function FastFindGetFirst Lib "afdnnfind.dll" (ByVal str As String, ByVal oldpcode As String, ByVal pCode As String, addrNo As Long) As Long, , In Paradox I have,, FastFindGetFirst(str CPTR, oldPcode CPTR, pcode CPTR, addrNo CLONG) CLONG, , the problem with the FastFindGetFirst method in MS Access is the addrNo data type is not declared 'ByVal', my problem is in Paradox I can only seem to declare addrNo as a variable and not a pointer which i think it ...

Posted to MB Topic: Paradox Third Party Software, DLLs, and Controls « Paradox Board

I have been using Paradox 10 without too many problems for quite a while but recently installed Paradox 11 (full Wordperfect Office 11 suite) plus all service packs., , Now I am unable to print any reports from Paradox 10. Pdox 10 stops responding, the menu bar and open windows go blank and I need to stop the app through the task Manager. No problems printing from 11 but it won't open delivered reports compiled in 10., , Has anyone else experienced this problem?, Does anyone know a solution to this problem?, Should I uninstal version 11 and stay with 10?

Posted to MB Topic: Paradox Reports « Paradox Board

I haven't run into this because I don't have - and don't intend to have - Paradox 10^h^h11. (just a little WordStar joke there) Seriously, Corel hasn't really done much of anything, if anything really, since version 10 that I can't live without. I know a lot of folks running business appllications using versions 8 or 9 under Win-XP. Me, I'd stay with 10.

Posted to MB Topic: Paradox Reports « Paradox Board

I have been raking my brain with this. And I would like any help I can get. Thank You!, , The best way I can explane this is by using an example..., , I highlight the buiness "paper works", , Then I click on the button 'info', , A window pops up with the info on paper works., , Then I highlight the buisness "Computer Cont.", , After I click on the button 'info' a window pops, up with the info in Computer cont., , Now that is what I want to have happen, but it is not., , When I click on the button, 'info' the window pops up but it always gives me the same company info. the first one in the list., , How do I do it so that when I click on the button, 'info' that the info about the buisness that is highlighted will popup in a seperate window?, , Thank You!

Posted to MB Topic: Paradox Forms « Paradox Board

The code needs to open the form; the example below first checks to see if it IS open already by trying to attach() to it; attach() requires the form title that you set in the Window Style dialog when you created the form., , Once the form is open, you have to locate the appropriate record. The example below assumes that the MRO on the info form is called CUSTINFO, and that its table is either keyed on CustID or has a secondary index on CustID that was set by a switchIndex() in the MRO open() event. The code then tries to locate the customer using the CustID value from the ORDERS form record on the calling form, and if that is successful it waits for the return from the form. This would usually be dome with a button labeled OK on the info form that does a formReturn(TRUE). When the formReturn happens, the code on the calling form button closes the form., , If the locate function is sloww, you can open the form hidden (add a WinStyleHidden argument to the f.open() and after the locat...

Posted to MB Topic: Paradox Forms « Paradox Board

Using PDX Expert I have written the following script, but when used in Runtime the message says "Function not available in runtime version", Can anyone help or I would even prefer on a Button., method run(var eventInfo Event), var, dtHandle DataTransfer ;// handle to transfer variable, , tvTable TableView ;// tmp handle for displaying imported file, endVar, , ;// Set notification for user, setMouseShape(MOUSEWAIT, TRUE), , dtHandle.setSource("CallInsert.txt", dtASCIIVar), dtHandle.setSourceCharSet(dtANSI), , ;// Enable the key violation and problems tables, ;//, dtHandle.setKeyViol(TRUE), dtHandle.setProblems(TRUE), , ;// Setup delimited import options, ;//, dtHandle.setSourceSeparator(","), dtHandle.setSourceDelimiter("\""), dtHandle.setSourceDelimitedFields(dtDELIMALLFIELDS), , ;// We are always appending in this script since we force the, ;// destination table to always exist, ;//, dtHandle.setDest("Call.DB"), dtHandle.setAppend(TRUE), , ;// Perform the imp...

Posted to MB Topic: Paradox Runtime & Distribution « Paradox Board

[QUOTE]Originally posted by Paul Castelow:, [qb] Hi Steve, where does the first code go? [/qb][/QUOTE]Uh, er, hunh? I'm not sure what you mean by "the first code"; the method example I showed could be in a library or on a form, and could be used to present a table in a tableView like presentation without running afould of Runtime limitations. Of course you may well want to choose different method and form names.

Posted to MB Topic: Paradox Runtime & Distribution « Paradox Board