I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

QBE & SQL Topic

Query by Example and Paradox SQL (A.K.A. Local SQL)
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Shores
Strange errors with :priv: report master table
{Too Long!}
8 months ago
3 replies. Last post:

Steven.G
if the path name is too long, doesn't matter which way you shorten it.. the printer name, you are best to actually be a shared printer, and shorten the network name
8 months ago
Nothing New Since Your Last Visit
373
Hits

Thread 24 of 25
Thread Starter  

PS_383
pass parameter to paradox sql file
Is there a way to pass parameter to paradox sql file?  Something like:, , Update Table1 Set CurrentDate = ?, Update Table1 Set CurrentDate = :CurrentDate, Update Table1 Set CurrentDate = @CurrentDate, , All I found is this article:, https://stackoverflow.com/questions/12416503/delphi-query-parameter-usage-when-all-values-is-also-an-option
22 months ago
1 Reply:

Steven.G
sorry, haven't touched the sql stuff within paradox in a long time
22 months ago
Nothing New Since Your Last Visit
639
Hits

Thread 23 of 25
Thread Starter  

Jay.M
getAnswerFieldOrder
{Too Long!}
25 months ago
2 replies. Last post:

Jay.M
Thats what I was hoping for that maybe someone would be able to use what I found.. thats exactly why I left the post up.. THANKS!
25 months ago
Nothing New Since Your Last Visit
883
Hits

Thread 22 of 25
Thread Starter  

csgPdx
creating flat file from a normalized table w/ QBE
Some years ago I saw a query of a single normaiized table that gave a flat file answer table. Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments. Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable. However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology. Thanks, NK
51 months ago
Nothing New Since Your Last Visit
1881
Hits

Thread 21 of 25
Thread Starter  

Gary.A2
Help! New old user!
{Too Long!}
45 months ago
Nothing New Since Your Last Visit
1313
Hits

Thread 20 of 25
Thread Starter  

Coder_182
How to do a FULL JOIN in SQL Paradox Editor
When i use the keyword  FULL JOIN  I get an error message. 
5 years ago
10 replies. Last post:

Anibal.C
{Too Long!}
5 years ago
Nothing New Since Your Last Visit
4812
Hits

Thread 19 of 25
Thread Starter  

Gar.L
Running multiple SQL (DDL) scripts against Paradox
HI, Does anyone know of a (free) utility to run multiple SQL (DDL) statements/scripts against a Paradox database?  Ideally used for deployments (where you are updating a database with more than one SQL script) and you don't want to manually run one script after another. Thanks
7 years ago
Nothing New Since Your Last Visit
1665
Hits

Thread 18 of 25
Thread Starter  

John.C
Problem with Delete QBE Queries
We are currently experiencing a problem with 16bit Paradox 7.  When I run a delete query (QBE) the query completes and we would assume that all the data that we want to remove has been removed. However, when we check the table we ran this query on only some of the data has been removed.  So we run the query again..  When we check the table more of the data has been removed but some is still left. We have to repeat this multiple times before all the data is gone.  Each time we repeat it we don't modify the query - its the same one we ran 1st time around. What could be causing this problem and how can we solve it? I would appreciate all advice offered regarding this question. Best Wishes John
7 years ago
1 Reply:

AIBreveleri
Post the QBE.  Try to cut and paste it -- don't retype it.  Also, describe the structures of the tables referenced by the QBE.  Include validity constraints and secondary indices. -Al.
7 years ago
Nothing New Since Your Last Visit
2596
Hits

Thread 17 of 25
Thread Starter  

jlockley
"out of memory error when running query by form
Query by form script gives "out of memory " error at a set point . Large query. Have tried resetting shared memory but not memory location in BDE. Any ideas here what could be done? ,
8 years ago
Nothing New Since Your Last Visit
2079
Hits

Thread 16 of 25
Thread Starter  

Shores
Creating a new logical column with false values
Hi everybody! In the table resulting from a QBE I need to have a new column of the logical type containing all false values. I was used to type CALC 1 AS NEWFIELDNAME  to generate a new longint field named NEWFIELDNAME having the default value of 1. So, I tried doing CALC FALSE AS NEWFLAG, but that syntax produces a new STRING field containing the word "FALSE"... :) I then thought that CALC 1<>1 AS NEWFLAG would do the trick, but that simply isn't accepted by the QBE parser... Any ideas? :),
8 years ago
3 replies. Last post:

Dan
Yep, that will work.   However there is an outside chance that the values will match.  You will need to make sure the value in the helper table has a value that does not exist in the joined table.
8 years ago
Nothing New Since Your Last Visit
2830
Hits

Thread 15 of 25
Thread Starter  

John.G2
Paradox for Windows Desktop has stopped working
I recently bought a new computer  (Core i7, 3.33 GHz, Windows 7 64 bit) and then installed and upgrade to  WP office X15, including Paradox 11. I've been doing this kind of query of decades and had no trouble before., Now,  when I make a QBE I get the usual answer table, but when I go to Query, Properties, Structure and change the query structure order and then  click the Run the Query button the following message appears:  Paradox for Windows Desktop.  Paradox for Windows Desktop has stopped working.  It says it will try to find a solution but never does.  Paradox then closes down. Occasionally, it crashes as above when I only go to Query and then click on Properties., I did a reinstall of Paradox which did nothing and also a reinstall of WPO5.  Still have the problem.  Every other function of Paradox 11 seems to work fine., Any suggestions about how I can cure this problem?  Thanks, JG,
9 years ago
3 replies. Last post:

peterbell
{Too Long!}
8 years ago
Nothing New Since Your Last Visit
6791
Hits

Thread 14 of 25
Thread Starter  

jlockley
Logical field in query by form
{Too Long!}
9 years ago
1 Reply:

Jo_Lynne.L
Answer to self: 1) Declaring as string worked for a bit. Now not passing value to the query.  2) The negative value on the query form must be blank. If set to False, only those records with the value false in the logical field will be called up. The checked  value remains TRUE (Or yes, whatever is desired
9 years ago
Nothing New Since Your Last Visit
2566
Hits

Thread 13 of 25
Thread Starter  

brationer1
Networking Paradox 9
My 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 idea? Will we require an expensive  'top notch' network person to facilitate this.  Please advise me. Thank you very much.
9 years ago
1 Reply:

mprestwood
Sure, this will work well. Just stay away from Vista which it sounds like you are. If you need help, you can post here for free or you can open a support account: Support Account - http://www.prestwood.com/services/support/
9 years ago
Nothing New Since Your Last Visit
2354
Hits

Thread 12 of 25
Thread Starter  

riskmansea
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 the word enter on the  sACCOUNT =  Enter ACCOUNT.value line. Appreciate any help. ;Button :: pushButton, method pushButton(var eventInfo Event),  var ,   sACCOUNT String,   qryCustomer  Query ,   tv TableView ,  endVar  sACCOUNT =  Enter ACCOUNT.value  qryCustomer = Query Answer: :WORK:ANSWER.DB CUSTOMER MASTER.DB|ACCOUNT|NAME|ADDRESS 1|ADDRESS 2|CITY|STATE|ZIP|PHONE|, |..~sACCOUNT|CHECK|CHECK|CHECK|CHECK|CHECK|CHECK|CHECK|CHECK|CHECK| EndQuery   qryCustomer.readFromFile("\\\\Sultanmain\\acctg\\PDOX\\CUSTOMER MASTER") ,   qryCustomer.executeQBE(":WORK:answer.db") ;// run the query   ,   tv.open(":WORK:answer.db")      ;// display the results ,  , endMethod
9 years ago
1 Reply:

Dan
Try this if Account is a field on the form then this should work sACCOUNT =  ACCOUNT.value if Enter_Account is the field name then sACCOUNT =  Enter_ACCOUNT.value otherwise you could use sACCOUNT.view(" Enter the ACCOUNT value")
9 years ago
Nothing New Since Your Last Visit
2113
Hits

Thread 11 of 25
Thread Starter  

brationer1
Using the function
Can "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 like: "(today() - Employee's Employment date)/ 365.25" I can copy the data to a spreadsheet and get a result, but this not what I need. 
9 years ago
3 replies. Last post:

mprestwood
You can base a report off of a QBE file. When the report opens the report, it first runs the QBE then uses the answer table. So, the first step is to create a QBE that generates an answer table with the correct data. Have you gotten that far? Do you have a QBE that shows the correct data? After that, you can use ObjectPAL to pass in values to the QBE to tailor each run of the report.
9 years ago
Nothing New Since Your Last Visit
3325
Hits

Thread 10 of 25
Thread Starter  

simd01
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 either point me to the relevant documents or briefly describe the various problems one is going to confront in achieving this? Many thanks.
9 years ago
2 replies. Last post:

simd01
Robert, many thanks for that. I had been using the SQL link but that was the problem. Once I set up the ODBC DSN and then an alias as you suggested I was up and running. Thanks again - you've made my day. Simon
9 years ago
Nothing New Since Your Last Visit
3412
Hits

Thread 9 of 25
Thread Starter  

hedrickr
Paradox 11 Help Not Working
{Too Long!}
10 years ago
1 Reply:

mprestwood
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
2613
Hits

Thread 8 of 25
Thread Starter  

Cfolkes
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.
10 years ago
Nothing New Since Your Last Visit
3138
Hits

Thread 7 of 25
Thread Starter  

castrow
Show partial records in paradox Answer table
Hi 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 Answer table. Let's say I run my query and get a total of 100 records. Now I only want to show 1/4 of it so I need to show 25 records only in the Answer table. Does anyone knows how to do this? *Reminder: the total number of records is dynamic and sometimes I need to divide the total into 5, 4, 3, 2 and the like.. Thanks in advance!
10 years ago
Nothing New Since Your Last Visit
1988
Hits

Thread 6 of 25
Thread Starter  

castrow
Primary key and SQL
I'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 resturcture but it keeps giving me the error "Record size is too big for table". Help please thanks!
10 years ago
Nothing New Since Your Last Visit
1798
Hits

Thread 5 of 25
Thread Starter  

lcwing
Select records unique only in one field
{Too Long!}
10 years ago
4 replies. Last post:

mprestwood
Hi A.I., I do appreciate all your posts. What were you trying to do that lead to problems? What are you seeing? I saw you had some garbage characters in there usually caused by copy/paste, I edited those out. I played with the post a bit to try and figure out what you were seeing. Anyway, let me know and I'll dig into it. Mike
10 years ago
Nothing New Since Your Last Visit
2981
Hits

Thread 4 of 25
Thread Starter  

tony-jordan
Sporadic "Permission denied." Query Errors
{Too Long!}
11 years ago
8 replies. Last post:

mprestwood
You're welcome Tony. Glad it worked out.
10 years ago
Nothing New Since Your Last Visit
7289
Hits

Thread 3 of 25
Thread Starter  

piolenc
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 certain other fields of the same table. I built and tested the selection criteria first. They work: the five lines of the  query together select every record of the table exactly once. The trouble starts when I add the CALC statements - one formula for every selection criterion. I get the error message: "Query appears to ask two unrelated questions" unless the CALC statements are identical (which defeats the purpose). There are no duplicate example elements, and when I leave the example elements in place and delete the CALC statements that use them, there's no error. It seems that I'm allowed a useful query or a working one, but not both.
11 years ago
7 replies. Last post:

AIBreveleri
Read your private messages for more help. Or, if the combined QBE is not large, post it here. Also post the table structure if you have time. -Al.
11 years ago
Nothing New Since Your Last Visit
3394
Hits

Thread 2 of 25
Thread Starter  

wirwl
Problem with Query
{Too Long!}
11 years ago
1 Reply:

mprestwood
What is the error on the one workstation that has the error? Are you still having this error?
11 years ago
Nothing New Since Your Last Visit
2625
Hits

Thread 1 of 25
Thread Starter  

clh3332
QBE to find non-matches
{Too Long!}
11 years ago
1 Reply:

greens
{Too Long!}
11 years ago
Nothing New Since Your Last Visit
2680
Hits

New Thread
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech