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

Posted to MB Topic: QBE & SQL « Paradox Board

Hi!I'm already using the ReportOpenInfo variant of the open method to change the master table that is used on a report, as to permit the user to restrict on which records to run the report on (something like "print the address book of clients beginning with letter A").I was wondering if there is a way to replace a table in the report's data model with another one, since there are times when it would be nice to filter the child table in a 1 to Many relation; for example, if I want to print the list of invoices with the associated payments, but I need to see payments status as if we were two months ago: I cannot put this filter on invoices, since this would exclude, for example, invoices that have no payment in the requested range, and I should instead pre-filter the list of payments that would be used as a child table.dmRemoveTable/dmAddTable cannot be used for this purpose, as they make the UI object become disconnected from the fields; I would need something as dmReplaceTable (that do...

Posted to MB Topic: Paradox Reports « Paradox Board

No ideas? :)

Posted to MB Topic: Paradox Reports « Paradox Board

Sure I can! In fact, simply disconnecting the webcam from the usb port solved the problem, and reconnecting it made it reappear! By using shellExtView I managed to keep the webcam connected (and functional in programs such as Skype) but not listed in My computer, and that made Pdox work correctly even when the webcam is connected... Surely it's a strange thing, but not too much if you consider that the Table Lookup tab has a folder chooser field on it, and that field has a drop down box that get populated with what you have in your My computer folder... :)

Posted to MB Topic: Paradox Graphs & Charts « Paradox Board

Solved! It was a simple one, when I finally found it... :) Since i was using a database variable to open the connection and pass the password, and that variable was a local one, it was being destroyed as soon as the function ended, closing the connection at the same time, then, the first time I really used the alias in my other code, the login windows will get back on, correctly! So, the solution is simple: define the database variable you use to open the connection in a longer lived name space! :)

Posted to MB Topic: ObjectPAL « Paradox Board