Programming with dBASE - datalinks do not work VisualDB ver 5.7

Author

datalinks do not work VisualDB ver 5.7

Peter L.

2006-03-14, 3:23 am

All forms and datalinks worked in ver.'s prior to VisualDbase 5.7.
We have a main.wfm, and lots of forms branching from
main.mnu menus. Every dbf is referenced in the QBE.

Users fill out the forms in which every field is datalinked to DBF.'s,
nothing sticks. Worked perfectly in ver 5.5, flawless.

Is there something different in 5.7? paths? HeLp......

Thanks, Peter L.

*Lysander*

2006-03-14, 3:23 am

Peter L. schrieb:

> Users fill out the forms in which every field is datalinked to DBF.'s,
> nothing sticks. Worked perfectly in ver 5.5, flawless.

What does it mean, please, "nothing sticks"??
Or, to be more precisely, what did work before, and what does not
work now?

Did you re-compile ALL your sources with the compiler of 5.7??

I remember that I was sticking with 5.5 because I just could not get
my quite huge application to run with 5.6; but the reason for this
was probably just me, and I did not know of any free newsgroup where
I could find help.

ciao,
André

Ken Mayer [dBVIPS]

2006-03-14, 9:23 am

Peter L. wrote:
> All forms and datalinks worked in ver.'s prior to VisualDbase 5.7.
> We have a main.wfm, and lots of forms branching from
> main.mnu menus. Every dbf is referenced in the QBE.
>
> Users fill out the forms in which every field is datalinked to DBF.'s,
> nothing sticks. Worked perfectly in ver 5.5, flawless.
>
> Is there something different in 5.7? paths? HeLp......

Make sure you're not closing your table(s) somewhere ...

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Peter L.

2006-03-14, 11:23 am

All the forms in our programs link entryfields to its corresponding
dbf's. (datalink property). All the forms that pop up as a result of clicking pushbuttons from main.wfm work fine. The user input gets to be stored in the DBF. When the form pop ups from the menus at main.mnu nothing gets recorded to the DBF. The user ent
ers input
at the fields, closes the form, comes back, and empty. Nothing
saved to the DBF.

Thanks.

Peter L.

*Lysander*

2006-03-14, 1:23 pm

Peter L. schrieb:
> All the forms in our programs link entryfields to its corresponding
> dbf's. (datalink property). All the forms that pop up as a result of clicking pushbuttons from main.wfm work fine. The user input gets to be stored in the DBF. When the form pop ups from the menus at main.mnu nothing gets recorded to the DBF. The user e
nters input

> at the fields, closes the form, comes back, and empty. Nothing
> saved to the DBF.

It means that the same routine/procedure works when called by a
pushbutton_onclick, but not when called by a menu_onclick? That's
weird, but pretty sure can be solved.

Did you recompile ALL objects with the 5.7 compiler??
That's essential.

Then look at the code which is responsible for SAVING the entries.
How does it reference the table (something like form.mytable... or
something like USE mytable in 1, SELECT 1)?

What is strange in any case is that you do not get any
error-message. Maybe you are writing the data to an empty buffer of
fields which never gets saved.

Somebody else who is/was using 5.7 should jump in here. Maybe before
you had something like autoedit always turned ON, and now it is
turned off.

I really do not remember.

sorry for not being of further help.
André

Peter L.

2006-03-15, 3:23 am

Sorry, my mistake, it si NOT working when called by a
pushbutton_onclick or when called by a menu_onclick.

This code has been working in visual dbase 5.5 under NT 4.0 for years, it does not work in visual dbase 5.7.under XP OS, User input is NOT recorded in the DBF. When debuggin everything looks normal??

A tiny sample:
=========
--This procedure is contained in a main.mnu. The main.wfm has
all the set procedure...additive...
--All the datalinks in cCards.wfm look like the few lines of code below.

Procedure CREDIT_CARD_PROCESSI
NG_OnClick
********************
********************
***
nCode = CODE
cLast = LAST
cFirst = FIRST
cOldAlias = alias()
cOldTag = tag()

select select()
use \business\cCards.dbf alias cCards
set order to code
if .not. seek(nCode)
append blank
replace CODE with nCode, ;
LAST with cLast, ;
FIRST with cFirst
endif

form.z = new CcardsForm()
form.z.mdi = .f.
form.z.sysmenu = .t.
form.z.TheCode = nCode
form.z.Readmodal()

select cCards
use

select (cOldAlias)
set order to (cOldTag)

form.z.Release()

====================
====================
========
Ccards.wfm, a few lines. Before CLASS there’s the automatic ** END HEADER....
*generated on .......
====================
====================
========
CLASS CCARDSFORM OF FORM
this.OnOpen = CLASS::FORM_ONOPEN
this.Left = 20.5
this.Top = 7.3525
this.Text = "CREDIT CARD DATA"
this.MenuFile = "\BUSINESS\CCARDS.MNU"
this.Height = 9.0586
this.Width = 70

DEFINE ENTRYFIELD ENTRYFIELD1 OF THIS;
PROPERTY;
OnGotFocus {;Keyboard "{Home}"},;
Left 33,;
Top 3.7637,;
DataLink "CCARDS->CARDNUMBER",;
Height 1.001,;
Width 34

*Lysander*

2006-03-15, 3:23 am

Okay, right away I must admit that I am quite clueless, about what could
be the reason. But there are still some corners left where to look.

So, you did not only upgrade from 5.5 to 5.7 but also from NT4 to XP.
Check very firmly if it could be a missing-rights-issue. You can best
check this if you make a test-run as administrator. Make sure that you
did not by coincidence delete the rights for "LOCAL SYSTEM" and such.
Does it work then?

add some lines to test the code.
For example, create a new table, just for testing, in the same folder as
where the application is. Change the program so, that you do not write
the credit card number to the cCards, but to this temp-table. Does it
work then?

If you are working with exact matches (seek) then you should hand all
values trim'med, like:
nCode = ltrim(rtrim(CODE))

Also try a bit of debugging your code. Catch the program execution on
several places to see what REALLY is the value and status of some objects.
For example here:

> if .not. seek(nCode)

go bottom // just for double security when testing...

> append blank
> replace CODE with nCode, ;
> LAST with cLast, ;
> FIRST with cFirst

** my memory might trick me, but wasn't there also a
** save-command in VdB 5.5?? Try explicitely saving the record

else
** display a message box saying that the value was found

> endif

I hope you will find the solution.

ciao,
André

Ken B

2006-03-15, 9:23 am

Does the 5.7 app work properly on the NT 4.0 machine?

Peter L.

2006-03-16, 7:27 am

Ken B Wrote:

> Does the 5.7 app work properly on the NT 4.0 machine?
>
>
I have never installed 5.7 on the NT 4.0. I just installed Visual
5.5 on XP and everything works fine. All datalinks work as expected.
Everything gets saved on DBF's as expected.

But....... I need to make it work with 5.7.

*Lysander*

2006-03-16, 7:27 am

Peter L. schrieb:

> I have never installed 5.7 on the NT 4.0. I just installed Visual
> 5.5 on XP and everything works fine. All datalinks work as expected.
> Everything gets saved on DBF's as expected.

Strange.
I remember the same situation when I wanted to upgrade from 5.5 to 5.6.
Couldn't get it to work and stuck with 5.5.

Later somebody told me that I had to _explicitely_ remove all object
files and explicitely compile them again with 5.6 and that indeed
worked; maybe you indeed overlooked any object file and that did not get
recompiled?

ciao,
André

2006-03-16, 7:27 am

HI,
Yes it does. What is youre particular problem. One thing I found out was
that NT4's long file names, were not the same as say win98. So a programm
could run flawlessly with long file names under win98, but choke in NT4

Robert

"Ken B" <bogus@nowhere.com> wrote in message
news:nwSlhBESGHA.2320@news-server...
> Does the 5.7 app work properly on the NT 4.0 machine?
>
>

Sponsored Links