Recent content by JoeNg

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