Recent content by PhilUK

We have recently migrated W98 to W-XP, including 10+ users of a Paradox for DOS 4.0 application. We are experiencing problems (20+ per day) where XP loses the network connection (XP shows that the network drives are not available and oftens reports a "Windows delayed write failed" message)...

We do this quite a lot in our code. myfile = "myfile.rpt" IF ISFILE(myfile)THEN RUN NOREFRESH "Del " + myfile ENDIF RUN issues a DOS command ("Del myfile.rpt"). NoRefresh is an option which freezes the screen, hiding the result of the command. Phil

The fact that you can start Paradox as Admin user, means that the change from Novell is not a problem. This message usually means that the user does not have write/create/update access (probably the last one is needed as the .NET file will exist). This file is needed for all users, so all...

I have had this message in the past, but not for a long time now, so can't remember the solution, but can offer a few ideas. Paradox has a physical limit of 128Mb. The largest table we have is 150,000 records, 38Mb and is okay. There is another 35,000 record, 15Mb table that is...

It may depend on which version of Paradox, but certainly, in DOS, you are limited to the amount of Math functions that can be used in a query (eg INT, ROUND can not be used). So I can't come up with a method of doing this in a query. I tend to use a SCAN loop and do each record in turn. SCAN...

I'm not clear what you want, but something like SUBSTR(NumVar, LEN(NumVar), 1) will get the last digit of the number To get, say the 3rd from last digit SUBSTR(NumVar, LEN(NumVar)-2, 1) So 123456 will give 4 12345 will give 3 1234 will give 2 Phil

We had the same problem with printing to Novell Netware. This can be solved by adding a timeout (in seconds) to the printer queue, either using capture, q=qname ti=10 (plus other parameters) at a DOS prompt, or in the user or system login script when printer queues are defined. With ti=10, the...

I concur. There are no PAL functions for this kind of thing, so you are restricted to either trimming out the unwanted stuff from the return of USERNAME() or alternatively put a value in each users Paradox.cfg, so that will be used as the return of USERNAME() (only valid if each user has a...

It depends on what you want to do with this field, but as if is difficult to sort/select on this kind of field, you may be better advised to just have 2 fields one for date and another for time. If you actually want to use the date/time field for sorting, I suggest you create a calculated...

Have a look through this forum, there are a number of discussions about using Paradox for DOS under 32-bit Windows. Part of the problem may well be too much memory on the PC, Paradox does not like more than 16Mb. Can be fixed with the command line option -extk n where n is a number of kb...

CrossTabs... Suppose you have the Answer to the query Total Sales, per month, per State. State Sort Month Sales HI 1 Jan01 45 HI 2 Feb01 10 NY 1 Jan01 100 NY 3 Mar01 922 Your could get a crosstab to make this look more like a spreadsheet State Jan01...

Paradox uses various Sort Orders, eg ASCII or International (or other languages). It is unlikely that your tables from a single source have mixed indexes, but it could be. When I've had problems loading Pdox into Access, the settings in Local Machine/Software/Microsoft/Jet/Engines/Paradox are...

If you want a range of dates, then set up a table with a structure like Sort N* Name A10 StartDate D EndDate D Sort will keep things in the right order! Name will be like Jan01, Feb01 etc. StartDate will be 1.1.2001, 1.2.2001 EndDate will be 1.2.2001, 1.3.2001 (end is the first of the...

The other thing is that Paradox hates memory above 16Mb. YOu can limit it to the maximum with the command line switch -extk 16000. ie run paradox -extk 16000 Click on the Keyword search tab in this forum and search for 0000, other threads with this problem may help you. Phil

This kind of error message so early after starting Paradox usually relates FILES= in the config.sys of the PC running Paradox. This has to be aleast 40. If FILES=40 (or more to a max of 255, but suggest less than max), it could be that the Paradox NetFile Location has not been set for a...