Search results for query: *

133tcamel, Thanks for the info. I was hoping it has a simple function like table_exists. Thanks Joe

I like to check if a MySQL database or table exists. I searched on-line and cpan.org. I can't seem to find the right command. Any ideas? Thanks Joe

Tony, Thanks for the info. Joe

Is it possible to enable or disable 'Disable Hyperlinks' option in objectPAL? Thanks

The fastest way to export the data as a text (*.CSV) file. Or you can use a free Paradox to Excel library http://members.fortunecity.com/menkin/defaultmain.htm I have used the library. It works fine, but if you have many rows, it could be very slow.

Thank you everyone for your suggestions. I am going give this another try.

Thanks for your reply. The issue is when dtDate is empty, the DataDate will end up with 12/30/1899. How can I assign a blank value to DataDate when dtDate is empty? Thanks

I have a SQL that inserts values into a Paradox table. The SQL executes without any problems if the date value is not empty. However, the SQL would not execute properly if the date value is empty. How can I get around this error? Thanks For example: sDataDate : String; sAcctNo : String...

Thanks Jan-Christian A very good point.

Ah! Simple indeed. Many thanks.

StrToFloat does not work with Thousand separators. Is there a easy way to convert, say, '40,000.00' to real type? Thanks

... However I would like to display on another tab a table that must be created from a query. ..... Save query results in a different table.

To do this nicely you will need to use the SDK either from Adobe or 3rd party vendors. Here is a quick and dirty way. However, you do need the FULL version of Acrobat, not the reader. How it works? The codes below mimic how you would create and save Pdox report in PDF format manually. Similar...

I have a DBEdit field bounded to a numeric field of a table. The field's DisplayFormat property is defined as #,###,##0.00. When I entered 12346.78, the number on the form would become 123,456.78. So far, so good. However, when I change the value from 123,456.78 to say 123,000.00, I get this...

Lance, Thanks for the info. Joe

I have a field for e-mail addresses on Pdox 9. Everytime I click on the field the e-mail program pops up as though I want to send an e-mail message. It's a pain. How can I turn it off? Thanks Joe

Without knowing what your data structure look like, or the data relations, I could only address this in general term. I would: Create secondary indexes. Minimize the # of fields to match or extract May be you could create an Id field for each record and do the initial match against the id...

Have you use Tutility to fix the table? If you think only the index is bad. I would delete the primary keys (*.px) and index files (*.X??, *.Y??) files. Re-create the keys and index. Oh, make sure you make a copy of your tables first!

Hi, BTecho I suspected it has to do with fieldDefs, just not sure the syntax. Thank you! Joe

Can I create a table by borrowing the table structure from another table? Thanks Joe