Page 1 of 1
cValToStr() error *Fixed*
Posted: Wed Jun 18, 2014 2:17 am
by dutch
It has occur an error while TXBrwose need to convert TIMESTAMP field in MySql. I try TDolphin but some field is TIMESTAMP and got an error.
Code: Select all | Expand
Path and name: D:\FWH1305\download\TDolphin\download\testpag.exe (32 bits)
Size: 2,680,320 bytes
Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20130903)
FiveWin Version: FWHX 13.11
Windows version: 6.1, Build 7601 Service Pack 1
Time from start: 0 hours 0 mins 1 secs
Error occurred at: 06/18/14, 09:10:07
Error description: Error BASE/1118 Argument error: TTOC
Args:
[ 1] = C ...
Stack Calls
===========
Called from: => TTOC( 0 )
Called from: .\source\function\VALTOSTR.PRG => CVALTOSTR( 95 )
Thank you for any help and idea.
Re: cValToStr() error
Posted: Thu Jun 19, 2014 12:37 am
by nageswaragunupudi
Mr Dutch
Please help me with the results of :
? oQry:FieldType( <ntimestampfield> )
? ValType( oQry:FieldGet( <timestamefield> ) )
If both results are 'T' then please make this modification:
Locate method SetColFromMySQL(...) in xbrowse.prg.
Please change the line
as
If in the above test,
? ValType( oQry:FieldGet( <timestamefield> ) )
returns 'C' instead of 'T', please insert these two lines just before "OTHERWISE"
I shall be glad if you can respond early.
PS: Regret I am not able to test myself as my development PC is under maintenance.
Re: cValToStr() error
Posted: Thu Jun 19, 2014 6:51 am
by dutch
Dear Mr.Rao,
I've test the result ValType() of TimeStamp field as below
Code: Select all | Expand
cValType := valtype( oQry:FieldGet( 'rta_stamp' )) return "C"
cValType := oQry:FieldType( 'rta_stamp' ) return "T"
cValType := valtype( oQry:rta_stamp ) return "C"
It has no error when I modified TXBrowse as your mention below.
Thanks a lot Mr.Rao
nageswaragunupudi wrote:Mr Dutch
Please help me with the results of :
? oQry:FieldType( <ntimestampfield> )
? ValType( oQry:FieldGet( <timestamefield> ) )
If both results are 'T' then please make this modification:
Locate method SetColFromMySQL(...) in xbrowse.prg.
Please change the line
as
If in the above test,
? ValType( oQry:FieldGet( <timestamefield> ) )
returns 'C' instead of 'T', please insert these two lines just before "OTHERWISE"
I shall be glad if you can respond early.
PS: Regret I am not able to test myself as my development PC is under maintenance.
Re: cValToStr() error *Fixed*
Posted: Thu Jun 19, 2014 8:35 am
by Antonio Linares
Dutch,
Did you just applied this ?
CASE cType $ 'DT'
thanks,
(Going to include it in FWH 14.06)
Re: cValToStr() error *Fixed*
Posted: Thu Jun 19, 2014 9:21 am
by nageswaragunupudi
Antonio Linares wrote:Dutch,
Did you just applied this ?
CASE cType $ 'DT'
thanks,
(Going to include it in FWH 14.06)
No.
Test results of Mr Dutch indicate that though Dolphin returns fiedtype as 'T', it actually returns a character value not DateTime value. So if Dolphin says the fieldtype is 'T', we should consider it as 'C'.
So the fix must be:
Re: cValToStr() error *Fixed*
Posted: Thu Jun 19, 2014 9:23 am
by Antonio Linares
Rao,
Thanks for the clarification
