QBE & SQL Topic

Is it possible to use a variable as a resulting value? Or is it only possible to use a variable as filter.  I would like the value in a variable to be put in the resulting column "DATETIMECHANGED". Thanks in advance, Gary var, todaysdatetime DateTime, custnbr String, qq Query, endVar custnbr = "1234", todaysdatetime = dateTime() qq = Query ANSWER: :PRIV:CHNGED.DB OPTIONS: NO AUXILIARY TABLES,ATA:Items.db | FILENO | CUSTNO |, | Check _join1 | ~custnbr | :DATA:PRICING.db | FILENO | QUANTITY | PRICE | DATECHANGED | REASON | INITIALS | PREVIOUSPRICE | PERCENTCHANGE | PRINTSELECT | LASTREFNO | SETUP |, | _join1 | Check | Check | Check calc ~todaysdatetime AS "DATETIMECHANGED" | Check | Check | Check | Check | Check | Check | Check |, EndQuery if NOT qq.executeQBE() then, errorShow(), else, endIf

{Too Long!}

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

{Too Long!}

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

{Too Long!}

When i use the keyword  FULL JOIN  I get an error message. 

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

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

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? ,

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? :),

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,

{Too Long!}

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.

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

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. 

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.

{Too Long!}

I have a multiple column table which has a column "A" I want to query "A" and show an answer of all duplicates found.

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!

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!

{Too Long!}

{Too Long!}

 (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.

{Too Long!}