New DataSet problem with TDBComboBox

[Ingo]

Ignacio,
TDBComboBox linked with the numeric DataField "FC1"
nStyle := csDROPDOWNLIST
nDataType := dtDefault
aItems := {"Herr","Frau"}
On Append-mode the Control Value with old DataSet was "N"
with new DataSet the Value type is "C"
When updating the DataSet now the errormessage is displayed in the debug
window:
"#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
'N', got type 'C' (Herr)"
Please help
Regards
Ingo

[Ingo]

Ignacio,
the DataSet-object named "oMP3" the numeric DataField named "FC1"
I found a workaround
WITH OBJECT ::oMP3
:AddNew()
:FC1(dsFIELD) := 1 //<= this is the workaround. :FC1(dsVAR) := 1 works
too
END WITH
In this way it works. But this is not the aspired solution.
Regards
Ingo
"Ingo" <info@mandantwin.com> schrieb im Newsbeitrag
news:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Ignacio,
>
> TDBComboBox linked with the numeric DataField "FC1"
>
> nStyle := csDROPDOWNLIST
> nDataType := dtDefault
> aItems := {"Herr","Frau"}
>
> On Append-mode the Control Value with old DataSet was "N"
> with new DataSet the Value type is "C"
>
> When updating the DataSet now the errormessage is displayed in the debug
> window:
> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
> 'N', got type 'C' (Herr)"
>
> Please help
>
> Regards
>
> Ingo

[Ingo]

Ignacio,
the DataSet-object named "oMP3" the numeric DataField named "FC1"
I found a workaround
WITH OBJECT ::oMP3
:AddNew()
:FC1(dsFIELD) := 1 //<= this is the workaround. :FC1(dsVAR) := 1 works
too
END WITH
In this way it works. But this is not the aspired solution.
Regards
Ingo
"Ingo" <info@mandantwin.com> schrieb im Newsbeitrag
news:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Ignacio,
>
> TDBComboBox linked with the numeric DataField "FC1"
>
> nStyle := csDROPDOWNLIST
> nDataType := dtDefault
> aItems := {"Herr","Frau"}
>
> On Append-mode the Control Value with old DataSet was "N"
> with new DataSet the Value type is "C"
>
> When updating the DataSet now the errormessage is displayed in the debug
> window:
> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
> 'N', got type 'C' (Herr)"
>
> Please help
>
> Regards
>
> Ingo

[ignacio]

Ingo,
With which kind of dataset fails? Can you send us a sample or tell us how to
reproduce it with any Xailer sample?
Could you try with TDBComboBox:nDataType = dtINDEX
Regards,
--
Ignacio Ortiz de Zúñiga
http://www.xailer.com
http:/xailer.info
"Ingo" <info@mandantwin.com> escribió en el mensaje de
noticias:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Ignacio,
>
> TDBComboBox linked with the numeric DataField "FC1"
>
> nStyle := csDROPDOWNLIST
> nDataType := dtDefault
> aItems := {"Herr","Frau"}
>
> On Append-mode the Control Value with old DataSet was "N"
> with new DataSet the Value type is "C"
>
> When updating the DataSet now the errormessage is displayed in the debug
> window:
> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
> 'N', got type 'C' (Herr)"
>
> Please help
>
> Regards
>
> Ingo

[ignacio]

Ingo,
With which kind of dataset fails? Can you send us a sample or tell us how to
reproduce it with any Xailer sample?
Could you try with TDBComboBox:nDataType = dtINDEX
Regards,
--
Ignacio Ortiz de Zúñiga
http://www.xailer.com
http:/xailer.info
"Ingo" <info@mandantwin.com> escribió en el mensaje de
noticias:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
> Ignacio,
>
> TDBComboBox linked with the numeric DataField "FC1"
>
> nStyle := csDROPDOWNLIST
> nDataType := dtDefault
> aItems := {"Herr","Frau"}
>
> On Append-mode the Control Value with old DataSet was "N"
> with new DataSet the Value type is "C"
>
> When updating the DataSet now the errormessage is displayed in the debug
> window:
> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
> 'N', got type 'C' (Herr)"
>
> Please help
>
> Regards
>
> Ingo

[Ingo]

Dear Ignacio,
> With which kind of dataset fails? Can you send us a sample or tell us how
> too reproduce it with any Xailer sample?
is attached. Click on "New" and change the Combo and click on "Save" then
you will see the error message in the debug window.
BTW I had to stop recompiling my large code with the new Xailer 2 because
there are too much incompatibilities like browses dont display the new
record added to a DataSet with scope settings. I spent till now too much
time for
searching workarounds and adapting my sourcecode.
Isn't it possible to make Xailer 2 interoperable?
> Could you try with TDBComboBox:nDataType = dtINDEX
Is the same.
Regards
Ingo
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> http://www.xailer.com
> http:/xailer.info
>
> "Ingo" <info@mandantwin.com> escribió en el mensaje de
> noticias:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> Ignacio,
>>
>> TDBComboBox linked with the numeric DataField "FC1"
>>
>> nStyle := csDROPDOWNLIST
>> nDataType := dtDefault
>> aItems := {"Herr","Frau"}
>>
>> On Append-mode the Control Value with old DataSet was "N"
>> with new DataSet the Value type is "C"
>>
>> When updating the DataSet now the errormessage is displayed in the debug
>> window:
>> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
>> 'N', got type 'C' (Herr)"
>>
>> Please help
>>
>> Regards
>>
>> Ingo
>
--

Attached files Test1.zip (7.7 KB)Â

[Ingo]

Dear Ignacio,
> With which kind of dataset fails? Can you send us a sample or tell us how
> too reproduce it with any Xailer sample?
is attached. Click on "New" and change the Combo and click on "Save" then
you will see the error message in the debug window.
BTW I had to stop recompiling my large code with the new Xailer 2 because
there are too much incompatibilities like browses dont display the new
record added to a DataSet with scope settings. I spent till now too much
time for
searching workarounds and adapting my sourcecode.
Isn't it possible to make Xailer 2 interoperable?
> Could you try with TDBComboBox:nDataType = dtINDEX
Is the same.
Regards
Ingo
>
> Regards,
>
> --
> Ignacio Ortiz de Zúñiga
> http://www.xailer.com
> http:/xailer.info
>
> "Ingo" <info@mandantwin.com> escribió en el mensaje de
> noticias:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>> Ignacio,
>>
>> TDBComboBox linked with the numeric DataField "FC1"
>>
>> nStyle := csDROPDOWNLIST
>> nDataType := dtDefault
>> aItems := {"Herr","Frau"}
>>
>> On Append-mode the Control Value with old DataSet was "N"
>> with new DataSet the Value type is "C"
>>
>> When updating the DataSet now the errormessage is displayed in the debug
>> window:
>> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
>> 'N', got type 'C' (Herr)"
>>
>> Please help
>>
>> Regards
>>
>> Ingo
>
--

Attached files Test1.zip (7.7 KB)Â

[ignacio]

Ingo,
> there are too much incompatibilities like browses dont display the new
> record added to a DataSet with scope settings. I spent till now too much
> time for
> searching workarounds and adapting my sourcecode.
Sorry for that, our intention is that the new version would be completely compatible with Xailer 1. We are doing our best on that but as we said on our blog a lot of changes have been done on datacontrols and surely problem will arise on some users, that is your case I am afraid. BTW, we highly appreciate your feedback and we apologize for the extra work on your side.
> Isn't it possible to make Xailer 2 interoperable?
That is absolutely our target.
About your problem, I believe we found the error. Please modify yourself the TDbfDataset:Open method with the following code on line 272 aprox.:
WITH OBJECT ::AddField( aStruct[ nFor, DBS_NAME ] )
:cDisplayName := :cName
:cDbfName := :cName
:cType := aStruct[ nFor, DBS_TYPE ]
:nLen := aStruct[ nFor, DBS_LEN ]
:nDec := aStruct[ nFor, DBS_DEC ]
:lAllowsNull := .F.
:lEditable := .T.
:DefValue := XA_GetDefValue( :cType )
END WITH
(Text in red is the new code)
Our wait until next release that I hope it will be released shortly.
Again, sorry for any inconvenience.
Regards,
--
Ignacio Ortiz de Zúñiga
http://www.xailer.com
http:/xailer.info
> Isn't it possible to make Xailer 2 interoperable?
>
>> Could you try with TDBComboBox:nDataType = dtINDEX
>
> Is the same.
>
>
> Regards
> Ingo
>>
>> Regards,
>>
>> --
>> Ignacio Ortiz de Zúñiga
>> http://www.xailer.com
>> http:/xailer.info
>>
>> "Ingo" <info@mandantwin.com> escribió en el mensaje de
>> noticias:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>> Ignacio,
>>>
>>> TDBComboBox linked with the numeric DataField "FC1"
>>>
>>> nStyle := csDROPDOWNLIST
>>> nDataType := dtDefault
>>> aItems := {"Herr","Frau"}
>>>
>>> On Append-mode the Control Value with old DataSet was "N"
>>> with new DataSet the Value type is "C"
>>>
>>> When updating the DataSet now the errormessage is displayed in the debug
>>> window:
>>> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
>>> 'N', got type 'C' (Herr)"
>>>
>>> Please help
>>>
>>> Regards
>>>
>>> Ingo
>>
>
--

[ignacio]

Ingo,
> there are too much incompatibilities like browses dont display the new
> record added to a DataSet with scope settings. I spent till now too much
> time for
> searching workarounds and adapting my sourcecode.
Sorry for that, our intention is that the new version would be completely compatible with Xailer 1. We are doing our best on that but as we said on our blog a lot of changes have been done on datacontrols and surely problem will arise on some users, that is your case I am afraid. BTW, we highly appreciate your feedback and we apologize for the extra work on your side.
> Isn't it possible to make Xailer 2 interoperable?
That is absolutely our target.
About your problem, I believe we found the error. Please modify yourself the TDbfDataset:Open method with the following code on line 272 aprox.:
WITH OBJECT ::AddField( aStruct[ nFor, DBS_NAME ] )
:cDisplayName := :cName
:cDbfName := :cName
:cType := aStruct[ nFor, DBS_TYPE ]
:nLen := aStruct[ nFor, DBS_LEN ]
:nDec := aStruct[ nFor, DBS_DEC ]
:lAllowsNull := .F.
:lEditable := .T.
:DefValue := XA_GetDefValue( :cType )
END WITH
(Text in red is the new code)
Our wait until next release that I hope it will be released shortly.
Again, sorry for any inconvenience.
Regards,
--
Ignacio Ortiz de Zúñiga
http://www.xailer.com
http:/xailer.info
> Isn't it possible to make Xailer 2 interoperable?
>
>> Could you try with TDBComboBox:nDataType = dtINDEX
>
> Is the same.
>
>
> Regards
> Ingo
>>
>> Regards,
>>
>> --
>> Ignacio Ortiz de Zúñiga
>> http://www.xailer.com
>> http:/xailer.info
>>
>> "Ingo" <info@mandantwin.com> escribió en el mensaje de
>> noticias:4a86f35e$[email=1@svctag-j7w3v3j....]1@svctag-j7w3v3j....[/email]
>>> Ignacio,
>>>
>>> TDBComboBox linked with the numeric DataField "FC1"
>>>
>>> nStyle := csDROPDOWNLIST
>>> nDataType := dtDefault
>>> aItems := {"Herr","Frau"}
>>>
>>> On Append-mode the Control Value with old DataSet was "N"
>>> with new DataSet the Value type is "C"
>>>
>>> When updating the DataSet now the errormessage is displayed in the debug
>>> window:
>>> "#1: XAILER Fieldput error: Data type error on field 'FC1'. Expected type
>>> 'N', got type 'C' (Herr)"
>>>
>>> Please help
>>>
>>> Regards
>>>
>>> Ingo
>>
>
--