dbTalk Databases Forums  

Update process, remote file index lookup?

comp.databases.pick comp.databases.pick


Discuss Update process, remote file index lookup? in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dale Benedict
 
Posts: n/a

Default Update process, remote file index lookup? - 02-09-2006 , 11:47 AM






Okay, I know a lot of ya just don't use the update processor much as a data
entry interface, but I'm hoping someone knows the answer to my question.

What I'm trying to do is have a data entry field that is indexed on a remote
file that I'm using for a code lookup. I'm also wanting to have the
description from that remote file to be displayed during data entry (I've
got this part working), but I also want the description to change with every
keystroke whenever I cruise the remote index. Currently I must leave the
data entry field before the description text gets displayed.

The dictionaries I'm have are:
ticket
001 s
002 4
003
004 c;
005
006
007
008
009 l
010 10
011
012
013
014 cu]isw.release,request.file,;a0

tkt.text
001 s
002 4
003
004 d;4
005
006
007 tsw.release,request.file,;x;;30
008
009 l
010 60
011
012
013
014 x

Does anyone have any ideas on how to get what I want done?

I hope all is clear. If not I'll try and clarify my problem.

Regards,

Dale



Reply With Quote
  #2  
Old   
Mark Brown
 
Posts: n/a

Default Re: Update process, remote file index lookup? - 02-09-2006 , 02:25 PM






try putting the translate correlative into the TICKET field

s
4

c;



tsw.release,request.file,;a1
l
10



isw.release,request.file,;a0

during data entry, enter partial code and hit ctl+U or ctl+Y to cruise up
and down the foreign list. The translate data will display, but the foreign
key will be placed into the record.

Tested just on in VME.


Mark Brown


"Dale Benedict" <dale_knowspam_benedict (AT) flightcraft (DOT) ca> wrote

Quote:
Okay, I know a lot of ya just don't use the update processor much as a
data
entry interface, but I'm hoping someone knows the answer to my question.

What I'm trying to do is have a data entry field that is indexed on a
remote
file that I'm using for a code lookup. I'm also wanting to have the
description from that remote file to be displayed during data entry (I've
got this part working), but I also want the description to change with
every
keystroke whenever I cruise the remote index. Currently I must leave the
data entry field before the description text gets displayed.

The dictionaries I'm have are:
ticket
001 s
002 4
003
004 c;
005
006
007
008
009 l
010 10
011
012
013
014 cu]isw.release,request.file,;a0

tkt.text
001 s
002 4
003
004 d;4
005
006
007 tsw.release,request.file,;x;;30
008
009 l
010 60
011
012
013
014 x

Does anyone have any ideas on how to get what I want done?

I hope all is clear. If not I'll try and clarify my problem.

Regards,

Dale





Reply With Quote
  #3  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: Update process, remote file index lookup? - 02-09-2006 , 03:51 PM



"Dale Benedict" wrote:
Quote:
Does anyone have any ideas on how to get what I want done?
Move to a real GUI?

Sorry, no clue.
T


Reply With Quote
  #4  
Old   
Dale Benedict
 
Posts: n/a

Default Re: Update process, remote file index lookup? - 02-09-2006 , 04:32 PM



Mark, thanks for the quick response!!!!

That's exactly what I need.

'cept maybe a typo in the correlative??? Or is that translation allowed in
the VME? I'm using Linux and use the regular tfile;x;;1

Hope all is doing well.

regards,

Dale




"Mark Brown" <mbrown (AT) drexelmgt (DOT) com> wrote

Quote:
try putting the translate correlative into the TICKET field

s
4

c;



tsw.release,request.file,;a1
l
10



isw.release,request.file,;a0

during data entry, enter partial code and hit ctl+U or ctl+Y to cruise up
and down the foreign list. The translate data will display, but the
foreign
key will be placed into the record.

Tested just on in VME.


Mark Brown


"Dale Benedict" <dale_knowspam_benedict (AT) flightcraft (DOT) ca> wrote in message
news:MeLGf.193304$AP5.169853 (AT) edtnps84 (DOT) ..
Okay, I know a lot of ya just don't use the update processor much as a
data
entry interface, but I'm hoping someone knows the answer to my question.

What I'm trying to do is have a data entry field that is indexed on a
remote
file that I'm using for a code lookup. I'm also wanting to have the
description from that remote file to be displayed during data entry
(I've
got this part working), but I also want the description to change with
every
keystroke whenever I cruise the remote index. Currently I must leave
the
data entry field before the description text gets displayed.

The dictionaries I'm have are:
ticket
001 s
002 4
003
004 c;
005
006
007
008
009 l
010 10
011
012
013
014 cu]isw.release,request.file,;a0

tkt.text
001 s
002 4
003
004 d;4
005
006
007 tsw.release,request.file,;x;;30
008
009 l
010 60
011
012
013
014 x

Does anyone have any ideas on how to get what I want done?

I hope all is clear. If not I'll try and clarify my problem.

Regards,

Dale







Reply With Quote
  #5  
Old   
Dale Benedict
 
Posts: n/a

Default Re: Update process, remote file index lookup? - 02-09-2006 , 04:59 PM



Tony,

Moving to GUI may be an option, but since 90+% of my work is in Pick BASIC,
I built a small update processor tool to help keep track of where my time is
going and track software request changes. (as long as I keep up on doing
the data entry into it). So a Pick solution works best for me. I don't
have to switch windows, etc, I can just stay in the CUI and keep the fingers
flying.

Don't know if you can create the same sort of mini system in a GUI screen
using Pick dictionaries, and three small programs with a total of 90 lines
of code?

regards,

Dale

"Tony Gravagno" <g6q3x9lu53001 (AT) sneakemail (DOT) com.invalid> wrote

Quote:
"Dale Benedict" wrote:
Does anyone have any ideas on how to get what I want done?

Move to a real GUI?

Sorry, no clue.
T



Reply With Quote
  #6  
Old   
Ross Ferris
 
Posts: n/a

Default Re: Update process, remote file index lookup? - 02-09-2006 , 05:05 PM



I would think you could probably do it with the same files &
dictionaries (with some extensions, so we knew which fields should be
drop-down translates from another file) and zer0 lines of code with the
right tool :-)

As to the different windows, it doest take much to ALT-TAB


Reply With Quote
  #7  
Old   
Mark Brown
 
Posts: n/a

Default Re: Update process, remote file index lookup? - 02-09-2006 , 05:29 PM



You can use full file pathing anywhere a file name is required on all D3
products, so you can translate to remote files with

Tacctname,filename,{datafilename if different};code;altreturnattr;returnattr

Doing well. Nothing a new hip wouldn't fix. Thanks for asking.

Mark

"Dale Benedict" <dale_knowspam_benedict (AT) flightcraft (DOT) ca> wrote

Quote:
Mark, thanks for the quick response!!!!

That's exactly what I need.

'cept maybe a typo in the correlative??? Or is that translation allowed
in
the VME? I'm using Linux and use the regular tfile;x;;1

Hope all is doing well.

regards,

Dale




"Mark Brown" <mbrown (AT) drexelmgt (DOT) com> wrote in message
news:FyNGf.6851$Jg.3492 (AT) tornado (DOT) socal.rr.com...
try putting the translate correlative into the TICKET field

s
4

c;



tsw.release,request.file,;a1
l
10



isw.release,request.file,;a0

during data entry, enter partial code and hit ctl+U or ctl+Y to cruise up
and down the foreign list. The translate data will display, but the
foreign
key will be placed into the record.

Tested just on in VME.


Mark Brown


"Dale Benedict" <dale_knowspam_benedict (AT) flightcraft (DOT) ca> wrote in message
news:MeLGf.193304$AP5.169853 (AT) edtnps84 (DOT) ..
Okay, I know a lot of ya just don't use the update processor much as a
data
entry interface, but I'm hoping someone knows the answer to my
question.

What I'm trying to do is have a data entry field that is indexed on a
remote
file that I'm using for a code lookup. I'm also wanting to have the
description from that remote file to be displayed during data entry
(I've
got this part working), but I also want the description to change with
every
keystroke whenever I cruise the remote index. Currently I must leave
the
data entry field before the description text gets displayed.

The dictionaries I'm have are:
ticket
001 s
002 4
003
004 c;
005
006
007
008
009 l
010 10
011
012
013
014 cu]isw.release,request.file,;a0

tkt.text
001 s
002 4
003
004 d;4
005
006
007 tsw.release,request.file,;x;;30
008
009 l
010 60
011
012
013
014 x

Does anyone have any ideas on how to get what I want done?

I hope all is clear. If not I'll try and clarify my problem.

Regards,

Dale









Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.