Dale
Tue Jan 11 10:33:34 CST 2005
I went to Oracle's site and downloaded the most current driver, and retested
the problem and got the same results. So I just made a quick program change,
and when a new record is added, it will automatically put a period in the
field, so that no memo field is going to be blank.
"Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
news:edPtrxI9EHA.1084@TK2MSFTNGP15.phx.gbl...
> Not sure, maybe I'd try the different Oracle 9i ODBC driver versions
> vs. the MS ones first.
> And also if (the new datatypes of) Vfp9 RTM or Public Beta would
> work for you. See also
>
http://groups.google.com/groups?as_q=oracle%20odbc%20memo%20char*&as_ugroup=*fox*
> If nobody else jumps in, I believe it might make sense to post a new
> thread with the Oracle ODBC issue in the subject line?
>
>
> -Stefan
>
> "Dale Clarkston" <dclarkston@lcounty.com> schrieb
> > Quick update on my issue. I now realize it is not centered around the
> > editbox control. I tried using the exact same properties with a textbox
and
> > the listbox and got the same results. So I went into the remote view
> > settings and change the field type for the field from Memo to Character.
> > This solved the issue. Is there some kind of weird problem when bringing
in
> > .NULL. data with a Memo data type,from an Oracle database into a remote
> > view?
> >
> > Thanks again for the help,
> > Dale
> >
> > "Dale Clarkston" <dclarkston@lcounty.com> wrote in message
> > news:uWLwcMA9EHA.2012@TK2MSFTNGP15.phx.gbl...
> >> The prg worked without a problem. I did forget one piece of vital
> >> information. The table is a remote view of a oracle 9i table. I have
set
> > the
> >> default value for the field in oracle to ' '. But in the remote view it
is
> >> still showing up as a .NULL. so when I change the displaynull property
for
> >> the editbox to ' '. It still acts like the control is disabled. I know
it
> >> has something to do with the Null value, because I can change the exact
> > same
> >> record that I am having problems with and just add a character to that
> > field
> >> and the editbox is enabled again.
> >>
> >>
> >> "Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
> >> news:ehIzL188EHA.3592@TK2MSFTNGP09.phx.gbl...
> >> > "Dale Clarkston" <dclarkston@lcounty.com> schrieb im Newsbeitrag
> >> > news:u%23I0Lf08EHA.2900@TK2MSFTNGP09.phx.gbl...
> >> > > Using VFP 6.0, I have an editbox on a form and everytime the
control
> >> source,
> >> > > which is tied to a field in a table, is .NULL. I can not change/add
> > any
> >> > > information in the editbox. Is this a bug with VFP6.0 and if so, is
> >> there a
> >> > > way around this?
> >> >
> >> > Does the test.prg below work for you? It does for me in Vfp9 and
> >> > Vfp6, i.e. typing new text works and also using Ctrl+0 afterwards
> >> >
> >> >
> >> > -Stefan
> >> >
> >> > LOCAL oForm as Form
> >> > oForm = CREATEOBJECT('TestForm')
> >> > oForm.Show(1)
> >> > RETURN
> >> >
> >> > DEFINE CLASS TestForm as Form
> >> > AutoCenter = .T.
> >> > PROCEDURE Load
> >> > LOCAL i
> >> > CREATE CURSOR temp (test M NULL)
> >> > INSERT INTO temp VALUES (.NULL.)
> >> > ENDPROC
> >> >
> >> > ADD OBJECT Edit1 as Editbox WITH ;
> >> > Left = 50, Top = 50, ;
> >> > ControlSource = 'temp.test'
> >> > ENDDEFINE
> >> >
> >>
> >>
> >
> >