pxlib-devel Mailing List for Library to read and write Paradox files (Page 2)
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: Kenneth P. <sh...@se...> - 2007-11-26 16:50:26
|
Attached is a patch to pxview to quote timestamps for SQL. |
From: Kenneth P. <sh...@se...> - 2007-11-26 16:48:08
|
I'm running px2sql on CentOS 5 and finding that timestamps are getting rendered like this: 2001-10-09 -3:-14:-8 I suspect this is arising due to signed/unsigned issues with the "%" (modulo) operator. Additionally, this needs to be quoted because the date will otherwise be interpreted as a numeric expression by some SQL parsers (notably PostgreSQL's psql). I'll try to attach a patch for pxlib to address the sign issue. |
From: Paul D. <duf...@gm...> - 2007-11-20 07:39:41
|
I am sending you a patch to fix typos, grammatical rules in text strings. This was based on bug report by Malcolm Parsons in: https://bugs.launchpad.net/ubuntu/+source/pxlib/+bug/61025 |
From: Mark R. <mro...@fi...> - 2007-01-12 17:33:45
|
While trying to open a large archive database (76M) with pxlib 0.61 via the= =20 PECL bindings, I received the error=20 =A0=A0=A0=A0=A0=A0=A0=A0"Fatal error: px_open_fp(): Paradox file has unknow= n file type (164)." The file opens perfectly in Paradox 7 for Windows, Microsoft Access, and it= 's=20 sister files open fine using pxlib. =A0 Any help would be grand. Thanks,=20 Mark C. Roduner, Jr. CIO Fineline Industries |
From: Team C. <tea...@fi...> - 2007-01-11 20:34:03
|
While trying to open a large archive database (76M) with pxlib 0.61 via the PECL bindings, I received the error "Fatal error: px_open_fp(): Paradox file has unknown file type (164)." The file opens perfectly in Paradox 7 for Windows, Microsoft Access, and it's sister files open fine using pxlib. Any help would be grand. Thanks, Mark C. Roduner, Jr. CIO Fineline Industries |
From: Simon <si...@ta...> - 2007-01-04 11:44:52
|
Hi,=20 is there any documentation or solution to run PHP with pxlib? Simon |
From: <sf...@st...> - 2006-11-09 23:35:22
|
grr, attachment delete by the list. ./configure --prefix=/usr --sysconfdir=/etc --mandir=/usr/share/man --localstatedir=/var --with-recode=/usr --with-gsf=/usr checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for gawk... no checking for mawk... mawk checking whether make sets $(MAKE)... yes checking whether to enable maintainer-specific portions of Makefiles... no checking for perl... /usr/bin/perl checking for XML::Parser... ok checking for iconv... /usr/bin/iconv checking for msgfmt... msgfmt checking for msgmerge... msgmerge checking for xgettext... xgettext checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking for style of include used by make... GNU checking dependency style of gcc... gcc3 checking for a BSD-compatible install... /usr/bin/install -c checking how to run the C preprocessor... gcc -E checking for egrep... grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking locale.h usability... yes checking locale.h presence... yes checking for locale.h... yes checking for LC_MESSAGES... yes checking libintl.h usability... yes checking libintl.h presence... yes checking for libintl.h... yes checking for ngettext in libc... yes checking for dgettext in libc... yes checking for bind_textdomain_codeset... yes checking for msgfmt... no checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking for a sed that does not truncate output... /bin/sed checking for ld used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for /usr/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... gcc3 checking how to run the C++ preprocessor... g++ -E checking for g77... no checking for f77... no checking for xlf... no checking for frt... no checking for pgf77... no checking for fort77... no checking for fl32... no checking for af77... no checking for f90... no checking for xlf90... no checking for pgf90... no checking for epcf90... no checking for f95... no checking for fort... no checking for xlf95... no checking for ifc... no checking for efc... no checking for pgf95... no checking for lf95... no checking for gfortran... no checking whether we are using the GNU Fortran 77 compiler... no checking whether accepts -g... no checking the maximum length of command line arguments... 32768 checking command to parse /usr/bin/nm -B output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... /usr/bin/ld -m elf_x86_64 checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ static flag -static works... yes checking if g++ supports -c -o file.o... yes checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate appending configuration tag "F77" to libtool checking for an ANSI C-conforming const... yes checking whether byte ordering is bigendian... no checking whether struct tm is in sys/time.h or time.h... time.h checking for dirent.h that defines DIR... yes checking for library containing opendir... none required checking for ANSI C header files... (cached) yes checking fcntl.h usability... yes checking fcntl.h presence... yes checking for fcntl.h... yes checking for unistd.h... (cached) yes checking ctype.h usability... yes checking ctype.h presence... yes checking for ctype.h... yes checking dirent.h usability... yes checking dirent.h presence... yes checking for dirent.h... yes checking errno.h usability... yes checking errno.h presence... yes checking for errno.h... yes checking malloc.h usability... yes checking malloc.h presence... yes checking for malloc.h... yes checking stdarg.h usability... yes checking stdarg.h presence... yes checking for stdarg.h... yes checking for sys/stat.h... (cached) yes checking for sys/types.h... (cached) yes checking time.h usability... yes checking time.h presence... yes checking for time.h... yes checking ieeefp.h usability... no checking ieeefp.h presence... no checking for ieeefp.h... no checking nan.h usability... no checking nan.h presence... no checking for nan.h... no checking math.h usability... yes checking math.h presence... yes checking for math.h... yes checking fp_class.h usability... no checking fp_class.h presence... no checking for fp_class.h... no checking float.h usability... yes checking float.h presence... yes checking for float.h... yes checking for stdlib.h... (cached) yes checking sys/socket.h usability... yes checking sys/socket.h presence... yes checking for sys/socket.h... yes checking netinet/in.h usability... yes checking netinet/in.h presence... yes checking for netinet/in.h... yes checking arpa/inet.h usability... yes checking arpa/inet.h presence... yes checking for arpa/inet.h... yes checking netdb.h usability... yes checking netdb.h presence... yes checking for netdb.h... yes checking sys/time.h usability... yes checking sys/time.h presence... yes checking for sys/time.h... yes checking sys/select.h usability... yes checking sys/select.h presence... yes checking for sys/select.h... yes checking sys/mman.h usability... yes checking sys/mman.h presence... yes checking for sys/mman.h... yes checking for strftime... yes checking for strdup... yes checking for strndup... yes checking for strerror... yes checking for snprintf... yes checking for finite... yes checking for isnand... no checking for fp_class... no checking for class... no checking for fpclass... no checking for strftime... (cached) yes checking for localtime... yes checking for gethostent... yes checking for setsockopt... yes checking for connect... yes checking for type of socket length (socklen_t)... checking for ld used by GCC... /usr/bin/ld -m elf_x86_64 checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes checking for shared library run path origin... ./config.rpath: ./config.rpath: No such file or directory done checking for iconv... yes checking for recode... not needed, using iconv checking for gsf_input_read in -lgsf-1... yes checking for docbook-to-man... no docbook-to-man could not be found. I will not build man pages! configure: creating ./config.status config.status: creating Makefile config.status: creating pxlib.spec config.status: creating pxlib.pc config.status: creating include/Makefile config.status: creating src/Makefile config.status: creating po/Makefile.in config.status: creating doc/Makefile config.status: creating include/pxversion.h config.status: creating include/paradox.h config.status: creating include/paradox-gsf.h config.status: creating config.h config.status: config.h is unchanged config.status: executing intltool commands config.status: executing depfiles commands config.status: executing default-1 commands Configuration: Prefix: /usr Recoding: Using iconv for recoding. aixitintern:/usr/src/pxlib-0.6.1# make make all-recursive make[1]: Entering directory `/usr/src/pxlib-0.6.1' Making all in include make[2]: Entering directory `/usr/src/pxlib-0.6.1/include' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/usr/src/pxlib-0.6.1/include' Making all in src make[2]: Entering directory `/usr/src/pxlib-0.6.1/src' if /bin/sh ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./include -DPACKAGE_LOCALE_DIR=\""/usr/share/locale"\" -I/usr/include/libgsf-1 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include -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=\"/usr/share/locale\" -I/usr/include/libgsf-1 -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include -g -O2 -MT paradox.lo -MD -MP -MF .deps/paradox.Tpo -c paradox.c -fPIC -DPIC -o .libs/paradox.o paradox.c: In function `PX_delete': paradox.c:2570: warning: cast from pointer to integer of different size paradox.c:2572: warning: cast from pointer to integer of different size paradox.c: In function `PX_get_data_bcd': paradox.c:3608: warning: assignment makes pointer from integer without a cast paradox.c:3610: error: dereferencing pointer to incomplete type paradox.c: In function `PX_put_data_bcd': paradox.c:3984: warning: assignment makes pointer from integer without a cast paradox.c:3986: error: dereferencing pointer to incomplete type paradox.c:3986: error: dereferencing pointer to incomplete type paradox.c:3986: error: dereferencing pointer to incomplete type paradox.c:3986: error: dereferencing pointer to incomplete type make[2]: *** [paradox.lo] Error 1 make[2]: Leaving directory `/usr/src/pxlib-0.6.1/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/pxlib-0.6.1' make: *** [all] Error 2 Zitat von sf...@st...: > Hello List, > > i saw the attached compile error on two of my systems. > > The first system is SuSE Linux 9.2 (x86), the second one an amd64 with Debian > Sarge (3.1). > > Please provide a solution. If you need more informations, let me know. > > Thanks > > Carsten > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Pxlib-devel mailing list > Pxl...@li... > https://lists.sourceforge.net/lists/listinfo/pxlib-devel > ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ |
From: <sf...@st...> - 2006-11-09 23:30:50
|
forgot the file ;) Zitat von sf...@st...: > Hello List, > > i saw the attached compile error on two of my systems. > > The first system is SuSE Linux 9.2 (x86), the second one an amd64 with Debian > Sarge (3.1). > > Please provide a solution. If you need more informations, let me know. > > Thanks > > Carsten > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Pxlib-devel mailing list > Pxl...@li... > https://lists.sourceforge.net/lists/listinfo/pxlib-devel > ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ |
From: Stefan de K. <sk...@xs...> - 2006-11-09 23:30:11
|
On Fri, 10 Nov 2006 sf...@st... wrote: > i saw the attached compile error on two of my systems. > > The first system is SuSE Linux 9.2 (x86), the second one an amd64 with Debian > Sarge (3.1). > > Please provide a solution. If you need more informations, let me know. Hi, there is almost zero traffic on this list. So I don't know if you can find your answer here. Stefan |
From: <sf...@st...> - 2006-11-09 23:24:14
|
Hello List, i saw the attached compile error on two of my systems. The first system is SuSE Linux 9.2 (x86), the second one an amd64 with Debian Sarge (3.1). Please provide a solution. If you need more informations, let me know. Thanks Carsten ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ |
From: <sf...@st...> - 2006-11-09 23:16:34
|
Hello List, i saw the attached compile error on two of my systems. The first system is SuSE Linux 9.2 (x86), the second one an amd64 with Debian Sarge (3.1). Please provide a solution. If you need more informations, let me know. Thanks Carsten ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ |
From: Stefan de K. <sk...@xs...> - 2006-03-23 19:15:02
|
Hi, I tested 0.5.1 & 0.6.0 on AMD64, the latest version of pxlib seems to be=20 'more' compatible but still: l$yTbC]y=E4,-5072,21257,=F88IklF5/ x{UR#}.I?k=20 =E5`=C6~3J,o1FQg!y=F8inJ.7&L(LP6&oWYPr-j: 5_uZw_$X(ANq,1195696568,-206925907,-1499220558,-37570930,-1831090744,4490= 98795,-2030980732,1174416124,711505295,716169135,1814333494,314347085,-12= 82300623,-5601,-12079,1532909-08-02,-4396,,11481078,-1962998092,151574333= 7,754908834,442065620,2050678037,1058935580,-955970893,1563752764,-101760= 2794 BXualB#=C6,-31612,-4288,"a=3DZ~"HR.)}Ge H6HQhkP[6?8*tE` PXLib: Blob data is not contained in record and a blob file is not set. alot of fuss is comming thru. Trying it on an Athlon does work so I=20 guess this is broken by design. 20170,0,1,If you want me to stay,Sly & The Family=20 Stone,0,0,11870,159566,168057,168516,4620,0,0,0,173136,-6,5,0,0,1971-01-0= 1,1,,-1,,,,,,,,, This looks more like the expected output. (error and good output are=20 picked randomly) Yours Sincerely, Stefan de Konink |
From: Andreas S. <And...@gm...> - 2006-01-29 00:10:31
|
Hello, I tried to compile but when sgml-to-manual conversion begins, I get the following error message: parser error : StartTag: invalid element name <!doctype refentry PUBLIC "-//OASIS//DTD DocBook V4.1//EN" [ ^ I use gcc 4.0.2 and do have installed a docbook 4.1 package. yours, Andreas |
From: Matthew I. <mi...@pn...> - 2005-12-10 07:10:21
|
Nevermind. I don't know how I missed it before, but I just now found your tool (pxview) on the project site which dumps the database to SQL. Seems to work fine. Thanks for the excellent software. -matthew |
From: Matthew I. <mi...@pn...> - 2005-12-10 03:37:24
|
Hi, I recently installed the latest version of pxlib and the paradox PHP module which uses it. First, I'd like to say how nice it is to have a paradox reader which transparently ignores that Paradox "encryption." I tried all manner of Windows utilities and I just couldn't get it to work right from a command line. Nice work. Anyway, I have a PHP script which I will use to dump many megabytes of decrypted Paradox data into MySQL. Everything seems to work fine. I can read the schemas. I can get records, but for some reason I don't get all the fields from the records. In one table with 52 fields, the records only have 43 fields. That is, I get an array with only 43 elements. Most of the missing fields are of the PX_FIELD_DATE type. I do, however, get MEMOBLOBs. I thought that would be the tricky part. I'm not sure if this is a PHP thing or something do with wth the underlying library. Is there any reason why the records would be short like this? Also, are there other libraries/tools based on pxlib? I'd really rather not use PHP-cli for this. I may just take it upon myself to write a Ruby implementation just for fun. -matthew |
From: Stefan de K. <sk...@xs...> - 2005-12-08 21:01:21
|
On Thu, 8 Dec 2005, Kike computer wrote: > Im having trouble to get content of blobs, when i try to get blob froam a > record where the content of the blob is null im getting as value the last > blob content found. > > Can anyone help me ?? The only advice I can give you is try to patch the code yourself, I had some issues aswell. Stefan |
From: Kike c. <kik...@gm...> - 2005-12-08 20:24:28
|
Im having trouble to get content of blobs, when i try to get blob froam a record where the content of the blob is null im getting as value the last blob content found. Can anyone help me ?? Thx Henrique |
From: Kike c. <kik...@gm...> - 2005-12-08 19:52:08
|
Im having trouble to get content of blobs, when i try to get blob froam a record where the content of the blob is null im getting as value the last blob content found. Can anyone help me ?? Thx Henrique |
From: <liv...@rd...> - 2005-11-29 08:03:55
|
Hi, I'm trying to PX_open_file a table of about 70Mb but the function just hungs. I left it more than 10 minutes but nothing happens, it doesn't crash nor prints any messagess. Finally I killed the process. With smaller tables the program works just fine. Any ideas? Best regards, Liviu |
From: Stefan de K. <sk...@xs...> - 2005-11-27 03:01:38
|
Hello, I'm having some problems with pxfDate, which are probably stored wrong in sqlite. The date is stored as integer and exported by sqlite also as integer instead of full date. While toying around I found a bug when --datetime-format is used, which leads to a segmentation fault. pxwrite --datetime-format="Y/m/d H:i:s" -c -f crit1update CRIT1-update.DB Trying to get my work done now, because SQLite behaves bad again. Stefan |
From: Tero L. <ter...@au...> - 2005-07-27 09:26:31
|
Hi, First, I would like to thank the authors for this very useful library. Also, I made some additions to pxwrite-0.0.7: 1) pxwrite does not support pxfBytes-column type, 'B' represents now the type 2) numprimkeys - setting was not set even when creating index; fixed 3) file type was always pxfFileTypNonIndexDB whether creating index or not; now changes type to pxfFileTypIndexDB when creating indexed DB I attached a patch for main.c which includes listed changes. Are you planning to make support for creating secondary indexes? I would have use for that feature. What about VAL-files? They are related to referential integrity checking in some way. Best regards, Tero Laitinen |
From: Stefan de K. <sk...@xs...> - 2005-07-10 21:06:37
|
Yesterday I needed an application that badly understood Sql commands to a Paradox database. But due to my special demands, and some missing features in pxlib I needed to code some additional stuff. Attached is the pxfTimestamp.diff for pxwrite, which obviously crashes applications that are too stupid to understand zero'ed timestamps. As you may notice I allow dates that are converted to zero. 1) It could be legitime 2) The time may be legitime One thing pxwrite still lacks is to make primary(+unique) tables. Simple stuff like that I still must do with Borland Database Desktop. Anyway, this project saved me *a lot* of hand work :) Greetings, Stefan de Konink |