Paradox Forms Topic

I'm trying to select records based on date; if I do the following it works Aux = "Citas"

dbTable =  ":Citas:" + Aux TempFile = ":Citas:##Temp" + Aux SQLVar = SQL SELECT * FROM ~dbTable WHERE

(FechaCita < '01/18/2013') endSQL

SQLVar.ExecuteSQL (PacData, TempFile) but if I try to use a variable for the date comparison it gives me an error (Type mismatch in expression):    FechaMaxS = "18/01/2013" SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < ~FechaMaxS ) endSQL I also tried the following but it gives the same error: SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < CAST(~FechaMaxS AS DATE) ) endSQL Could anyone tell me the correct syntax?  Thanks

I borrowed/modified coding from one of Mike's samples. When I run the query the answer file is created without returning the joined field and without returning any data. The query works fine if I am only using one table. Is there a way to joint the two tables? Coding is as follows: method pushButton(var eventInfo Event),  var,   r Report,   q Query,   s String,  endVar s = WORK_ORDER_NUMBER.value q = Query ANSWER: :PRIV:ANSWER.DB FLEET SERVICE.DB     | WORK ORDER NUMBER |  MODEL  |  UNIT  | LTD HOURS | SERVICEMAN |,                               | _JOIN1,Check  ~s        |   CHECK |  CHECK | CHECK       | CHECK       &nbs...

I recently converted an app from 7.5 to paradox 11 and I am finding when entering Memo fields  with @ and . in them automatically do a mail.sendDLG() opening a new email message with the contents of the memo field as the TO: field. Does anyone know how to control this? Thanks

Over the past year I have been migrating from Paradox 7.5 to Paradox 11. I am finding that in Paradox 11 I am having trouble using readprofilestring calls as the Calculated value of a field definition.  After Definiing the value, when I try to run the form(or report) I get a general protection error and often the session is currupted and I have to leave (or Ctrlaltdlt) paradox and go back to a previously saved version.  It seems like I can use one profilestring definition in a form, but a second will cause the curruption. I just did a test, and a profile string statement that works when I set it in Pdox75, but it causes the above problem when I try to set it in PDOX11.  And the PDOX7 created form will run in PDOX11. But if I edit the the field definition and try to run the form in PDOX 11, it curupts the session. Has anyone else run into this?  Any Comments? Here is a readprofilestring statement that can be used in PDOX75, run in PDOX11 but not edited in P...

{Too Long}

I've done a good bit of ObjectPAL programming and quite a bit of work on Forms - but I've never mixed the two!The database (myData.db) I'm working with has this structure:mdPerson (A8); mdEvent (A4); mdYear (SmallInt); mdMonth (SmallInt)I have a form based on that database which is primarily a crosstab of mdMonth (column) by mdEvent (row) with the content of the cells being Count(myData.mdPerson) [Thus it gives me a count of how many of each event type occurred in each month.]What I have been doing is manually setting a Filter (from the Format menu) something like mdYear > 1999What I would like to have is a form where I can do that in the form itself.So I've added to the form these fields:myYear (SmallInt);  myFilter (Radio Button: "No Filter", "Year Only", "> Year", and "< Year") So I think I would use the PushButton method on the Radio Buttons, but how do I reference the value in myYear and how would I set the Filter on myData?Thanks!!!

HI Guys, I am pretty new to programming as such. Recently I undertook a project where I had to change the current forms to show an edit form before records get posted to the server table for good. However, one of the users is complaining that when he tries to enter data, the form seems to jump such that the line he was editing is not the line he should be.  Of all the users he seems to be the only one having this problem.  One other has said that it happens to her sometimes. I have looked at all the code, stripped all the unwanted code and cannot seem to see any reason why the form would be jumping for only one user. Can you help..it'll be well appreciated. Many Thanks, Ansuiya

I have created a query form. I want to sort the output by a specific  field, in this case the status date. I believe i would use AnswerSortOrder in my coding to acomplish this but I am not certain. I looked in my Object Pal reference guide for a sample of this coding and tried to adapt it but am unable to get the query to sort: The coding is as follows: method pushButton(var eventInfo Event),  var,   sUNIT   String,   qryFLEET  Query,   tvAnswer  TableView,   FLEETFIELDS Array[STATUS DATE] STRING  endVar,     qryFLEET.getAnswerSortOrder(FLEETFIELDS)  sUNIT = Enter_UNIT.value  qryFLEET = Query,   ,    ANSWER: :PRIV:answer.db    FLEET.UTILIZATION.db | MODEL  | UNIT       | SERIAL NUMBER  | STATUS |LOCATION/CUSTOMER | STATUS DATE |   LTD HOURS |, &...

Trying create push button form for query. coding below: I get an error. Highlighting the line: sStock = Enter_UNIT.value Any assistance as to where my error is would be appreciated. method pushButton(var eventInfo Event),  var,   sStock  String,   qryFhistory Query,   tvAnswer  TableView,  endVar  sStock = Enter_UNIT.value  qryFhistory = Query        ANSWER: :PRIV:ANSWER.DB    FLEET.UTILIZATION.db | MODEL  | UNIT        | SERIAL NUMBER   |,           | Check  | ..~sStock.. | Check       |  EndQuery  executeQBE(qryFhistory),  tvAnswer.open(":priv:answer.db"), endmethod

I have a Paradox 9 form which is linked to client information. In the lower portion there is a space for case notes involving client communications. The columns include date, speaker, and notes, (also there is a column to differentiate entries made on the same date.)When entering a new case note, a user enters edit mode (F9) scrolls down past the last note to create a new blank one, hits space bar 3 times for current date, enters their initials under speaker, and then proceeds to input the new communication.Everything has worked fine, (albeit slowly on occasion), until today. When someone creates a new note, Paradox APPEARS to also blank out a random prior note. As the operator proceeds with the new note, the information is duplicated in the prior row as well. When the note is complete, exiting edit mode (F9) does not fix the issue, but scrolling up and highlighting the glitching entry will revert it to it's original form.Since this issue appears to be visual only, it's not catastrophi...

Can't seem to get control over font typeface and size for OLE ListBox object in Paradox 10 ... set it to what I want with properties, checked that settings I requested are set in Object Explorer, but when it displays the font typeface is always MS Sans Serif, font size 10 (I think).  Tried using a list type field instead which does display properly, but doesn't support multi-selection, which I need ... what am I missing????

How can I make a form open as a dialog scroll with the mouse wheel the same way it does when form is open as a window?

Hi Everyone, I have a numeric field in a form that currently allows an eleven digit number.  Any number larger than 11 digits is truncated.  I have removed the picture and formatted it as a General number.  How can I increase the number of digits allowed? For info the specific number is 277525910102 so you can see it does not exceed the floating point capacity. Thanks Shaun

{Too Long}

Recently I've been trying to write some code to prevent my operators from getting into Windows via the Windows buttons on keyboards. I thought it may be as simple as determining the VK Keyboard constant and adding it to each form's keyphysical method. However, these buttons are not addressed in the Paradox Help Files for Paradox 10. , , But I just found them today ....thought I'd put it out there for others, so that it will help you too., , VK_LWIN ; Left Windows Button, VK_RWIN ; Right Windows Button , , I just wanted to help in a small way. My way of saying a litle "thank you" to all of you who have greatly helped me over the years. , , Thanks,, , ABP

Hi there,, , I was working on a report, closed Paradox and next time when I wanted to start Paradox following error message popped up:, , "An attempt was made to access an unnamed file past its end"., , I tried the 'help file' but wasn't able to access it but the same message keeps coming up. I then reinstalled Paradox and still get the same error message., , Please help!, Very frustrated,, Margoma

I'm using a Corel Webserver control to capture data from a web page.  Works great.  After the posting, I want to send an email to a staff member that the data has been posted. I have the following code:m.logon("","" ), , ,     m.addAddress("products@consoftonline.com"), ,     m.setSubject("A Patient from the Portal"),     m.setMessage("Please check Patient: " + theName + " " + theAppointmentDate),     ,     m.send()  The problem is that the Logondlg box appears each time .  It's supposed to send the message automatically.  What am I missing?

I cut and paste images into an image field on a Paradox form and I've been doing this with no problems for years; yesterday I got a message saying 'Unknown internal operating system error' with a reference to the .MB file, when I tried to paste an image in. Paradox hung. After restarting, I verified and rebuilt the table and it imported the image ok but when I tried to do it with a new record the same thing happened.I'm using Paradox 10.0.0.663 running on a Lenovo laptop with Vista Home Premium and Service Pack 2. The database has 121,900 records in it but not all of them have images.Does anyone know what might be causing this? Any help would be appreciated, thanks.,

Currently using Paradox 11.0.0.663 - Have an existing input form and have experienced a change this week for one user in the way the cursor is positioned when pressing F2 edit.  For all other users when F2 is pressed the cursor positions itself at the beginning of the field.  For this user upon pressing F2 the cursor is positioned at the end of the field.  I have been unable to find a solution to return the cursor to it's normal position (at beginning of field) upon edit.  I am sure it was a sequence of key strokes hit.  Closing out Paradox does not return cursor to correct position.

Mike, Re your "Implementing a Reusable Progress Bar in Paradox" form for download. I have downloaded it but am unable to open it. Paradox suggests that the form may be corrupt. Can you check please.

I have been working on a query by form for a long time and have it working, sort of. It's too long (but I can't find an alternative for my use, and I don't think that's the issue)It works well enough with a few issues ONCE.running it a second time brings up the error  - An error was triggered in the execute qbe method on an object of query type, which generally  indicates missing or double pipe in the query script, but it has not changed. I am thinking the query is still open? Is there a way to assure it is closed at the beginning of the script.Here is the entire script. I don't want to upload it to take up too much space.http://www.chefsprofessional.com/cpbworks.txt,

I am working on a program for a company I used to work for.  They had a delivered form that would take a weight and divide it by the number of containers in the stack.  From there it would print the number of tags that were in the stack and record all the information in the tables.  I have had to make changes to this form but don't have the original fsl used to create it so I am having to start from scratch and can't quite figure out how to get Paradox to repeat a command a varied number of times.  The number will be varied based on what the operator inputs when he is weighing product.  Any help would be great! Thanks, Joe Roark

I am an old Paradox developer working on an old client's application in Paradox 9. I haven't touched it for a while, and I can't figure out how to do something quite basic. I am trying to link two tables in a data model to be used in a form. I can add the two tables to the data model, but I can't create a link between them on common fields. Table A has a two-field Primary Key, and Table B has a secondary index on those two fields. How do I create the link between the two tables?

I have been using Pdox 9 on Windows XP pro.  I have attached many data models to a form and then the form started freezing up PDOX 9.  I uninstalled all Corel products and suites and re-installed Word Perfect 2000 suite.  I still can not get any data model to attach.  I press the radio button for multiple tables and then nothing happens except an error stating Pdox not responding.  Any Ideas as to what next.  I have re-loaded several times and each time I use the uninstaller I reboot with no success.