• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

File Key

rwellsw

Active Member
I now can explain my problem better.

I am developing a new program that will update files that I have created.

During the developement procedure it was decided that I needed an additional field in the key of the new file.

I added a new key to the file. Recompiled the file and made sure that the only view over the file contained the new keys. I also have deleted glbtbl and glbltbl from my developement pc and allowed the files to be refreshed.

I then went into my program and placed the view on the form and made sure that all of my links, field etc were correct. I validated all of the event rules with no errors.

Now I come out and try to run the program in OMW and it gives me a message that the column does not exist.

I suspect that somewhere there is a old file - new file confilct.

I do not have the option of going back to the original version as this is new developement.

Any suggestions or help would be appreciated. They don't teach you this in school.

Thanks
Roger

B7333 SP13 OneWorldXe.
 

got_to_love_jde

Reputable Poster
Just a thought roger,
did you do a server pack for the new table and bsvw ? also, did you delete ddict* and ddtext* and let that rebuild ?
good luck,
dave


NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4, Citrix 1.8 (XE soon)
 
Hi you need to recreate the BSVW again


Regards




rwellsw <rwells@dkmail.com>@jdelist.com on 08-03-2001 07:26:01 PM

Please respond to jdeowdev@jdelist.com

Sent by: owner-jdeowdevml@jdelist.com


To: jdeowdevml@jdelist.com
cc:
Subject: File Key


I now can explain my problem better.

I am developing a new program that will update files that I have created.

During the developement procedure it was decided that I needed an
additional field in the key of the new file.

I added a new key to the file. Recompiled the file and made sure that the
only view over the file contained the new keys. I also have deleted glbtbl
and glbltbl from my developement pc and allowed the files to be refreshed.

I then went into my program and placed the view on the form and made sure
that all of my links, field etc were correct. I validated all of the event
rules with no errors.

Now I come out and try to run the program in OMW and it gives me a message
that the column does not exist.

I suspect that somewhere there is a old file - new file confilct.

I do not have the option of going back to the original version as this is
new developement.

Any suggestions or help would be appreciated. They don't teach you this in
school.

Thanks
Roger

B7333 SP13 OneWorldXe.



--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OWDEV&Number=6940
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************





____________________________________________________________________________
For your protection, this e-mail message has been scanned for Viruses.
Visit us at http://www.neoris.com/



CNC Specialist
 

rwellsw

Active Member
Yes I did delete the ddict* and ddtext* but no success. The other questions I do not understand. Our data is on a AS400.

Roger
 

rwellsw

Active Member
I don't know how to recompile a business view but I did make a new one and try it and still no luck.

Roger
 

got_to_love_jde

Reputable Poster
I thought that you might need to create a server package to let your as400 know of your table and bsvw changes.
dave


NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4, Citrix 1.8 (XE soon)
 

Zoltan_Gyimesi

Legendary Poster
Roger,
I do not know how things of XE go on AS400, we are on NT but:

1.) Have you tried to use your BSVW with a brand new APPL?
2.) Get/Check-Out the BSVW instead of spec delete when you created it on an other machine.
3.) Validate ER sometimes not enough. Try to double click all rows in your ERs and verify the statements in the popped-up windows.

Good luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

pcaenaro

Well Known Member
Hi Roger,

I had similar problems with the AS400. We had to delete the SQL packages on
the AS400.
You have to do that each time you make changes to a table design

Regards

Philippe
----- Original Message -----
From: "rwellsw" <rwells@dkmail.com>
To: <jdeowdevml@jdelist.com>
Sent: Thursday, March 08, 2001 12:37 PM
Subject: Re: File Key


> I checked on the AS400 and it has the new fields like I want.
>
> Thanks
> Roger
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=6957
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************



One World B733 Oracle 8.1 RS6000
 

rwellsw

Active Member
Our Adm person says we do this each weekend. So I will see if my program works on monday morning.

Thanks for the suggestion. It appears that this may be our problem.

Roger
 

pcaenaro

Well Known Member
Keep us posted

Regards

Philippe
----- Original Message -----
From: "rwellsw" <rwells@dkmail.com>
To: <jdeowdevml@jdelist.com>
Sent: Friday, March 09, 2001 6:39 AM
Subject: Re: File Key


> Our Adm person says we do this each weekend. So I will see if my program
works on monday morning.
>
> Thanks for the suggestion. It appears that this may be our problem.
>
> Roger
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=7004
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************



One World B733 Oracle 8.1 RS6000
 

WSchmatz

Active Member
I have had a similar problem. Try to delete the SQL PKG in your data library.

Bill Schmatz




Bill Schmatz
Business Systems Solutions, Inc

B733 Base (upgrading to B7332), AS400
 

pcaenaro

Well Known Member
Hi Roger,

If you refer to the deletion of SQL packages, I have attached a document to
this message.
I think the forum supports attachments... if you can't see it, give me an
email address where I can send it
Else, the document comes from JDE's response line, if I am not wrongm so you
can try to get it from them.

Regards

Philippe
----- Original Message -----
From: "rwellsw" <rwells@dkmail.com>
To: <jdeowdevml@jdelist.com>
Sent: Friday, March 09, 2001 6:06 AM
Subject: Re: File Key


> This is something I have not done. Can you tell me how to do this on the
AS/400?
>
> Thanks
> Roger
>
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=7001
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>



One World B733 Oracle 8.1 RS6000
 

Adrian_Chimirel

Legendary Poster
Hi Philippe,
Your attachment is missing: the Forum suports it, indeed, the List does NOT.
Regards,

Adrian Chimirel
Programmer Analyst
LIVE: B732.1 SP12.2, Oracle 806
SANDBOX: XE SP13, 8i
RS/6000, Citrix, 200+ clients
 

pcaenaro

Well Known Member
Hi List,

here's the attachment about the SQL Packages on AS400 (and how to delete it...)

Regards

Philippe

One World B733 Oracle 8.1 RS6000
 

pcaenaro

Well Known Member
That's fixed Adrian (I was just hoping that sending to the message to the
Forum would allow me to send the attachment...)

Cheers

Philippe
----- Original Message -----
From: "Adrian_Chimirel" <adrian.chimirel@home.com>
To: <jdeowdevml@jdelist.com>
Sent: Monday, March 12, 2001 7:47 AM
Subject: Re: File Key


> Hi Philippe,
> Your attachment is missing: the Forum suports it, indeed, the List does
NOT.
> Regards,
>
> Adrian Chimirel
> Programmer Analyst
> LIVE: B732.1 SP12.2, Oracle 806
> SANDBOX: XE SP13, 8i
> RS/6000, Citrix, 200+ clients
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Numbe
r=7102
> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
>



One World B733 Oracle 8.1 RS6000
 

srijde

Active Member
Hi List,
I have created a file and did an interactive application. After that changed the file by deleting a field and adding new one.
Now the program does not update or add and it says "Column does not exist".

What is the resolution to this problem?

Thanks
Sriram.
Oneworld XE SP19, AS/400,Citrix.
 

Frosty the Coder

Legendary Poster
A bit ago, this was covered extensively.

Try checking the table in/out as table specs don't
get updated ON THE SERVER until you do. What's
misleading is that UTB shows the columns, as
UTB uses local specs.

Gene
 

srijde

Active Member
I tried all sort of things. Do you mean Check in and out of the table specs? If yes, I did that no success. I see some replies in this thread saying the SQLPKG needs to be deleted. How to do this?

The following tricks I tried and does not succeed.
1) Deleting the global tables
2) Deleting the ddtext*, dddict*
3) Deleting the table in the BSVW and adding it again

Thanks
Sriram.
OW XE SP19, AS/400, Citrix.
 
Top