Daniel Fought Message Board Activity

In the first example you use  '01/18/2013' to compare to a date field.  In the second you use a string or memo variable FechaMaxS to compare to a date field.  Thus the type mismatch.  If you declare a date var FetchMaxD and assign date( "18/01/2013") you should not get the type mismatch

Posted to MB Topic: Paradox Forms « Paradox Board

Give this a try Check _Join1 , ~S  The only problem with this is that if S is blank you will get an error due to an extra , in the field criteria.  

Posted to MB Topic: Paradox Forms « Paradox Board

What is the purpose of doing this? 

Posted to MB Topic: ObjectPAL « Paradox Board

I believe you are talking about the MS Office clipboard that first appeared in Office 2007.  This is availabe to the MS Office programs and I would believe that it may be available through the office ole interface.  

Posted to MB Topic: ObjectPAL « Paradox Board

First thing you need to understand is that a tcursor does not automatically stay in sync with a form.  When you attach the tcursor to a form object the tcursor will initially be pointing at the same record as the object.  However if the tcursor or the form moves to another record, they will no longer be in sync, or pointing at the same record. To make this code work put the attach in the prefilter if (active.class = "Field") then FD1_tC.attach(FD1_uiO) n_lInt = FD1_tC.RecNo()

Posted to MB Topic: ObjectPAL « Paradox Board

That goes way back.  CR/LF  would be chr(13)+chr(10) often the \n works just fine.

Posted to MB Topic: ObjectPAL « Paradox Board

Need help,  designing simple paradox report .  In example.   2 fields field 1           Field 2  values 1                          0                           | 2                       2.4                           |   3                       1.8          ...

Posted to MB Topic: Paradox Reports « Paradox Board

Hi Paul You are going to need to convert the numerical data to a string and append spaces to the right side of the string using the fill function.  If you want to convert the numerical field values into positional values you will probably have to resort to opal.

Posted to MB Topic: Paradox Reports « Paradox Board

Hi can anyone help  I am trying to insert a few extra lines into an existing text file.  the text file looks a little like this: 1   %%3000, 2   X161715Y35802T1T0, 3   X161715Y31502G01G42F10, 4   X177715Y31502G01, 5   X177715Y35802G01, 6   X177715Y35802T0, 7   X177715Y39202T0, 8   X177715Y44502G01G42, 9   X161715Y44502G01, 10 X161715Y39202G01, 11 X161715Y39202T0, 12 XYM50, 13 $T1D320S20F7R100N16Z0.220, 14 $ i need to insert new lines between line 12 and 13 this finished result should look like this 1   %%3000, 2   X161715Y35802T1T0, 3   X161715Y31502G01G42F10, 4   X177715Y31502G01, 5   X177715Y35802G01, 6   X177715Y35802T0, 7   X177715Y39202T0, 8   X177715Y44502G01G42, 9   X161715Y44502G01, 10 X161715Y39202G01, 11 X161715Y39202T0, 12 XYM50 X114300Y3000T55M31, X342900Y3000, X454200Y190500, X454200Y419100, X-213599Y4999M50M30, $T55D320S20F7R100N16Z0.220, $" 13 $T1D320S20F7R100N16Z0...

Posted to MB Topic: ObjectPAL « Paradox Board

Before you writeline to the middle of a text stream you want to readline and append the line to the text you are adding.  Read the help file on writeline for more info.

Posted to MB Topic: ObjectPAL « Paradox Board

If you are this far all you almost have it .  what need to do is put your enumerate code a method that can be called passing in the directory path to be enumerated.   You will need to include a field in your database that indicates if the directory has been enumerated.  Then using a locate on that field being false you call the enumerate process until the locate does not find a directory in your table that has not been enumerated.  That should do it.

Posted to MB Topic: ObjectPAL « Paradox Board

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!!!

Posted to MB Topic: Paradox Forms « Paradox Board

The ValueChanged method does not occur until you depart from the field.  Try the mouseClick event.

Posted to MB Topic: Paradox Forms « Paradox Board

Have you tried reinstalling paradox 9?

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

Posted to MB Topic: Paradox Forms « Paradox Board

If Al's suggestion is not immediately available and if you are really desparate and what to view the code you can open the form using notepad or other text editor.  You cannot and must not make modifications to this file using the editor.  I would recommend using a disposable copy of the form for this.  If you search for the open() and init() methods you can look at the text code and possibly figure out what is missing from the application envirment and possible correct the problem.  By the way have you attempted to run the code in win98 compatability mode?

Posted to MB Topic: Paradox Forms « Paradox Board

Hello, I have PW 11 working in a network environment-6 work stations running Windows XP.  I just added another workstation running Window 7.  Using the same startup icon properties as in the other 6 "working" stations", I am able to run the start up script but get the error msg that I can't open the forms in design mode.  I've tried resetting the desktop PW's setting to not open forms/reports in design mode by default, but the settings seem to change back to default design mode everything I reopen PW.  Considering that everything is working ok in Windows XP, I'm thinking there's something different that PW is doing under Windows 7.  Has anyone come across this anomaly? Thanks for any help!

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

Sounds like you are having an issue with Pdoxregcl.  Check this link http://www.prestwood.com/aspsuite/kb/document_view.asp?qid=101574

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

In the status bar you should see an explaination of what compile error occured.  Probably something related to the object Enter_Unit not being visible since you are using the .value property I am assuming that this is an object on the form.  If the object is not within the visible containership tree you can't reference it directly.  Probably the object Enter_Unit is contained within a tableframe or other object not directly visible to the pushbutton.  You will probably will need to add to the containership path to address this field.  Look in the paradox help concerning containership and watch the status bar.

Posted to MB Topic: Paradox Forms « Paradox Board

Are you talking about data displaied in the table or data displaied in the form.  I created a table with a number field with the format set to general.  The field bound to this field was set to the same format.  I was able to enter 16 digit numbers and have them displaied in the form.  Check to see that the data in the table isnt defined as a longint.

Posted to MB Topic: Paradox Forms « Paradox Board

The uses clause must reference the .lsl.  That said. the .lsl only needs to be present until the file that is referencing the .lsl file has been complied.  The form will correctly run in both the undelivered and delivered form.  Note that the .ldl does still need to be present.

Posted to MB Topic: ObjectPAL « Paradox Board