Re: [Harbour] SF.net SVN: harbour-project:[14091] trunk/harbour

Viktor Szakáts Sun, 07 Mar 2010 09:27:11 -0800

Yes, I'm not SQL expert, but maybe there exist a 
date notation which follows the ANSI standard, 
instead of national ones, sine the latter will 
inevitably not work in all setups.


In Harbour this "DTOS" notation is: YYYYMMDD

Brgds,
Viktor

On 2010 Mar 7, at 18:15, Bruno Luciani wrote:

> This is the error when sample fails 
> 
> It's say  that date it is out of range and may be a diferent datestyle  
> configuration its needed
> 
> Bruno
> 
> -------------------------------------------
> 
> 
> description  M          10           0
> Inserting, declared transaction control
> ERROR:  22008: el valor de hora/fecha est├í fuera de rango: ┬½12-22-2003┬╗
> LINE 1: ...         1, 2, 'TEST', 'y', 5, 3000, 1500.2, 7.5, '12-22-200...
>                                                              ^
> HINT:  Quiz├ís necesite una configuraci├│n diferente de ┬½datestyle┬╗.
> LOCATION:  DateTimeParseError, datetime.c:3525
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> ERROR:  25P02: transacci├│n abortada, las ├│rdenes ser├ín ignoradas hasta el 
> fin de bloque de transacci├│n
> LOCATION:  exec_simple_query, postgres.c:892
> 
> 
> 2010/3/7 <vszak...@users.sourceforge.net>
> Revision: 14091
>          
> http://harbour-project.svn.sourceforge.net/harbour-project/?rev=14091&view=rev
> Author:   vszakats
> Date:     2010-03-07 16:23:53 +0000 (Sun, 07 Mar 2010)
> 
> Log Message:
> -----------
> 2010-03-07 17:22 UTC+0100 Viktor Szakats (harbour.01 syenar.hu)
>  * contrib/hbpgsql/tests/simple.prg
>    ! Fixed date in SQL command to work regardless of mm/dd
>      positions in date.
>      I wonder what is the proper solution which uses a fully
>      portable date format. Anyone?
> 
> Modified Paths:
> --------------
>    trunk/harbour/ChangeLog
>    trunk/harbour/contrib/hbpgsql/tests/simple.prg
> 
> 
> This was sent by the SourceForge.net collaborative development platform, the 
> world's largest Open Source development site.
> _______________________________________________
> Harbour mailing list (attachment size limit: 40KB)
> Harbour@harbour-project.org
> http://lists.harbour-project.org/mailman/listinfo/harbour
> 
> _______________________________________________
> Harbour mailing list (attachment size limit: 40KB)
> Harbour@harbour-project.org
> http://lists.harbour-project.org/mailman/listinfo/harbour

_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour

Re: [Harbour] SF.net SVN: harbour-project:[14091] trunk/harbour

Reply via email to