Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10606

Help on saving an array element to table

From "Jose F Zouain" <jfzouain@zetaconcepts.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Help on saving an array element to table
Date 2017-05-27 00:20 +0000
Message-ID <eorv1vF5phcU1@mid.individual.net> (permalink)

Show all headers | View raw


Hi Guys

I am still rusty, don't know why is giving me an error.

Have a multi-dimension array, all elements are string:

 aTranscod :={{"Purchase Order","PO"},;
 		{"Invoice","IN"},;
 		{"Return Sales","SR"},;
		{"Sales Order","SO"},;
 		{"Repair Order","RO"},;
 		{"Out Rental","RT"},;
 		{"In Rental","RI"}}


Already have the value in mememory for the first element of the 7
values in the array which is SELF:oDCTRANSCOD:TextValue

Now I want to save the second element to the table, this is what I am
doing and is giving me an error:


	LOCAL n AS DWORD
	n := AScan(aTranscod, SELF:oDCTRANSCOD:TextValue)

The ascan should return a value

Then want to save the second element of the value to the Table

SELF:oDBServer:FIELDPUT(#TRANSCOD, aTranscod[n,2])

I think I am scanning incorrent the array, the value in memory whic is
SELF:oDCTRANSCOD:TextValue, can be Purcase Order, Invoice, etc.

I did this and is giving me a compiled error:
n := AScan(aTranscod, {|aVal| aVal[2] = SELF:oDCTRANSCOD:TextValue})
Want to save for Sales Order, "SO" in #TRANSCOD	

Some help please, thanks

Jose

 
-- 

Back to comp.lang.clipper.visual-objects | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

Help on saving an array element to table "Jose F Zouain" <jfzouain@zetaconcepts.com> - 2017-05-27 00:20 +0000
  Re: Help on saving an array element to table Sherlock <sherlock@sherlock.com.au> - 2017-05-27 00:07 -0700
    Re: Help on saving an array element to table Sherlock <sherlock@sherlock.com.au> - 2017-05-27 02:37 -0700
      Re: Help on saving an array element to table "Karl-Heinz" <invalid@invalid.invalid> - 2017-05-27 12:10 +0200
  Re: Help on saving an array element to table Franz Rachbauer <office@rachbauer.org> - 2017-05-27 09:28 +0200
  Re: Help on saving an array element to table Steve <steven_emmett@yahoo.co.uk> - 2017-05-27 00:36 -0700
  Re: Help on saving an array element to table Steve <steven_emmett@yahoo.co.uk> - 2017-05-27 00:53 -0700
    Re: Help on saving an array element to table "Jose F Zouain" <jfzouain@zetaconcepts.com> - 2017-05-28 00:54 +0000
      Re: Help on saving an array element to table JohnMartens <martens@tennishulp.info> - 2017-05-28 08:31 +0200
      Re: Help on saving an array element to table Mathias <mathias.hakansson@consultec.se> - 2017-05-30 00:28 -0700
        Re: Help on saving an array element to table "Jose F Zouain" <jfzouain@zetaconcepts.com> - 2017-05-31 11:42 +0000
  Re: Help on saving an array element to table [OT] "Karl-Heinz" <invalid@invalid.invalid> - 2017-05-28 09:59 +0200

csiph-web