HomeForum
Welcome, Guest

Updating dbf files
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Updating dbf files

Updating dbf files 1 year, 1 month ago #2427

  • Scott
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Karma: 0
Help me please

I am trying to update column rhomme from table secgs8418n with value taken from the column hrur_2003 of table sections. The two tables have the commun column value in ab_section. I use the following statement:

update secgs8418n a set rhomme = (select hrur_2003 from sections b where a_ab_section = b.ab_section)

The update is not done. Can you specify how to that type of update.

i am using Windows XP and the two tables are in dbf format with no indexes.

Thans for your attention

Scott

Re: Updating dbf files 1 year, 1 month ago #2428

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
1 This sql probably far too complicated for odbc drrver
2. is there any messages in log?
3. you are using very old version

Mike
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

"Pricing is an important aspect of our software investment program and DBSL exceeded our expectations in both performance and value for money."

Dana Sander,
ICT Manager

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top