pxlib-devel Mailing List for Library to read and write Paradox files
Brought to you by:
steinm
You can subscribe to this list here.
2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
(5) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2006 |
Jan
(1) |
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(5) |
Dec
|
2007 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(5) |
Dec
|
2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
2011 |
Jan
|
Feb
|
Mar
(1) |
Apr
(2) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2012 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
(1) |
Nov
(1) |
Dec
|
2013 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
2016 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Nicholas D. <Nic...@ls...> - 2022-06-14 08:18:39
|
Dear pxlib developers, Thanks for making this library, I have found it helpful in trying to access some files for a research project. The large block of example code from the overview in the documentation showing how to read fields sequentially from a database file was helpful, but it has a bug in it. The lines offset += pxf->px_flen; pxf++; near the end of the code snippet should be moved before the closing brace that immediately precedes those two lines, otherwise instead of reading a database as e.g. A B C D E F G H I , the field pointer does not get advanced within each record, and the code will instead read A A A D D D G G G . Thanks Nick |
From: Tim L. <tim...@ho...> - 2016-08-21 16:44:02
|
Hi, I have problems with importing some data from a paradox database. The code that I wrote is copying paradox datasets into a sqlite database. https://github.com/self-soft/myfindex/tree/develop/PdxConvert First, all seemed ok. But some datasets are missing some field data (strings). They are just empty. When I open the database with some old windows tools, I see that the database is ok and the data is just there. I use the TParadox component for Lazarus, which in turn uses pxlib. But the problem also exists when using pxview, which I compiled for debian, and uses pxlib 0.65. Also, the problem persists, when compiling my Lazarus code under Windows. So, my conclusion is that there is a bug in pxlib, and it has nothing to do with the TParadox component. The database can be downloaded here: https://dl.dropboxusercontent.com/u/24709393/files.DB.tar.gz The missing data is in the "FileName" Column, don't know, if there is more missing data atm. Is this a known problem with pxlib? Thank you. |
From: Fred G. <ga...@0x...> - 2016-03-12 21:03:04
|
Hi Thanks for keeping the pxlib and pxview software available. This has saved me loads of time (and my client money) in extracting a small database to make available for reuse. The download links pxlib and pxview links to sorcefore might need review as they seem to be bit mixed up one going to the other. Did not manage to get working on a Mac ( no Surprise ) but soon had up and running on Ubuntu 14.0.4 LTS. Did need to add -lm to get past the missing library error configure:23107: error: libpx not found. You will need at least libpx 0.4.4 as recommended by https://sourceforge.net/p/pxlib/bugs/12/. Cheer and thanks once again. Gannett |
From: Jaakko S. <jaa...@gm...> - 2013-10-23 13:12:43
|
Hello! I've come across with some esoteric paradox files I'd like to convert to a more readable form (CSV would be fine for now). I am trying to compile pxlib from the 0.6.5 source, but end up with a couple of compiling errors (./configure seems to work just fine). My OS is Mac OSX 10.8.5. As it's been quite awhile since I last coded in C, I can't get the error fixed. Any ideas? Here's what I get: make all-recursive Making all in include make[2]: Nothing to be done for `all'. Making all in src if /bin/sh ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./include -DPACKAGE_LOCALE_DIR=\""/usr/local/share/locale"\" -g -O2 -MT paradox.lo -MD -MP -MF ".deps/paradox.Tpo" -c -o paradox.lo paradox.c; \ then mv -f ".deps/paradox.Tpo" ".deps/paradox.Plo"; else rm -f ".deps/paradox.Tpo"; exit 1; fi libtool: compile: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./include -DPACKAGE_LOCALE_DIR=\"/usr/local/share/locale\" -g -O2 -MT paradox.lo -MD -MP -MF .deps/paradox.Tpo -c paradox.c -fno-common -DPIC -o .libs/paradox.o paradox.c:2498:79: warning: format specifies type 'unsigned int' but the argument has type 'long' [-Wformat] ...from 0x%X (block %d) to 0x%X (block %d)\n", recordpos, j, recordoutpos,... ~~ ^~~~~~~~~ %lX paradox.c:2498:93: warning: format specifies type 'unsigned int' but the argument has type 'long' [-Wformat] ...(block %d) to 0x%X (block %d)\n", recordpos, j, recordoutpos, jout); ~~ ^~~~~~~~~~~~ %lX paradox.c:2897:71: warning: comparison of unsigned expression < 0 is always false [-Wtautological-compare] ...if(pxblob->read(pxblob, pxs, sizeof(TMbBlockHeader3), &mbblockhead) < 0... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ^ ~ paradox.c:2913:74: warning: comparison of unsigned expression < 0 is always false [-Wtautological-compare] ...if(pxblob->read(pxblob, pxs, sizeof(TMbBlockHeader3Table), &mbbhtab) < 0... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ^ ~ paradox.c:3622:7: warning: implicit declaration of function 'localeconv' is invalid in C99 [-Wimplicit-function-declaration] lc = localeconv(); ^ paradox.c:3622:5: warning: incompatible integer to pointer conversion assigning to 'struct lconv *' from 'int' [-Wint-conversion] lc = localeconv(); ^ ~~~~~~~~~~~~ paradox.c:3624:19: error: incomplete definition of type 'struct lconv' buffer[j++] = lc->decimal_point[0]; ~~^ paradox.c:3583:9: note: forward declaration of 'struct lconv' struct lconv *lc; ^ paradox.c:4000:6: warning: incompatible integer to pointer conversion assigning to 'struct lconv *' from 'int' [-Wint-conversion] lc = localeconv(); ^ ~~~~~~~~~~~~ paradox.c:4002:28: error: incomplete definition of type 'struct lconv' dpptr = strchr(value, lc->decimal_point[0]); ~~^ paradox.c:3985:9: note: forward declaration of 'struct lconv' struct lconv *lc; ^ paradox.c:4162:88: warning: comparison of unsigned expression < 0 is always false [-Wtautological-compare] ...pxblob->read(pxblob, pxblob->mb_stream, sizeof(TMbBlockHeader3Table), &mbbhtab) < 0... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ^ ~ 8 warnings and 2 errors generated. make[2]: *** [paradox.lo] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 BR, J -- o Jaakko Särelä, PhD o jaa...@ik... <jaa...@ik...> o +358 44 358 9451 o http://fi.linkedin.com/in/jaakkosarela<http://fi.linkedin.com/in/jaakkosarela> |
From: Kenneth P. <sh...@se...> - 2013-01-25 19:41:17
|
--On Thursday, November 08, 2012 9:59 AM +0000 Edwin Langley <ed...@bs...> wrote: > We have a project in which our customer requires an application which can > open their legacy Paradox DB files. They may be happy enough if the > application has a GPL license. If not, can you tell me how much it would > cost to acquire a non-GPL license to use the library? The application is > rather niche and would be used by a small number (Say, 100 or so?) of > direct consumers of our customers equipment. My approach is to copy the raw DB files (rsync via cron) and use the pxlib utilities and a Perl script to fix up the result to import them into MySQL. All new code (written as a LAMP app) accesses the MySQL tables. At present the new code is query-only so I don't need to push anything back into the Paradox tables. If I needed that, I'd probably set up the Paradox web server to accept the data via HTTP from the LAMP app. |
From: Edwin L. <ed...@bs...> - 2012-11-08 09:59:57
|
Hello We have a project in which our customer requires an application which can open their legacy Paradox DB files. They may be happy enough if the application has a GPL license. If not, can you tell me how much it would cost to acquire a non-GPL license to use the library? The application is rather niche and would be used by a small number (Say, 100 or so?) of direct consumers of our customers equipment. Thank you Ed |
From: Ben T. <ben...@bs...> - 2012-10-09 12:48:32
|
Hi, Is there a LGPL version of pxlib available? Thanks, Ben -- Ben Tucker | Senior Software Engineer D: +44 1225.710660 | M: +44 1225.710600 MPC Data, Ltd. | A Bsquare Company www.mpcdata.com | www.bsquare.com |
From: CZIRKOS Z. <cz...@ee...> - 2012-09-09 09:05:38
|
Hi The pxlib documentation at http://pxlib.sourceforge.net/documentation.php?manpage=pxlib has the following example code for reading the fields: ... case pxfBytes: // .. break; default: break; } } offset += pxf->px_flen; pxf++; } else { fprintf(stderr, _("Couldn't get record number %d\n"), j); } ... however, the } above the offset += line is the } of the for () of the fields, and not the switch (). so the example code should read: case pxfBytes: // .. break; default: break; } // switch (field type) offset += pxf->px_flen; pxf++; } // for (fields) } else { fprintf(stderr, _("Couldn't get record number %d\n"), j); } Thanks for the library, and also for pxview! CZ. |
From: Petr G. <gr...@gr...> - 2012-07-23 16:36:43
|
Hi, First I would like to thank you for pxlib. Second, I think I found a bug. If I try to delete records like this: for(int i = 0; i<recordsCount; i++) { PX_delete_record(table, i); } I get these messages: If I close the file and then open it again: Number of records counted in blocks does not match number of records in header (149 != 0) If I immidiately try to insert new record: PXLib: Number of records of block stored in index (0) is unequal to number of records stored in block header (149). PXLib: Error while searching for free slot of new record. Am I doing something wrong? Thank you. |
From: Slash <sl...@ms...> - 2012-01-26 16:15:15
|
Hi, everyone, A quick question, the PX_retrieve_record(3) returns an array of pointers to struct px_val. 1. How long will the contents pointed to by pointers last ?! 2. Do I need to free them ?! Thanks. Slash |
From: Mihai T. L. <mt...@gm...> - 2011-05-18 08:42:43
|
Hi, I attach a couple of patches against pxlib-0.6.3 needed to fix the tests of the paradox-1.4.3 PHP package: http://pecl.php.net/package/Paradox/1.4.3 They fix a spurious fprintf(stderr, ...) and an overflow in timestamp2string(). I hope this is useful. Let me know if there are problems. Mihai |
From: Robert C. <no...@gm...> - 2011-04-17 19:56:49
|
Thanks for your help and sorry it took so long to get around to testing this. This seems to do the job: $ diff config.h.old config.h 74c74 < #define HAVE_LC_MESSAGES 1 --- > /* #define HAVE_LC_MESSAGES 1 */ 86c86 < #define HAVE_LOCALE_H 1 --- > /* #define HAVE_LOCALE_H 1 */ Outside this mailing list's scope, but however useful, using pecl's package manager to install the PHP Paradox binding also fails. Solution is to download the source from pecl.php.net, phpize, then edit the configure script. $ diff configure.old configure 4404c4404 < SEARCH_PATH="/usr/local /usr" # you might want to change this --- > SEARCH_PATH="/usr/local /usr /opt/local" # you might want to change this That's having used 'configure --prefix=/opt/local' for pxlib. >From initial tests, everything seems to work, but I'm curious to know what exactly the locale header provides for pxlib specifically? Is it just error messages/confirmations in the database manager's language or does it provide some conversion for the database content itself (like regional thousand separators, etc)? And how much do you think pxlib will break without it? Thank you so much for your tips again. Rob On 13 April 2011 15:53, Kenneth Porter <sh...@se...> wrote: > On Thursday, March 31, 2011 10:02 PM +0100 Robert Cambridge > <no...@gm...> wrote: > >> I have no idea what "dereferencing pointer to incomplete type" means, so >> even if you could just spare some time to point me in the right direction >> that would be amazing :) > > It means struct lconv (from locale.h) isn't defined, just forward-declared. > locale.h isn't getting included by your build system. > > The rest of the warnings mean that int, long int, and pointers are all > different sizes. What are the sizes of those on your system? > > The first warnings about printf are legitimate bugs: The %X should be > changed to %lX. > > > |
From: Kenneth P. <sh...@se...> - 2011-04-13 15:07:50
|
On Thursday, March 31, 2011 10:02 PM +0100 Robert Cambridge <no...@gm...> wrote: > I have no idea what "dereferencing pointer to incomplete type" means, so > even if you could just spare some time to point me in the right direction > that would be amazing :) It means struct lconv (from locale.h) isn't defined, just forward-declared. locale.h isn't getting included by your build system. The rest of the warnings mean that int, long int, and pointers are all different sizes. What are the sizes of those on your system? The first warnings about printf are legitimate bugs: The %X should be changed to %lX. |
From: Robert C. <no...@gm...> - 2011-03-31 21:03:08
|
Hi all I'm having trouble compiling pxlib-0.6.3 on Mac OS X Snow Leopard :( any help would be much appreciated! $ make make all-recursive Making all in include make[2]: Nothing to be done for `all'. Making all in src if /bin/sh ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./include -DPACKAGE_LOCALE_DIR=\""/opt/local/share/locale"\" -g -O2 -MT paradox.lo -MD -MP -MF ".deps/paradox.Tpo" -c -o paradox.lo paradox.c; \ then mv -f ".deps/paradox.Tpo" ".deps/paradox.Plo"; else rm -f ".deps/paradox.Tpo"; exit 1; fi mkdir .libs gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./include -DPACKAGE_LOCALE_DIR=\"/opt/local/share/locale\" -g -O2 -MT paradox.lo -MD -MP -MF .deps/paradox.Tpo -c paradox.c -fno-common -DPIC -o .libs/paradox.o paradox.c: In function 'PX_pack': paradox.c:2497: warning: format '%X' expects type 'unsigned int', but argument 3 has type 'long int' paradox.c:2497: warning: format '%X' expects type 'unsigned int', but argument 5 has type 'long int' paradox.c: In function 'PX_delete': paradox.c:2582: warning: cast from pointer to integer of different size paradox.c:2584: warning: cast from pointer to integer of different size paradox.c: In function 'PX_get_data_bcd': paradox.c:3621: warning: assignment makes pointer from integer without a cast paradox.c:3623: error: dereferencing pointer to incomplete type paradox.c: In function 'PX_put_data_bcd': paradox.c:3999: warning: assignment makes pointer from integer without a cast paradox.c:4001: error: dereferencing pointer to incomplete type make[2]: *** [paradox.lo] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 $ ./libtool --version ltmain.sh (GNU libtool) 1.5.24 Debian 1.5.24-1 (1.1220.2.456 2007/06/24 02:25:32) Copyright (C) 2007 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. $ ./libtool.bak --version ltmain.sh (GNU libtool) 1.5.24 Debian 1.5.24-1 (1.1220.2.456 2007/06/24 02:25:32) Copyright (C) 2007 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. $ libtool -V Apple Computer, Inc. version cctools-773 I have no idea what "dereferencing pointer to incomplete type" means, so even if you could just spare some time to point me in the right direction that would be amazing :) Thanks Robert Cambridge |
From: James P. <jam...@go...> - 2010-08-12 12:13:24
|
hi, i'm not sure where to send this, or if anyone even cares, but I tried to install pxview_0.2.5-1_i386.deb on Ubuntu 10.04, and the install failed saying it needed libgsf-1 >= 1.11.1 I fiddled about and fixed the deb so it now works. I've attached the working deb. Since Ubuntu 10.04 has libgsf-1-114 installed I figured it was just a naming thing that was breaking the dependancy, so i pulled the deb apart, and altered the control file to require libgsf-1-114 (>=1.14.16-1ubuntu1) and installed it. The dependancies were met fine, but pxview would not run because it was looking for /usr/lib/libgsf-1.so.1 when libgsf-1-114 had the file named /usr/lib/libgsf-1.so.114.0.16, so i created a link to this file in the postinst file, and removed the link in the prerm file. The rebuilt deb file installs and uninstalls fine on Ubuntu 10.04, and i tested it on a paradox db file and it retrieved the data to csv and html fine. I'm not sure why but whenever I try to use the --use-gsf switch, i get the following error: Inputfile: clerk.DB PXLib: Could not read header from paradox file. PXLib: Unable to get header. I have attached the data file i was using in case this sheds some light. Although the same thing happened with other data files. The version of pxlib in the Ubuntu 10.04 repos is pxlib 0.6.4-1. I don't know what difference the --use-gsf switch makes to the end result, but as it stands, the package installs and you can read paradox files out, so hopefully it'll be of some use to someone. thanks, james |
From: Kenneth P. <sh...@se...> - 2010-06-04 20:24:01
|
--On Thursday, June 03, 2010 9:20 PM -0500 Edward Danley <Edw...@da...> wrote: > paradox.c: In function 'PX_pack': > paradox.c:2497: warning: format '%X' expects type 'unsigned int', but > argument 3 has type 'long int' > paradox.c:2497: warning: format '%X' expects type 'unsigned int', but > argument 5 has type 'long int' > paradox.c: In function 'PX_delete': > paradox.c:2582: warning: cast from pointer to integer of different size > paradox.c:2584: warning: cast from pointer to integer of different size > paradox.c: In function 'PX_get_data_bcd': > paradox.c:3621: warning: assignment makes pointer from integer without a > cast > paradox.c:3623: error: dereferencing pointer to incomplete type > paradox.c: In function 'PX_put_data_bcd': > paradox.c:3999: warning: assignment makes pointer from integer without a > cast > paradox.c:4001: error: dereferencing pointer to incomplete type Is that a 64-bit system? I've only used it on 32 bit Linux and it's built fine. The errors all seem to be mismatches in word sizes, and may require some casts, especially in the printf stuff. |
From: Edward D. <Edw...@da...> - 2010-06-04 01:20:41
|
I don't know if anybody is still active with this project or not. I'm trying to compile pxlib on Mac OS X 10.6.3. The ./configure goes well but I get the following on the make. Any suggestions would be appreciated. Ed Danley $make make all-recursive Making all in include make[2]: Nothing to be done for `all'. Making all in src if /bin/sh ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./include -DPACKAGE_LOCALE_DIR=\""/usr/local/share/locale"\" -g -O2 -MT paradox.lo -MD -MP -MF ".deps/paradox.Tpo" -c -o paradox.lo paradox.c; \ then mv -f ".deps/paradox.Tpo" ".deps/paradox.Plo"; else rm -f ".deps/paradox.Tpo"; exit 1; fi gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./include -DPACKAGE_LOCALE_DIR=\"/usr/local/share/locale\" -g -O2 -MT paradox.lo -MD -MP -MF .deps/paradox.Tpo -c paradox.c -fno-common -DPIC -o .libs/paradox.o paradox.c: In function 'PX_pack': paradox.c:2497: warning: format '%X' expects type 'unsigned int', but argument 3 has type 'long int' paradox.c:2497: warning: format '%X' expects type 'unsigned int', but argument 5 has type 'long int' paradox.c: In function 'PX_delete': paradox.c:2582: warning: cast from pointer to integer of different size paradox.c:2584: warning: cast from pointer to integer of different size paradox.c: In function 'PX_get_data_bcd': paradox.c:3621: warning: assignment makes pointer from integer without a cast paradox.c:3623: error: dereferencing pointer to incomplete type paradox.c: In function 'PX_put_data_bcd': paradox.c:3999: warning: assignment makes pointer from integer without a cast paradox.c:4001: error: dereferencing pointer to incomplete type make[2]: *** [paradox.lo] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 |
From: Rob T. (V. Software) <ro...@ve...> - 2010-03-22 14:57:50
|
Hi All, I hope you are able to help me here: I am trying to open a DB and I get Access Denied upon PX_open_file. I am able to open another DB file fine. My question is how do I either bypass (what I am assuming is) the security on the DB or how do I specify the permissions to open the DB? Thanks Rob |
From: Rob T. (V. Software) <ro...@ve...> - 2010-03-22 14:33:26
|
Sorry All, of course a few mins later I figured out it was simply file permission problems! On Mon, Mar 22, 2010 at 9:49 AM, Rob Thompson (Vero Software) < ro...@ve...> wrote: > Hi All, > > I hope you are able to help me here: I am trying to open a DB and I get > Access Denied upon PX_open_file. I am able to open another DB file fine. > > My question is how do I either bypass (what I am assuming is) the security > on the DB or how do I specify the permissions to open the DB? > > Thanks > Rob > |
From: Jill E. <jil...@gm...> - 2009-07-05 16:02:53
|
Hello, I installed XAMPP 1.7.1 on Windows XP (ugh, but not my choice), and it works. I am very thankful it comes with pxlib.dll and also php_paradox.dll (version 5.2.4.4). ------------------- PHPINFO PHP Version 5.2.9 paradox Paradox support enabled pxlib Version 0.6.3 support for recoding record data iconv pxlib was build on no value Revision $Revision: 1.37 $ -------------------- I must read and convert paradox timestamps. I read this: http://pxlib.sourceforge.net/documentation.php?manpage=PX_timestamp2string but am unable to make it work correctly. I followed the examples included with XAMPP for the Paradox module. The examples which use "$pxdoc = px_new();" (not Object oriented) work well. But examples "$pxdoc = new paradox_db();" do not. Error: "Fatal error: Call to undefined method paradox_db::retrieve_record()" I also tried px_retrieve_record(): "Fatal error: Call to undefined function px_retrieve_record()" I read the PHP manual here: http://us2.php.net/manual/en/book.paradox.php and also the manual on pxlib on sourceforge. I see that there is a newer version of pxlib 0.6.4 which mentions it fixes a problem with px_timestamp2string? If I had pxlib.dll version 0.6.4 would that fix my problem? I very much appreciate your help! |
From: Lourenço <lou...@gm...> - 2009-03-05 19:30:28
|
-- Lourenço |
From: PLAT D. <Did...@en...> - 2008-08-19 11:57:28
|
First, many thanks for the very useful library! I have a little problem with PX_retrieve_record. NULL value for fields of type "Number" are badly read. In fact, two lines are missing in paradox.c, between lines 2007 and 2008: line 2007 : dataptr[i]->value.dval = value; } else { dataptr[i]->isnull = 1; line 2008 : } -- Didier PLAT Laboratoire d'Economie des Transports (CNRS -ENTPE -Université Lumière) ENTPE-rue Maurice AUDIN-69518 VAULX-EN-VELIN CEDEX-FRANCE Fax +33 (0)4 72 04 70 92 Tel +33 (0)4 72 04 70 47 did...@en... http://www.entpe.fr/ http://www.let.fr/ |
From: Michael S. <MSt...@gm...> - 2008-08-15 18:30:43
|
This patch fixes a similar problem as the one found by Kenneth Porter last year. This time in the sqlite part. I've checked it for pxfDate. pxfTime seems to have a similar bug, so I corrected it as well, but I don't have a Paradox database at hand using this data field type. |
From: Kenneth P. <sh...@se...> - 2007-11-26 20:43:06
|
PostgreSQL isn't recognizing the generated "unique" constraint as being a primary key. The attached patch issues an explicit primary key constraint in addition to the existing unique constraint. |
From: Kenneth P. <sh...@se...> - 2007-11-26 19:26:03
|
A formatted memo field contains binary markup and shouldn't be exported as text. The attached patch exports the data to a blob file, as is done with graphic blobs. |