| | Thread Starter | Replies | Last Post |
 120
Hits |  Networking Paradox 9My company has intentions of running Paradox 9 on Server 2008. The Operating System on most of our computers is Windows 7 Pro. Is this a good ... | 1 | Sure, this will work well. Just stay away from Vista which it sounds like you are. If you need help,... 7/25/2010 |
|
92
Hits | Value to a query-push button on a form Attempting to set up a form to query customer information by entering the account number. I copied the code from the guide but it fails. The debug highlights th... | 1 | Try this
if Account is a field on the form then this should work
sACCOUNT = ACCOUNT.val... 7/7/2010 |
|
206
Hits |  Using the functionCan "Today()" be used in a QBE or a Report? I am trying to use it in order to find the number of years an employee or a group of employees worked.
Something li... | 3 | You can base a report off of a QBE file. When the report opens the report, it first runs the QBE the... 6/11/2010 |
|
333
Hits | Using MS SQL as back end I need to set MS SQL up as the back end to a large multi-user paradox 10 app and am having trouble finding discussions of the issues involved. Can someone eithe... | 2 | Robert,many thanks for that. I had been using the SQL link but that was the problem. Once I set up t... 5/2/2010 |
|
350
Hits | Paradox 11 Help Not Working {Too Long} | 1 | Hi Raymond,
Did you ever fix your Paradox help file problem with Windows 7? I do know that you have... 1/30/2010 |
|
550
Hits | Find duplicate data in a column using query I have a multiple column table which has a column "A"
I want to query "A" and show an answer of all duplicates found. | 0 | New! 3/18/2009 |
|
439
Hits |  Show partial records in paradox Answer tableHi guys I've got tons of questions regarding paradox with so little time to figure things out. I hope you can help me as soon as possible.
I wrote SQL in paradox to show the results in an ... | 0 | New! 3/18/2009 |
|
256
Hits |  Primary key and SQLI'm a noob with paradox and I want to know if it is possible to set a primary key to an existing table using the SQL in paradox? I want to set 2 fields as primary keys. I tried doing it via table rest... | 0 | New! 3/17/2009 |
|
445
Hits | Select records unique only in one field My table has the following fields:
Last Name
Full Address
Zip
I have several records which have the same Full Address but different Last Name. I want to s... | 4 | Hi A.I.,
I do appreciate all your posts. What were you trying to do that lead to problems? What are... 3/5/2009 |
 1366
Hits |  Sporadic "Permission denied." Query ErrorsI have a Paradox for Windows app I developed more then ten years ago. Recently my client has experienced inconsistent "Permission denied." error... | 8 | You're welcome Tony. Glad it worked out. 1/1/2009 |
|
742
Hits | QBE error: unrelated questions (Paradox 9 under W2K) I'm building a query to enter new prices in a calculated field called PRICE, using different formulas depending on the values in cer... | 7 | Read your private messages for more help.Or, if the combined QBE is not large, post it here. Also po... 11/17/2008 |
|
651
Hits |  Problem with QueryHello!
There are problem in query:
Can't process this query remotely.
This is part of code:
q_first=Query ANSWER: :PRIV:blankRazr1.DB REGISTR.DB | | |... | 1 | What is the error on the one workstation that has the error? Are you still having this error? 9/25/2008 |
|
688
Hits | QBE to find non-matches I am relatively new to Paradox and making my way by reading the documentation as well as the Prestwood books. Recently I ran across the following problem:
My c... | 1 | if you have an answer with extra data, you can always do a 'delete' query on the answer table, but h... 8/27/2008 |
|
818
Hits | QBE Specifications On my current contract I have to deal with a pretty big application based on Paradox 4.5 for DOS. They do have PAL manuals, but not Paradox User's Guide. So, I ... | 10 | Thanks. I can see it already. However, this can be said of almost every old DOS-times in-house appli... 8/20/2008 |
|
856
Hits | QBE excluding records Howdy, I know there should be a way to do this, but I can't figure it out. ... | 3 | I'm not even sure that you can get that result in a QBE. You can use SQL in paradox to get the... 5/5/2008 |
|
508
Hits |  Programming with QBE results
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... | 2 | Hi Jon,I noticed you started subscribing to our monthly eMag but you still need to verify your email... 2/23/2008 |
|
496
Hits | large table/multi table Query Question Lets say you have a table with customer information and the table has about 30 fields with 1 million records, this table is nearing 2 gigs, and eventually this ... | 7 | Id like to thank everyone for their posts and ideas, i have been thinking on what i should do based ... 10/5/2007 |
|
443
Hits | No Subject Hi,I have Paradox 9 and whenever I try to save a query with more than one Filter (F12) I get an error message that reads "The Query is Too Long" when I try to r... | 2 | I've never run into this problem with paradox 9 and I've built some fairly large queries. Does... 7/16/2007 |
|
316
Hits | Deleting duplicate records I have 4 tables each with Two Alpha fields. Field1 contains the code number of a runners "Toe Chip" (Electronic ID - A7). Field2 contains the time of day "hh:m... | 1 | What do you mean, "*without* changing the order of the codes"?. This query will extract the data yo... 8/31/2006 |
|
631
Hits | Subtract records in a Query 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... | 5 | That is what is known as a "not-in" query. The User's Guide used to have an example of this in the ... 1/5/2005 |
|
695
Hits | SQL UPDATE in Paradox I am trying to link two tables together and update a field with values from the other tables field. Can I do this? If so how? This is an example of what I hav... | 1 | Do you have any experience with Paradox QBE queries? Even if you don't, it might be worth the troub... 11/16/2004 |
|
464
Hits | SQL How do I run a saved SQL statement from a form in Paradox 9? All of the custom code that I have here to look at uses queries instead of SQL statements. I would ... | 1 | Try using the ReadFromFile function. This will allow you to use sql files created with the paradox ... 7/6/2004 |
|
508
Hits | Paradox SQL We are running Paradox 9 on Windows XP. I want to allow users to click on an icon and run a SQL statement over a Paradox database and then print the results. Wh... | 1 | You can run SQL statements using both the runtime and the full version. You will need the full vers... 6/9/2004 |
|
461
Hits | Using embedded SQL with reports? I have the following problem: I have to use embedded SQL in a program, and then I have to base a report on the results of the SQL. The problem that I have is t... | 5 | I saw in the Help files that there is a report open statement, that specifies a SQL string as a argu... 4/29/2003 |
|
2332
Hits | nested SELECT statements How do you construct nested SELECT statements in Paradox? For example, this query would work in sql server but would error out on the second SELECT keyword: S... | 18 | No, setGenFilter would not work, but ranges do: i.e. >= 5, <= 10 gets 5-10 in that field. 1/8/2003 |
 |
Paradox
MESSAGEBOARD Q&A
KNOWLEDGEBASE
Contact Us
Printable Version
PrestwoodBoards