Updating records

Questions and Answers about DataEase for DOS

Updating records

Postby koshita » Fri Feb 28, 2014 12:06 am

Can you write a DQL procedure to read in an external file to update certain fields in the database? I am new to DQL procedures.

Thank you, Kenny O.
koshita
 
Posts: 5
Joined: Tue May 22, 2012 11:18 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Updating records

Postby Phil Winkler » Fri Feb 28, 2014 12:49 am

Kenny, look at the Import method under database utilities. Assuming you have a primary key you could either import directly to the form or, better yet, import to a holder form identical to your data file (Fieldname=fieldname) and then use DQL to process the data to the destination form.

Press Help frequently as you go along for context sensitive help.

Where are you located?

Phil
Phil Winkler
PLM Consulting, Inc.
pwinkler@plmconsulting.com
Phil Winkler
 
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: Updating records

Postby KjetilUrne » Mon Mar 03, 2014 7:43 am

He probably didn't move from LA since the middle of last week, Phil :lol:
KjetilUrne
 
Posts: 602
Joined: Mon Oct 08, 2007 8:21 am
Location: Norway
Has thanked: 4 times
Been thanked: 1 time
 
 

Return to DataEase for DOS

Who is online

Users browsing this forum: No registered users and 1 guest

cron